July 31, 2009 at 8:43 am
I am unable to connect from a Sql Server 2005 Client to the server. It is throwing the following error:
"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (Provider:SQL Network Interfaces, error - 26 - Error locating Server/Instance specified) (Microsoft Sql server).
I have checked from SQL Server Surface Area Configuration, that the Remote connection is enabled for TCP/IP & Named Pipes. Still then it is throwing the error message.
Need urgent answer.
Thanks in advance.
July 31, 2009 at 8:52 am
Check whether the instance name is given correctly
July 31, 2009 at 8:54 am
Make sure SQL Browser service is running on the server and also If firewall is enabled on the server, you need to put sqlbrowser.exe and/or UDP port 1434 into exception.
SQL DBA.
July 31, 2009 at 9:08 am
The instance name is correct & the SQL Browser service is aloso running on the server. Still it is showing the error message while connecting.
July 31, 2009 at 12:46 pm
If it returns the message immediately, check the event log for error messages and ensure the instance is configured to accept connections locally and remotely through TCP/IP and named pipes (good to double check and make sure that you're editing the settings for the correct instance !). Try connecting using the ip address instead, and also using different methods of authentication.
If it's timing out after about 30 seconds the it's likely that the server\instance name can't be resolved. Try connecting to the IP and check the hosts file on your client to make sure it's not getting redirected anywhere else if you're using a server name or other dns entry. Check that the the instance name is correct (if you're using one)
Any firewalls likely to affect you?
And as above, ensure that the browser service is running if you're connecting to a named instance!
July 31, 2009 at 12:52 pm
Try using the IP address of the machine the AD server may not be mapping the name correctly.
July 31, 2009 at 3:46 pm
Find out the server name by logging into MAnagement studio on the box itself using SELECT@@servername.
Put that in and see if it connects..
July 31, 2009 at 3:53 pm
First of all try pinging your Server from the client machine...
If that succeeds then make sure your remote connections are enabled from Surface Area Configuration...
Double check and make sure the Servername and instance name you are giving is correct... Make sure your username and Password are correct... and try giving it like Servername\instancename (If it is Express edition think the default instance name is sqlexpress)... Nxt also try giving the servername as the IP Address...
If nothing works it should be the firewall blocking issue or the port number issue... Disable firewall or open it for the port you use for your instance... You can get the port number for your instance from SQL Server Configuration manager > SQL Server 2005 Network Configuration > Protocols for MSSQLSERVER > Right click on TCP/IP and choose properties > ON IP Address Tab you can get the IP Address and Port number...
Now try giving it like Servername\Instance,PortNumber e.g. Server01\Instance01,1433
This should get it right for you 🙂
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply