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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Allowing remote access to domain SQL isntance??

Author  Topic 

o9z
Starting Member

23 Posts

Posted - 2010-12-30 : 10:45:29
Hello, I will be hosting a SQL database for another company. What is the proper and most secure way to do this? They host their own website, and the website will be querying our SQL server to return results. This is the first time I have been involved in something like this. Can anyone give me the rundown on what is needed? Thanks!

o9z
Starting Member

23 Posts

Posted - 2011-01-02 : 18:52:31
Anyone have anything on this? Just curious of best practices and proper implementation. Thanks
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-01-02 : 21:59:42
Setup the right firewall holes and you should be okay. Lock it down to the MAC address level over the SQL port.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -