4 มีนาคม 2555 2:13Hi, 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)
4 มีนาคม 2555 5:54
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.
I hope this is helpful.
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
4 มีนาคม 2555 6:41ผู้ตอบ
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
Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/