June 17, 2009 at 4:42 am
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.
"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)"
then i did some changes in sql server 2005 express
1)with the help of sql server surface area configuration
- sun sql server browser automatically.
-set remote connection as TCP/IP and named pipes
2) restart sql server and browser
3) open windows firewall
4) add sqlserver.exe and sqlbrowser.exe in exception
5) open port 1434 as UDP and 1433 as TCP/IP
6) again restart sql server and browser
7) set TCP/IP enable
I am trying to connect my remote machine in peer to peer network.
But i am still facing same problem.
Is any body helps me to solve this problem .
Thanks you very much in advance
June 17, 2009 at 4:59 am
Hello,
Is the SQL Server listening on Dynamic Ports? If it is, and as you mentioned a Firewall, it might be best swapping it to a Static Port, and then grant an Exception for that Port in the Firewall as well.
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
June 17, 2009 at 5:10 am
check if the server is on network by using ping, then create a linked server, then there shouldn't be a problem in accessing this server, hope this helps
June 17, 2009 at 8:23 pm
Hello,
Can you try running
telnet from a remote machine .
This will tell you if your server is able to coomunicate with other systems on this port (1433)
There should not be a problem as you have already opened exceptions for this port, but always better to check this.
Thanks,
Mani
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply