Error 26 - SQL Server Forums

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

Other SQL Server 2008 Topics

Error 26

Author

Topic

keepow
Starting Member

5 Posts

Posted - 2010-02-04 : 03:14:15

Hi there,
trying to connect with SQL Server managment studio express (2005) to a SQL Server 2008 (if this already is a problem please say so further reading not nessacery then :p). Basicly the problem i encouter is the following:

TITLE: Connect to Server
------------------------------

Cannot connect to XXXXXXXXXX.

------------------------------
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+SQL+Server&EvtSrc=MSSQLServer&EvtID=-1&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

I checked the named pipes they are enabled. Also made the exceptions in the firewall port 1433 TCP and 1434 UDP. SQL Browser is running as a service (not blocked).

Any ideas?

Grtz,
Keepow

Edit:
- i can login on the server itself with the account iam using, so its not password or account related imo.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-02-04 : 04:28:47

Is the SQL Server configured to allow remote connections?

--
Gail Shaw
SQL Server MVP

keepow
Starting Member

5 Posts

Posted - 2010-02-04 : 06:03:01

Yep it is.

When i portqry on port 1433:

C:\PortQryV2>portqry -n xxxxxxxxxxxxxxx -p tcp -e 1433

Querying target system called:

xxxxxxxxxxxxxxx

Attempting to resolve IP address to a name...

IP address resolved to xxxxxxxxxxxxxxx

querying...

TCP port 1433 (ms-sql-s service): NOT LISTENING

When i try it on port 1434:

C:\PortQryV2>portqry -n xxxxxxxxxxxxxxx -p UDP -e 1434

Querying target system called:

xxxxxxxxxxxxx

Attempting to resolve IP address to a name...

IP address resolved to xxxxxxxxxxxxx

querying...

UDP port 1434 (ms-sql-m service): LISTENING or FILTERED

Sending SQL Server query to UDP port 1434...

Server's response:

ServerName xxxxxxxxxxxxxxx
InstanceName SQL2008
IsClustered No
Version 10.0.2531.0
tcp 49229
np \\xxxxxxxxxxxxx\pipe\MSSQL$SQL2008\sql\query

^ +`

==== End of SQL Server query response ====

UDP port 1434 is LISTENING

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2010-02-04 : 06:35:44

You can't use SSMS 2005 to connect to 2008 database.

http://msdn.microsoft.com/en-us/library/ms365247.aspx

keepow
Starting Member

5 Posts

Posted - 2010-02-04 : 06:56:02

With 2008 same problem as 2005 same error.

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2010-02-04 : 07:16:28

I assume you are using the Instance name to connect? xxxxxx/SQL2008.

keepow
Starting Member

5 Posts

Posted - 2010-02-04 : 07:59:32

Well its a bit weird. When i try to connect xxxxx\SQL2008 is get error 26
when i try xxxxx/SQL2008 i get:

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 3)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=3&LinkId=20476

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2010-02-04 : 10:21:35

Sorry, got my \/'s the wrong way around..