cannot connect to server

Question

I just installed ms sql server 2008 R2 on a development PC.  From the PC I installed sql server on I cannot connect to the server. Using MS Sql Server Management Studio:
  Server type : Database engine

  Server name : MSSQLSERVER
  Authentication : sql server authentication
  login : sa

When I click connect, get the cannot connect to server error.  Named pipes, tcp/ip and shared memory are all enabled in sql server config manager.

Why can I not connect to the server?  I see it from sql server config manager. 

thanks,

 

 

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

Cannot connect to MSSQLSERVER.

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

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)

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

------------------------------
BUTTONS:

OK
------------------------------

Answer 1

Hello,

Did you  enable mixed authentication during setup?

http://technet.microsoft.com/en-us/library/ms188670.aspx

Use Configuration Manager to make sure SQL Server service is started.

http://msdn.microsoft.com/en-us/library/cc646023.aspx

Verify sa is enabled and the password is correct.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 2

Hello,

Did you  enable mixed authentication during setup?

http://technet.microsoft.com/en-us/library/ms188670.aspx

Use Configuration Manager to make sure SQL Server service is started.

http://msdn.microsoft.com/en-us/library/cc646023.aspx

Verify sa is enabled and the password is correct.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

How do I verify sa is enabled?

During setup I selected mixed authentication, entered "sa" as the user name and entered a password.

SQL Server (MSSQLSERVER) service state is "running"

 

Answer 3

Hello,

Do you have Norton Internet Security enable or similar firewall? Please disable it.

Run the following using Windows Authentication to enable sa:

ALTER LOGIN sa ENABLE;

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 4

Hello,

Do you have Norton Internet Security enable or similar firewall? Please disable it.

Run the following using Windows Authentication to enable sa:

ALTER LOGIN sa ENABLE;

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

I turned off windows firewall.  domain, private and public.

I cannot run the "alter login" command because I cannot connect to the server in Microsoft SQL server managment studio

http://msdn.microsoft.com/en-us/library/ms188670.aspx

thanks,

Does anyone ever get upset at microsoft for making sql server so difficult to use?  Is there an error log I can look at to see the specific cause of this error?

 

 

 

Answer 5

Hello,

Try the following:

http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/d6924155-64bf-4241-958f-2abb5dd42547  

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 6

Hello,

The following resources may help you too:

http://blogs.msdn.com/b/sql_protocols/archive/2007/03/31/named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server.aspx

http://ssat.codeplex.com/

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Answer 7

when I connect to server name i5 the connection works.

my PC is named "i5".  There are two SQL server instances. Names are SQLEXPRESS and MSSQLSERVER.   I was setting the server name to "MSSQLSERVER".

I do not know which sql server instance I am connecting to when I connect to server i5.

thanks for the help,

 

Answer 8

Hello,

You have two SQL Server instances (like saying two database servers) on that computer.

To connect to the default instance you can use “i5” or just the dot “.”. The default instance is “MSSQLSERVER”.

To connect to the Express instance, use ‘.\SQLEXPRESS” or “i5\SQLEXPRESS”.

Please make sure you have enable protocols on the Express instance if you can’t connect to it.

http://msdn.microsoft.com/en-us/library/ms165718(v=SQL.105).aspx

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com