Can I have...

Hi

Is it possible to have both sql server 2005 and sql server express 2005 installed on the same machine?

thanks

Yes.

SQL Server Express will install with a 'default' instance name of [.\SQLExpress]

And if you allow the SQL (non-Express) to use the 'default' instance, it will be know by the computer name.

|||

As long as you do not specify the non-SQLExpress instance to be the named "SQLEXPRESS" instance, you can install as many additional SQL Server non-SQLExpress instances in addition to the SQL Server Express one as the machine can take.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||Thanks guys.sql