N/APosted on - 09/18/2011
I'm running SQL Server 2008 and I've got this error. I am using XP Pre SP2.
Title: Connect to Server Cannot connect to (local). And a connection was successfully established in the server.
Then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 – No process is on the other end of the pipe.) (Microsoft SQL Server, Error:233) And also no available help in help page. I've been searching for a solution myself and still no hope and I can't find the way to solve this.
Please help me.
SqlServer2008 and I’ve got this error.
This error occurred because your server is not configured to accept remote connections. You can use the SQL Server Configuration Manager to configure settings that will allows SQL to accept remote connections. In the SQL Server Configuration Manager, check if Named Pipes and TCP/IP are enabled. The Surface Area Configuration Manager would indicate if SQL Express Instance is configured to accept remote connections.
To do this, go to the Menu and click Start > Programs > Microsoft SQL Server > Configuration Tools. Select SQL Server Surface Area Configuration; then click on Surface Area Configuration for Services and Connections. On the left hand pane, click on Remote Connections and select Local and Remote Connections. Select, Using both TCP/IP. Click on the Apply Button and Ok. When using the Configuration Manager, remember that you will need Administration Rights and Windows Authentication to edit the settings.