Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
lawr01ence
Starting Member
2 Posts |
Posted - 2013-08-15 : 12:30:23
|
I installed Microsoft SQL Server 2012 developer edition on my laptop first, then I used the same CD Software to install it on my desk top computer at home. It works fine on my desk top computer, but when I wanted to work with SQL ON MY laptop it does not connect to the server,instead I always get this error message: 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: Shared Memory Provider, error: 40 - Could not open a connection to SQL Server) (.Net SqlClient Data Provider.What can I do? Thank youLOM |
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-08-15 : 12:53:53
|
I assume you are trying to connect to the server on the laptop. If that is the case, verify that the service is running. Start -> Run -> Services.msc and look for SQL Server (MSSQLSERVER) is running. |
|
|
lawr01ence
Starting Member
2 Posts |
Posted - 2013-08-18 : 17:48:34
|
Thank you for the advise, I did not see MSSQLSERVER running. Or could it be that I am having problems with firewalls issues from the laptop? quote: Originally posted by James K I assume you are trying to connect to the server on the laptop. If that is the case, verify that the service is running. Start -> Run -> Services.msc and look for SQL Server (MSSQLSERVER) is running.
|
|
|
jethrow
Starting Member
37 Posts |
Posted - 2013-08-18 : 18:45:18
|
Try going into SQL Server Configuration Manager. In SQL Server Services, make sure your SQL Server service is running. If it isn't, Start it. You should be able to do this directly from Services.msc as well.Microsoft SQL Server Noobie |
|
|
|
|
|