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.
CoderRollerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Tony303Commented:
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/
0
David Johnson, CD, MVPOwnerCommented:
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.
0
VirastaRUC Tech Consultant Commented:
Hi,

Please check the references below for your query

Using SQL Server in Windows 8 and Windows Server 2012 environments
http://support.microsoft.com/kb/2681562

SQL 2008 R2 on Windows 2012
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/7d79f3d7-ab9e-4468-805d-debbd4c57f24/sql-2008-r2-on-windows-2012

Is SQL 2008 compatible with Windows Server 2012?
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/8dfb2cc5-eac5-4d57-9dad-f858d3c0f0c8/is-sql-2008-compatible-with-windows-server-2012

Hope that helps :)
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

CoderRollerAuthor Commented:
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.
0
David Johnson, CD, MVPOwnerCommented:
you will have to forward port 1433 from the wan to the private ip of the sql server
0
CoderRollerAuthor Commented:
How do I set the private IP on Sql Server settings?
0
David Johnson, CD, MVPOwnerCommented:
you can't! the forwarding is in your router.
0
CoderRollerAuthor Commented:
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.
0
David Johnson, CD, MVPOwnerCommented:
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.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.