We help IT Professionals succeed at work.

SQL Install

noad asked
What is the best way to install SQL 2008 R2???

I have an IIS up and runing, should I install SQL on same box, or on a separate?
Should I even install then on diff boxes?

Thank you
Watch Question

Depends on anticipated load.  If you don't expect a heavy load, running on the same server will be fine.  If you do ... run separate servers.


If installed on a diff server, how would ti them in?
The connection string in your code would specify the server ... it needs to anyway.

Additionally, you would enable TCP-IP in the SQL Server.  As a security feature, that's disabled by default.  You would do that in SQL Server Configuration Manager.