SQL 2005 on server 2000 small business

[Timmkatt]

Can SQL 2005 be installed and will it run on a 2000 small business server? The server already runs SQL 2000 which is integrated in the small business OS but we need to have SQL 2005 for some programs but also need continue to run SQL 2000 for others. I'm ok adding a second server for SQL 2005 but if we can save that expense and add it to the existing server that is OK too. Thank you for your help!

 

[gmmastros]

You can have multiple SQL Servers installed on the same computer. You can even install multiples of the same version on the same server. One thing to be aware of... you can only have one default instance installed on a computer. There's really nothing special about a default instance versus a named instance. Default instances of SQL Server usually use tcp/ip port 1433, named instances usually use something different. Also, the connection string you use for a named instance is slightly different than a default instance. All-in-all, this is nothing major.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom