Link to home
Start Free TrialLog in
Avatar of Dovberman
DovbermanFlag for United States of America

asked on

SQL Server 2008 Login Issue

I installed SQL Server 2008 on my new Windows 8 machine.

It had been installed on my Windows 7 machine and was running well for 3 years.

Here is the login error:

Cannot connect to ADMIN-PC1\MSSQLSERVER3.

A connection was successfully established with the server, but 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)

Explanation
The SQL Server client cannot connect to the server. This error could occur because the server is not configured to accept remote connections.

How do I configure the server to accept remote connections?User generated image
   
User Action
Use the SQL Server Surface Area Configuration tool to allow SQL Server to accept remote connections. For more information about the SQL Server Surface Area Configuration Tool, see Surface Area Configuration for Services and Connections.

Where do I find the SQL Server Surface Area Configuration tool ?
ASKER CERTIFIED SOLUTION
Avatar of Bradley Fox
Bradley Fox
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Dovberman

ASKER

I followed the steps and enabled TCP/IP.

>>Control Panel, Admin Tools, Windows Firewall With Advanced Security>>

The following error occurred:

TITLE: Connect to Server
------------------------------

Cannot connect to ADMIN-PC1\MSSQLSERVER3.

------------------------------
ADDITIONAL INFORMATION:

A connection was successfully established with the server, but 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)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476

I am not sure what to enter as the Login Name.

How can I find out what my Login Name is?  I set one up but forgot what it is.

Thanks,