Link to home
Start Free TrialLog in
Avatar of CoderRoller
CoderRoller

asked on

Sql Server 2008 configuration for being accessed remotely by multiple software clients

Hello,

I would like to know how to configure an instance of SqlServer 2008 to be used for multiple desktop applications remotely that will read/write from the database resident on it. The instance should be on a machine that runs Windows Server 2012. The customer has a public IP available.

If you could help me walk through the whole process I would appreciate it.

Thanks a lot.
Avatar of Tony303
Tony303
Flag of New Zealand image

I would download an evaluation copy and try it somewhere where it doesn't matter if you make mistakes.

Here is a video for a bit of an idea also.

http://www.youtube.com/watch?v=8WAdeP5YREo

But most of the config is "it all depends".
Do some reading about service accounts.

Here is another tips video.

http://www.brentozar.com/archive/2012/10/sql-server-installation-best-practices-video/
General Sql Server

in the sql server configuration enable tcpip connections
open firewall port 1433 tcp to outside the lan (not recommended)
you should use windows authentication ONLY and not sql server authentication  if you do enable sql server (sa) authentication you will need to use as long and complex a password as possible as the port will be scanned and you will have script kiddies trying to get in.

SqlServer 2008
I'm not sure if it is supported on WS2K12, if so then you must ensure it is fully patched before attempting to use it.
ASKER CERTIFIED SOLUTION
Avatar of VirastaR
VirastaR
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of CoderRoller
CoderRoller

ASKER

Hi guys,

Thanks for all the responses. How do I configure the public IP for this sql server instance so it can be accessed from anywhere in the internet?. I do know how to enable remote connections but the trickiest part is mapping it with its own IP.

Thanks for the insight.

Regards.
you will have to forward port 1433 from the wan to the private ip of the sql server
How do I set the private IP on Sql Server settings?
you can't! the forwarding is in your router.
Thanks ve3ofa, that's understood. How do I establish the Windows Authentication method outside the network (I understand it uses Windows Credentials to authenticate inside the LAN), to make it more secure?

Thank you.
you have to use sql server credentials or use a vpn from one to the other.

Since you are using multiple desktops then a vpn into your network seems appropriate.