Allow and restrict remote sql server access

Posted by Michel on Server Fault See other posts from Server Fault or by Michel
Published on 2010-03-08T14:22:32Z Indexed on 2010/03/08 15:08 UTC
Read the original article Hit count: 383

Filed under:

Hi,

I want to expose my sql server instance via the internet. I've been programming asp.net to sql server for a long time, but for the first time i'm hosting the sql server myself instead of the clients server. So what i want to do is move my sql server from my dev machine at home to a virtual server (yet to hire). But of course i don't want anyone to just enter my sql server but just a few persons. So what i was thinking was to allow only a few ip addresses to the sql server instance.

Can anyone tell me how i can expose my sql server to the internet and limit the access to the instance to only a few ip addresses? And ehm, if you know even better ways to secure it, i'd be happy, because this is the first time for me :)

Michel

© Server Fault or respective owner

Related posts about sql-server