Do SQL Server 2005 Standard and SQL Server 2005 co-exist?

Do SQL Server 2005 Standard and SQL Server 2005 co-exist?

Post by WWFIb3puY » Tue, 05 Jun 2007 19:00:01


Hi, wonder if I can get some advice?

As I'm sure is the case with many others using these Newsgroups, I wear both
developer and dba hats. I wore my dba hat to install the SQL Server 2005
Management Studio tools on my workstation in order to administer the servers
I look after.

However I'm about to don my developer's hat to work on a small-scale app for
which I'm thinking of using SQL Server Express as the back-end for a Visual
Studio 2005-designed interface.

The question is, can I safely install SQL Server 2005 Express on my
workstation alongside the Standard edition? As far as I know the answer is
'yes' but I'd like to be sure before I do anything so would very much
appreciate some advice first.

Regards,

Gordon Feeney.
 
 
 

Do SQL Server 2005 Standard and SQL Server 2005 co-exist?

Post by Jens » Tue, 05 Jun 2007 20:43:54

Yes, this is possible:

http://www.yqcomputer.com/

"Multiple SQL Server 2005 Express installations can coexist on the
same machine along with other installations of SQL Server 2000, SQL
Server 2005, or Microsoft Desktop Engine (MSDE). "

Jens K. Suessmeyer.

---
http://www.yqcomputer.com/
---

 
 
 

Do SQL Server 2005 Standard and SQL Server 2005 co-exist?

Post by WWFIb3puY » Fri, 22 Jun 2007 17:33:01

Hi Jens. Sorry it's taken so long to reply - been on holiday :)

Would the SQL Server Express installation need to be a named instance?

Regards,

YaHozna.