question

Gaylene McHugh avatar image
Gaylene McHugh asked

Can you run Sql Server 2000 & SQL 2005 Express simultaneously on the same server without any issues?

Can you run Sql Server 2000 & SQL 2005 Express simultaneously on the same server without any issues?

sql-server-2005sql-server-2000
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Matt Whitfield avatar image
Matt Whitfield answered

Yes. I'm not really sure there's much else that can be said.

Tim pointed out it might be worth saying that one has to be a named instance - express always installs as a named instance by default, so not much work there. Probably a good idea to make sure that the sql server browser service is running, too.

5 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Well, since they are asking, it might be worth pointing out that to do so one of them has to be a named instance. But the short answer is yes.
0 Likes 0 ·
Even though express always installs as a named instance by default anyway? I'll edit...
0 Likes 0 ·
The question is can you "run" them not "install" them. :-)
0 Likes 0 ·
And a version of 2008 express, and a full version of 2000, 2005 and 2008. I know because I've had all them running on one machine, all at the same time.
0 Likes 0 ·
i too agree,as i too running 2K and 2K5 on my machine.
0 Likes 0 ·
Ian Roke avatar image
Ian Roke answered

The answer to this question might help you.

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.