SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 SQL SERVER CONNECTION PROBLEM
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

lawr01ence
Starting Member

USA
2 Posts

Posted - 08/15/2013 :  12:30:23  Show Profile  Reply with Quote
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 you


LOM

James K
Flowing Fount of Yak Knowledge

3568 Posts

Posted - 08/15/2013 :  12:53:53  Show Profile  Reply with Quote
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.
Go to Top of Page

lawr01ence
Starting Member

USA
2 Posts

Posted - 08/18/2013 :  17:48:34  Show Profile  Reply with Quote
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.

Go to Top of Page

jethrow
Starting Member

USA
37 Posts

Posted - 08/18/2013 :  18:45:18  Show Profile  Reply with Quote
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

Edited by - jethrow on 08/18/2013 18:46:01
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000