Two SQL (2005 and 2008) on the same machine.

5 pts.
Tags:
SQL Server 2005
SQL Server 2008
We are planning to install some CRM software and it can only use 2005, however we will be upgrading to SQL 2008, is it possible to run 2 SQL versions (2005 and 2008) and is it a good idea from backup, maintenence and running. Will there be issues?

Answer Wiki

Thanks. We'll let you know when a new response is added.

There is no problem running one instance of SQL Server 2005 and one instance of SQL Server 2008 on the same machine. My laptop has both running on it and has since Beta 3 or so of SQL Server 2008.

The only thing you will need to worry about is setting up each instance so that they have enough memory so that they do not battle for memory. Also make sure that your disks are fast enough to handle the load from both applications at the same time (just like you would if they were in the same instance).

is no do not battle for memory. Also mang load from both applications one instance of SQL Server 2005 and one instance of SQL Server 2008 on the same machinememory so that tthey were in the samheyke sure that your disks are fast enough to handle the at the same time (just like you would if e instance).

Discuss This Question: 9  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Denny Cherry
    Denny Cherry has over a decade of experience managing SQL Server and is currently a Sr. Database Administrator and Architect at Awareness Technologies. Denny holds several Microsoft Certifications as well as being a Microsoft MVP.
    66,115 pointsBadges:
    report
  • Jmmejia
    Hi. I already have one SQL 2005 Express edition running. I need to install SQL 2008 full version at the same time. Is it possible? There are ports conflicts? Any recomendation to do that concerning the way it authenticates (Express and Full Version) Thanks a lot.
    10 pointsBadges:
    report
  • Denny Cherry
    Yes you can do this with no problem. Just make sure that the instance name of the new instance is different than the instance name of the old instance, or SQL will upgrade the old instance. You set the instance name during the installation. Each instance will listen on a different port number. Windows Authentication is always the recommended method to use, however using SQL Authentication for the Application account is very common.
    66,115 pointsBadges:
    report
  • Jwright005
    Mr. Denny, When you said that "each instance will listen on a different port number" Could you please elaborate? Do you have to manually configure this to happen? Do you have to then modifiy the connections to the database to listen on this alternate port? (Rather than the default 1433) Thanks for your input.
    10 pointsBadges:
    report
  • Denny Cherry
    No you don't have to configure this to happen. By default named instances will select a random, un-used TCP port number to use. When you connect to a named instance the client automatically contacts the SQL Browser running on the server to and asks it what the TCP port is that the named instance is listening on. You don't have to do anything to make this happen, the SQL driver does all of this automatically.
    66,115 pointsBadges:
    report
  • Lorisj33
    Mr. Denny, Is it acceptable to run SQL 2005 and SQL 2008 side-by-side on the same MS cluster (single-instance) cluster in production? At least temporarily until all SQL 2005 DB appl vendors are approved on SQL 2008. I know there were issues and recommendations to Not do this with SQL 2000 and 2005 because they were so different. Any issues we need to know about? Thank you! Lori
    25 pointsBadges:
    report
  • MelanieYarbrough
    Hi Lorisj33, Please start a new thread for your question to ensure that it gets the proper attention it deserves. If you'd like to direct it at Mr. Denny, tagging it with SQL Server tags will surely alert him to your question. I can also send him the link via Twitter. Thanks! Melanie
    6,345 pointsBadges:
    report
  • Lorisj33
    Thanks Melanie! :) Will do a new thread now.
    25 pointsBadges:
    report
  • DeepaliHawal1
    Is it possible to install SQL server 2008 and sql server 2008 on same server?
    10 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following