Error:26-error locating Server/Instance specified

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.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Error:26-error locating Server/Instance specified

Author

Topic

hayko98
Starting Member

29 Posts

Posted - 2011-12-07 : 20:01:56

Hi all
We are upgrading our prd server to 2008(from 2005).I installed SQL 2008 R2 SP1.Connecting remotely from prd box works fine. But when tiring to connect from my own workstation ,I am getting following 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
TCP—enabled
Named Pipe-Enabled
Allow remote connection-enabled.

Any idea how to fix this?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-12-07 : 20:05:31

You probably just need an alias. Try connecting with serverName,portNumber. If you that works, then you can add an alias for the same via SQL Server Configuration Manager on your workstation or a quick regedit change.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

hayko98
Starting Member

29 Posts

Posted - 2011-12-07 : 20:09:02

I am connecting with serverName\InstanceName.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-12-07 : 20:14:05

You've missed my point. Try connecting with serverName,portNumber. This is a test. If it works, then an alias will fix it. If it doesn't work, well we've got to do more troubleshooting.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

hayko98
Starting Member

29 Posts

Posted - 2011-12-07 : 20:19:04

I don't know how to connect with serverName,portNumber? like serverName\1433?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-12-08 : 12:30:20

No, just like I typed it. serverName comma portNumber. 1433 is very likely not your port. You can see the port in the SQL Server Error Log at startup or in SQL Server Configuration Manager.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

hayko98
Starting Member

29 Posts

Posted - 2011-12-08 : 12:53:09

This is what i found in Error Log.
Dedicated admin connection support was established for listening locally on port 51184.
In SQL server Configuration Manager,in TCP properties shows (SQL Native Client 10.0 Configuration\Client Protocols)"Defult Port 1433).When i connect with serverName,51184 i get this:

Cannot connect to xxserverName,51184.

------------------------------
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: TCP Provider, error: 0 - No such host is known.) (Microsoft SQL Server, Error: 11001)

hayko98
Starting Member

29 Posts

Posted - 2011-12-08 : 13:08:38

Why can i connect from one box(prod),but can't from another?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-12-08 : 13:24:56

Did you replace serverName with the SQL Server's host name?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

hayko98
Starting Member

29 Posts

Posted - 2011-12-08 : 13:26:12

tkizer
Almighty SQL Goddess