Had some problem connecting to SQL Server 2005 using SQL Server Authentication. Kept getting the error "No Process is on the Other End of the Pipe".
Found a solution in the following page
click here
1. Start SQL Server Surface Area Configuration Manager.
2. Click on Surface Area Configuration for Services and Connections.
3. Expand the Database Engine node.
4. Click on Remote Connections
5. Ensure that "Local and Remote Connections" is selected and also ensure that "Using both TCP/IP and named pipes" are selected.
No comments:
Post a Comment