How do you administer SQL Server 2000 remotely?

[edmicman]

There's a possibility that my company will be hosting a website and SQL Server 2000 instance for a business partner in the near future. We've always just accessed our databases locally, or through a company VPN if needed. I don't think we want to give this person VPN access, unless that can be locked down so all he could do is get into his database. I'm wondering, how do you usually go about setting up remote administration access to SQL Server databases? Can you just do it through TCP ports and Enterprise Manager? What about security issues? Any help or ideas would be awesome....thanks!

 

[Thor86]

With windows 2000 server or better you can run certificates server and issue 128bit SSL over any SQL administrative connections through SQL Enterprise Manager. SQL server also provide flexible user account access for each table/database.

 

[WannaFly]

depending on your VPN solution, it might be able to "block" that user from anything BUT the SQL server. thats the best option, imho.