July 24, 2012 at 12:14 pm
I have a Windows 2008 R2 Enterprise server 64bit with SQL 2008 R2 installed. It appears that the compact version was also initially installed for whatever reasons. I now need to install a separate instance with SQL 2005 installed. Are there any problems installing SQL 2005 after SQL 2008 has been installed? Also, I read somewhere that you can't have two named instances, that one has to be the default instance. I would prefer named instances for both. Is there any truth to that restriction? Thanks in advance.
July 24, 2012 at 12:15 pm
You can have multiple named instances, only one default instance.
July 24, 2012 at 12:25 pm
Thanks for the quick reply. As to the install question. Does it matter that SQL 2008 is already installed prior to installing SQL 2005? Any gotchas?
July 24, 2012 at 12:27 pm
sqlnovice2001 (7/24/2012)
Thanks for the quick reply. As to the install question. Does it matter that SQL 2008 is already installed prior to installing SQL 2005? Any gotchas?
I can't readily answer that question from experience, but you are supposed to be able to run them side by side.
July 28, 2012 at 9:25 pm
alexandert680@gmail.com7/24/2012)[/b]
sqlnovice2001 (7/24/2012)
Thanks for the quick reply. As to the install question. Does it matter that SQL 2008 is already installed prior to installing SQL 2005? Any gotchas?
I can't readily answer that question from experience, but you are supposed to be able to run them side by side.
[/quote]
I don't see an issue with installing multiple versions in the same box. You can have 50 instances in a stand alone server as per Microsoft and it does not have to be same versions.
Regards,
Tony Alexander.
Regards,
SQLisAwe5oMe.
July 29, 2012 at 12:34 am
sqlnovice2001 (7/24/2012)
Thanks for the quick reply. As to the install question. Does it matter that SQL 2008 is already installed prior to installing SQL 2005? Any gotchas?
SQL Server is a product containing a few features that can be installed multiple times as a default or named instance, like Database Engine, Reporting Services, and Analysis Services. These features are designed to be installed side by side with older and newer versions (and even different service pack versions) starting from SQL Server 2000.
Beside this there are few shared features that can be installed only once per computer, like SQL Server Management Studio (SSMS), Business Intelligence Development Studio, Integration Services, and SQL Browser. Be sure to install only the shared features of the newer version, e.g. do not overwrite with it an older version. Shared features are independent from instance features and can work with older versions. Some shared features like SSMS can also work with newer named instances and even with instances located on other computers.
It's best practice to perform the installation first on a test system before make changes to a production environment. Virtualized environments with snapshots and cloning are ideal for this.
SQL Server has good backwards compatibility. Although many features have been deprecated in every major release, not many have been removed yet. So as an alternative to installing SQL Server 2005, you can deploy SQL Server 2005 databases on SQL Server 2008 R2 with no problems. It will be converted automatically. The only catch is that you cannot restore or attach a newer version database to an older version of SQL Server.
However, if your not sure it's going to work correctly, take no changes and install SQL Server 2005 on a separate machine.
July 29, 2012 at 10:00 am
Arjen Krap (7/29/2012)
sqlnovice2001 (7/24/2012)
Thanks for the quick reply. As to the install question. Does it matter that SQL 2008 is already installed prior to installing SQL 2005? Any gotchas?SQL Server is a product containing a few features that can be installed multiple times as a default or named instance, like Database Engine, Reporting Services, and Analysis Services.
Per my understanding, you cannot install more than 1 default instance per box.
Someone please correct me if I am wrong.
Regards,
TA
Regards,
SQLisAwe5oMe.
July 29, 2012 at 12:49 pm
SQLCrazyCertified (7/29/2012)
Per my understanding, you cannot install more than 1 default instance per box.
Someone please correct me if I am wrong.
Regards,
TA
Yes, you are correct.
You can install zero or one default instance on one computer.
You can install zero or more named instances on one computer.
The maximum number of instances is limited by edition. If I recall correctly 16 for standard edition and 50 for enterprise edition.
July 29, 2012 at 1:02 pm
Arjen Krap (7/29/2012)
SQLCrazyCertified (7/29/2012)
Per my understanding, you cannot install more than 1 default instance per box.
Someone please correct me if I am wrong.
Regards,
TA
Yes, you are correct.
You can install zero or one default instance on one computer.
You can install zero or more named instances on one computer.
The maximum number of instances is limited by edition. If I recall correctly 16 for standard edition and 50 for enterprise edition.
Thanks for confirming....just to add more to what you mentioned above,50 instances for stand alone servers and 25 instances per cluster.
Regards,
TA
Regards,
SQLisAwe5oMe.
July 30, 2012 at 7:44 am
sqlnovice2001 (7/24/2012)
Are there any problems installing SQL 2005 after SQL 2008 has been installed?
as far as i remember the only known issues are with SQL Server 2000. If this is installed alongside 2008, 2000 must be installed first
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
July 30, 2012 at 8:08 am
Thank you all for your responses.
July 30, 2012 at 10:40 am
Arjen Krap (7/29/2012)
sqlnovice2001 (7/24/2012)
Thanks for the quick reply. As to the install question. Does it matter that SQL 2008 is already installed prior to installing SQL 2005? Any gotchas?...
Beside this there are few shared features that can be installed only once per computer, like SQL Server Management Studio (SSMS), Business Intelligence Development Studio, Integration Services, and SQL Browser. Be sure to install only the shared features of the newer version, e.g. do not overwrite with it an older version. Shared features are independent from instance features and can work with older versions. Some shared features like SSMS can also work with newer named instances and even with instances located on other computers.
...
For BIDS and SSMS, you can have one install from each version of SQL. i.e. On my Dev machine, I have BIDS 2005, BIDS 2008, SSMS 2005 and SSMS 2008. Not sure about Integration Services and SQL Browser though.
IMO, you really only need one version of SSMS but I'm inclined to keep both versions of BIDS to be certain of compatibility with our Reporting Servers.
July 30, 2012 at 11:13 am
Yes indeed, the client tools are installed in different directories like C:\Program Files\Microsoft SQL Server\{80, 90, 100, 110}.
Also BIDS uses Visual Studio and multiple versions of Visual Studio can be installed side by side.
Viewing 13 posts - 1 through 12 (of 12 total)
You must be logged in to reply to this topic. Login to reply