• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

How do you administer SQL Server 2000 remotely?

E

edmicman

Golden Member
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!
 
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.
 
depending on your VPN solution, it might be able to "block" that user from anything BUT the SQL server. thats the best option, imho.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top