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: 426
sql-server
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