SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 SQL 2000 Restrict Client by IP Address/Network
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

TBD-SQL
Starting Member

3 Posts

Posted - 11/06/2012 :  08:55:59  Show Profile  Reply with Quote
We are in the process of troubleshooting connection problems across our VPN tunnel to one of our legacy SQL2000 db instances. We are able to verify that traffic is reaching the SQL2000 server, but our application is unable to establish a full SQL connection and properly allow the remote user to authenticate.

I'm a little hazy on the SQL2000 admin stuff, but is there a way within SQL2000 to prevent or allow clients to establish a connection to the db instance based source IP address or subnet? I am unable to locate anything other than the port SQL2000 will respond/listen to inside the SQL Server Network Utility.

TBD-SQL
Starting Member

3 Posts

Posted - 11/14/2012 :  11:29:34  Show Profile  Reply with Quote
It does not appear that SQL2000 has this capability. This topic should be considered closed.

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000