SQL Server: 2005 instance running, need 2008 instance to run instead

Question

I have both SQL Server 2005 and 2008 installed on my machine. Only the 2005 instance is being detected as running (via Windows apps, like Management Studio and LightSwitch). How do I change the running instance to the 2008 version?

In your Windows services, just stop the 2005 instance service, and start the 2008 instead. Also: if you have two instances, one of them must have an instance name by which you can access it, e.g. (local)\2008 or something - you picked that when you installed the SQL Server on your machine — marc_s
– marc_s, Commented Aug 12, 2011 at 19:05

Cade Roux · Accepted Answer · 2011-08-12 19:10:44Z

2

Sounds like your default instance is 2005. Your 2008 instance must be named instance:

http://msdn.microsoft.com/en-us/library/ms143531.aspx

You can connect to a named instance using the server\instance notation

http://www.compiledthoughts.com/2009/04/understanding-ms-sql-server-named.html

answered Aug 12, 2011 at 19:10

Cade Roux

90.1k42 gold badges186 silver badges268 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Handprint Over a year ago

I ended up uninstalling some kind of partial installation of 2008 and did a full installation of 2008 Developer with a new named instance. That did the trick.

Collectives™ on Stack Overflow

SQL Server: 2005 instance running, need 2008 instance to run instead

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related