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
- From: mina <minakshi.patil@xxxxxxxxx>
- Date: Tue, 7 Oct 2008 23:10:47 -0700 (PDT)
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
.
- Prev by Date: RE: When do I need to pin?
- Next by Date: Unable to create Word 2003 document using Automation after MS Office 2007 deinstallation
- Previous by thread: Need Help Using VB6 COM DLLs in C#
- Next by thread: Unable to create Word 2003 document using Automation after MS Office 2007 deinstallation
- Index(es):
Relevant Pages
|
Loading
