asked on

Can i run sql server 2012 Express on the same computer as 2008? and the same question for the sql management studio.

I have a dev computer that im running sql server 2008 on and i need to develop an app with a sql express 2012 db on the back. can i run both on the same computer, without issues. I also would like to run the 2012 management studio.

Thanks for your help in advanced.

David Todd

Hi,

I do that.

I have SQL 2008R2 and SQL 2012 on my workstation.

The management tools are separate.

Note that the 2012 config manager can see the 2008 instance as well, but not vice versa.

HTH
David

David Johnson, CD

as long as the instance names are unique then not a problem.. you cannot have two instance names of sqlexpress.

ASKER CERTIFIED SOLUTION

Mark Wills

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

David Todd

Hi,

Elaborating ...
I've installed SQL 2008R2 and SQL 2012 on my workstation and laptop.

I install the management tools from each. I've read that in the past building SSIS packages with the wrong version of BIDS could cause issues.

Now in each folder in the start menu SSMS etc is just named SQL Server Management Studio.

I copy them to the desktop as needed, and rename them like this:

Generally I use SQL 2012 SSMS as my main tool. I find that it connects to SQL2000 quite well. Only on occasions do I need to rdp to the server and use enterprise manager for SQL2000.

HTH
David