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 |
|
freq
Starting Member
17 Posts |
 Posted - 2009-01-03 : 09:50:44
|
| I'm having a difficult time accessing sql server 2000 remotely.I'm using a custom .net application to access sql data.When I try to access sql using the external IP address it does not connect. Yet when I access via the internal (192.168.x.x, 1433) it works.I have another server running sql 2000 on my lan-and when I set my router to forward to that server's internal ip--it accesses the data with no problem.Then I reset the router to forward to the problem box it is unable to access the data.Is there an additional setting on sql 2000 that needs to be set to allow access from the internet? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2009-01-03 : 13:56:31
|
| webforms or winforms ?I doubt it has anything to do with remote connections.Put your connection string without the IP here or check this out, www.connectionstrings.com |
 |
|
|
freq
Starting Member
17 Posts |
Posted - 2009-01-04 : 08:31:02
|
[quote]Originally posted by afrika
webforms or winforms ?Tried again today and the problem seems to have resolved itself.Thanks for your assistance. |
|
|
|
freq
Starting Member
17 Posts |
Posted - 2009-01-04 : 09:57:59
|
| It seems that I've spoken too soon.Attempted again 30 mins later and the problem is still there.I've tried with both my winforms and webforms apps.I doubt that the connection string is the problem because using the same connection string I can successfully connect to my 2nd sql2000 server by changing the port forwarding on my router. |
|
|
|
ghemant
Starting Member
22 Posts |
Posted - 2009-01-06 : 07:14:02
|
| I dont recollect having configured SQL Server 2000 for remote connection, it must be something wrong with the connection string...could you pleae post the error message!!RegardsHemantgiri S. Goswamihttp://hemantgirisgoswami.blogspot.com/ |
|
|
|
|
|
|
Enabling Remote Connections on SQL Server 2000