Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
vexilar
Starting Member
1 Post |
 Posted - 2009-06-29 : 19:44:50
|
First off, I don't know much about networking which is probably why I am having problems. I do know that I have two computers that connect to the internet via a router. The IP of the computer running the SQL Server is 192.168.0.71 and the computer name is SEAN. The other computer is the one that is trying to connect to the SQL Server; it is named MATT and it's ip is 192.168.0.114. From MATT I can ping 192.168.0.71 and also I can ping this machine by typing 'ping sean'. When I do this it starts off by saying 'Pinging sean.gateway.2wire.net' etc. From SEAN I can ping 192.68.0.71 and also I can ping again using 'ping matt' but this time it says that I'm pinging a loopback 127.0.0.1 each time instead of matt's ip. Also here, matt is listed as 'matt.gateway.2wire.net'. I am hoping this background info is useful :-\. So the problem is, from my .NET application running on SEAN I can connect to the SQL Server running on SEAN (SEAN\SQLEXPRESS), but when I run the same .NET application on MATT, I have been unable to do the same. These are the connection strings I have tried: quote:
Data Source=\\SEAN\SQLEXPRESS;Initial Catalog=SmartBidDatabase;User ID=sa;Password=SmartBidNetwork Library=DBMSSOCN;Data Source=192.168.0.71,1433;Initial Catalog=SmartBidDatabase;User ID=sa;Password=SmartBidServer=Sean\SQLEXPRESS;Network Library=DBMSSOCN;Data Source=192.168.0.71,1433;Initial Catalog=SmartBidDatabase;User ID=sa;Password=SmartBid
I'm not sure if I'm doing something completely wrong with the connection string or if the network setup is getting in the way. With the last connection string I made sure to go into My Computer -> Manage -> Services and Applications -> SQL Server Configuration Manager -> SQL Server Network Configuration -> Protocols for SQLEXPRESS -> TCP/IP , and enable it with a port # 1433. Oh, and both computers are running XP with no firewalls on (not even Windows Firewall). Any help on this issue will be GREATLY appreciated.Thanks,Sean*EDIT* I had vista instead of XP listed for some dumb reason |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-07-08 : 13:35:31
|
| did u set sqlserver to allow remote connections?what's exact error message? |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2009-07-10 : 18:08:38
|
| You should not use the UNC naming pathsee www.connectionstrings.com |
|
|
|
|
|
|
Problem Connecting