Tuesday, March 3, 2009

Enable remote connections to the SQL Server 2005 instance that hosts the report server database

Click Start, point to Programs, point to Microsoft SQL Server 2005,
oint to Configuration Tools, and click SQL Server Surface Area Configuration Tool.

Click Surface Area Configuration for Services and Connections.

Open the folder for the SQL Server instance that hosts the report server databases.

Click 'Remote Connections' under 'Database Engine'

Click Local and Remote Connections.

Click Using both TCP/IP and named pipes.

Click OK, and then restart the service by selecting "service" and clicking the "Stop" button at the right pane.

click "Start" button after stoping it.

No comments: