468,537 Members | 2,109 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,537 developers. It's quick & easy.

An error has occurred while establishing a connection to the server.When connecting to SQL Server 2005, this failure may be caused by the factthat under the default settings SQL Server does not allow remote connections.

My application which is written in vb.net 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
Oct 8 '08 #1
0 4393

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by John Shadel | last post: by
reply views Thread by Tor Inge Rislaa | last post: by
5 posts views Thread by James | last post: by
1 post views Thread by NEWS | last post: by
13 posts views Thread by AAaron123 | last post: by
reply views Thread by NPC403 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.