Could you please advise me how to set up a second instance of SQL Server
2005 ?
I have a new installation of Small Business Server 2008 R2, which already
uses SQL 2005 for it's sharepoint database I think.
I would like a second instance for use with my web site, and I do not want
it to interfere with the SBS instance.
Could you please provide a link to instructions, or if these do not exist,
please provide the basic procedure steps.
Thanks very much.

jrl (AT) nospam (DOT) nospam (jeffleese (AT) hotmail (DOT) com) writes:
Just run SQL Server Setup, and select to install a new instance. You should
probably only select Database Engine, and not include Analysis Services
and Reporting Services.

Don't forget to apply the latest service pack after the install!


--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx