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 |
|
singingpraju
Starting Member
4 Posts |
 Posted - 2009-05-15 : 09:51:02
|
| hi,I am trying to connect SQL server 2000 database with .Net 2005. now here is what i ve done.......i have connected 3 pc's in a network. one pc(say PC1) has sql server 2000 installed in it while PC2 and PC3 has .net 2003 & .net 2005 installed in it.I need to access sql server 2000 database using the .Net 2005 without having the need to install .Net or sql server on rest of the machines.i tried using the connection string which was s follow:-conn = "Server = 192.168.1.140;database = Northwind;uid = sa;pwd = sa"where 192.168.1.140 is the IP address of the PC1 having sql server installed in it.However i get a time out error when i try to connect using .ne2005can you please suggest me how can i achieve it. are there any configuration settings need to be done to access the sql server database.....all the suggesstions are welcomethanks in advance |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2009-05-18 : 11:18:00
|
| Any firewalls involved in any of these machines? if so, you will likely have to open up port 1433 TCP and probably 1434 UDP. You also can check to see if the SQL Server is actually listening on any protocol besides Shared Memory. To do this, look for the Server Network configuration tool in the SQL Server 2000 program group. |
 |
|
|
singingpraju
Starting Member
4 Posts |
Posted - 2009-05-18 : 13:24:31
|
quote:
Originally posted by mcrowley
Any firewalls involved in any of these machines? if so, you will likely have to open up port 1433 TCP and probably 1434 UDP. You also can check to see if the SQL Server is actually listening on any protocol besides Shared Memory. To do this, look for the Server Network configuration tool in the SQL Server 2000 program group.
Thank you for youtr prompt replycan you please elaborate on how can i enable the listening ports....i woud like to bring to your notice that the database is accessible by VS2003. so if the firewalls were enabled on other machines then the database shoud be inaccessible even by VS2003 (as in case of VS2005)and will making changes in the settings of cient network utility serve the purpose.thanks in advance |
|
|
|
singingpraju
Starting Member
4 Posts |
Posted - 2009-05-21 : 12:39:04
|
| hey thaks for the suggestion of turning off the firewll....it worked!!!!!!!n now i can connect to sql server via .Net2005 successfully |
|
|
|
|
|
|
Accessing sql server database in a network