SQL Server Error 26 troubleshooting checklist

28 May,2011 by Jack Vamvas

SQL Server Error 26  relates only to SQL Server Named instances. Not default instances

The main reason SQL Server Error 26  error message appears is that the client  can’t receive SQL Server Resolution Protocol(SSRP) response UDP packet from the SQL Browser Service

 

1) Check the server name is correct? Check spelling.

2) Check the SQL Server instance name , is there such an instance on the target server?

3) Can you ping the server? Is DNS resolvable? Sometimes ping isn’t possible as the administrator  disabled the ping service.

4) Is SQL Browser Service turned on?

5) Is the frewall enabled?If so , place sqlbrowser.exe or port 1434 into the exception list.

6) Is you server part of a Cluster?

 If after these steps the connection is still failing try:

tcp:SEVERNAME\INSTANCE_NAME

Add a comment , if you have a problem – and I’ll assist in troubleshooting.Or another SQL Server DBA will help

 This will give you some extra information to troubleshoot the SQL Server Error 26 message

Read More

Cannot connect to SQL Server

SQL Server - Login failed for user 'username'. The user is not associated with a trusted SQL Server connection

SQL Server Versions


Author: Jack Vamvas (http://www.sqlserver-dba.com)


Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on SQL Server Error 26 troubleshooting checklist


sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer