question

lawr01ence avatar image
lawr01ence asked

SQL 2012 developer edition Server connection problems

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 not on my laptop. 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 is the problem, what can I do? Thank you
sql-server-2012
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
Assuming the install worked, you are facing one of two issues. Either you don't have the server and instance name correct from the install or your login was not added as the administrator of the server. During the install you would have been asked if you wanted to give the instance a name. Without a name, the connection string should just be to your machine. You can even try just using a dot/period(.) as the server name. Assuming you didn't give it an instance name, this should work. If you gave it an instance name, you'll need the name of that instance. You can launch Configuration Manager. It should show you the server name and instance name, if any. If the login that the system is running under is different from your login, you just need to know which login is running the system. You can see this in the properties of Configuration Manager. Look at the properties for the server.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.