[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 235
  • Last Modified:

Can you run multiple versions of SQL Server on a development machine?

Hello - I just re-loaded my laptop with Windows 7; I am supporting and developing app's that use Access 2003 & SS 2000, ASP.NET 2.0 and SS 2005, and I am about to start a project that will use ASP.NET 4.0 and SS 2008.

Are there any problems running these 3 versions together? Anything I should or shouldn't do?

Thanks
0
mlagrange
Asked:
mlagrange
  • 4
  • 3
  • 2
  • +1
1 Solution
 
Anthony PerkinsCommented:
You can.  Is performance going to suffer?  Probably.
0
 
mlchelpCommented:
yes, it will work but unless you have dual 6 cores and 32 gig of ram its going to be slowwwwwwwwwww LOL
0
 
mlagrangeAuthor Commented:
I'm not talking about running them at the same time; just having them all on my development pc.
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
Em ManCommented:
SQL Server 2000 and SQL Server 2005 can be installed together.

SQL Server 2005 and SQL Server 2008 can be installed together.

SQL Server 2000 and SQL Server 2008 can not be installed together. So you'll need to put either SQL 2000 or SQL 2008 on seperte machines.

The SQL Server 2008 Management tools can be used to manage SQL Server 2000 servers so Enterprise Manager isn't required.
0
 
Anthony PerkinsCommented:
>>I'm not talking about running them at the same time; just having them all on my development pc. <<
And how do you propose doing that?  Were you planning on stopping and starting the service every time?

>>SQL Server 2000 and SQL Server 2008 can not be installed together. <<
Really?  Any documentation to back that up?
0
 
Anthony PerkinsCommented:
But perhaps we need to backup here and ask for clarification.  If you are planning on installing just the client components of SQL Server and are connecting to remote servers, than you should be fine.  However, if you are planning on installing all three SQL Server Engines than performance could suffer and you would be very wise to limit the max memory used by each instance.  
0
 
mlagrangeAuthor Commented:
I have always started the 2000 engine manually, when there was something I needed to do on that app, and I never noticed any performance issues with just 2000 & 2005.

2008 is a new thing; I never had all 3 going on the same machine before; I guess I will start to the performance hit if/when I add 2008.  



0
 
Em ManCommented:
acperkins:

The reason it is not advisable to be installed on a same machine because instances needs to be rename to avoid problems, otherwise people having this kind of setup will have problems in a long run.

There are no documents to support it now, but in a production environment are you willing to risk having this kind of setup? (OT)
0
 
Anthony PerkinsCommented:
>>The reason it is not advisable to be installed on a same machine because instances needs to be rename to avoid problems<<
Why would you rename an instance?  Or more appropriately how would you propose doing that?

>>but in a production environment are you willing to risk having this kind of setup?<<
You need to re-read the question.  This is not for a production environment: "I am supporting and developing app's".
0
 
mlagrangeAuthor Commented:
I tried to install SS 2000 in W7, and got a "known compatibility issues" error message, so I guess that solves THAT issue; I've already got XP Mode going, so 2000 will just have to live on that "machine"

I was already doing most of the 2005 work on that clients' network over a VPN connection; I think I will stick with that

That just leaves 2008, which I will install on W7, and everything will live in peace & harmony, and I won't have any problems, again, ever...  bah-ha-ha-hahhhhhh....

Thanks, guys
0

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

  • 4
  • 3
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now