An error has occurred while establishing a connection to the server.When connecting to SQL Server 20



My application which is written in 2005 uses sql server 2005
express as a database, this application is multi-user. So i am used 3
xp machine to install my application i can say
machine1,machine2 ,machine3 on which i have install my application.
On machine1 i also install SQL Server 2005 express. Then run mu
application from machine1 which is locally its work fine. But i am
facing problem when i am trying to connect from the machine2, that
time i am getting an 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)"
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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question