M
mina
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
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