Allow and restrict remote sql server access
- by Michel
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