can not login to sql server by management studio

Question

Hi, I just installed SQL server R2 Express version. But I can not connect to the local by management studio. I have enabled TCP/IP through configuration manager, but also I cannot connect to it

It displays following error

Cannot connect to ..

 

===================================

 

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) (.Net SqlClient Data Provider)

Answer 1

Hi,

First go to Control Panel -> Administrative Tools -> Services and check if the service (with the correct instance name (check instance name) is running.

If you try to connect remotely check configuration of TCP/IP from SQL server configuration manager.

http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/e58e5d15-61d7-4d9e-a4b0-cc433e755ef1/

http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/eb510c42-1f1d-42d6-b599-4005e4d7dc36

I hope this is helpful.

Elmozamil Elamir

MyBlog

---

Please Mark it as Answered if it answered your question
OR mark it as Helpful if it help you to solve your problem
Elmozamil Elamir Hamid
http://elmozamil.blogspot.com

Answer 2

Could be Windows Firewall, look into ERROR.LOG to see what port SQL Server listens to and try specify in while connecting to SQL Server

Computer\SQLEXPRESS,2144

---

Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/