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 |
|
bluesky
Starting Member
4 Posts |
 Posted - 2014-08-02 : 18:57:01
|
| Hi, I'm a new user of this program. I downloaded it and used it for a couple of days without any problems, but today the program won't allow me to connect. The message I receive is the following:TITLE: Connect to Server------------------------------Cannot connect to (myname-PC\nameofinstance------------------------------ADDITIONAL INFORMATION: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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476I did go to the "help" link but found it distinctly unhelpful. Here's what Microsoft had to say:ExplanationThe SQL Server client cannot connect to the server. This error could be caused by one of the following reasons: A specified SQL Server instance name is not valid. The TCP, or named pipes protocols are not enabled. The firewall on the server has refused the connection. The SQL Server Browser service (sqlbrowser) is not started. User ActionTo resolve this error, try one of the following actions: Check the spelling of the SQL Server instance name that is specified in the connection string. Use the SQL Server Surface Area Configuration tool to enable SQL Server to accept remote connections over the TCP or named pipes protocols. For more information about the SQL Server Surface Area Configuration Tool, see Surface Area Configuration for Services and Connections. Make sure that you have configured the firewall on the server instance of SQL Server to open ports for SQL Server and the SQL Server Browser port (UDP 1434). Make sure that the SQL Server Browser service is started on the server.I know that my instance name is correct, but I don't know how to check for the other things. Does anyone have any tips? |
|
|
MichaelJSQL
Constraint Violating Yak Guru
252 Posts |
Posted - 2014-08-03 : 17:01:30
|
| start with making sure SQL Server is up and running - http://technet.microsoft.com/en-us/library/ms190699(v=SQL.105).aspx |
 |
|
|
bluesky
Starting Member
4 Posts |
Posted - 2014-08-03 : 23:26:49
|
quote:
Originally posted by MichaelJSQL
start with making sure SQL Server is up and running - http://technet.microsoft.com/en-us/library/ms190699(v=SQL.105).aspx
I did try following these instructions, but no luck...Thank you, nonetheless. |
|
|
|
|
|
|
|
|
ms sql server 2012 connectivity