Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 Installing SQL exp with SQL server installed

Author  Topic 

shrikantgujar
Starting Member

2 Posts

Posted - 2009-03-16 : 02:37:09

We are facing an issue about SQL express installation. If SQL server 2005 is installed on the client machine, then the installation of the my application fails as SQL express 2005 installation fails.

if i try to install SQL express seperately (not a part of application setup) then i get the following error:

"To change an existing instance of SQL Server 2005 to a different edition of SQL2005 you must run SQL server 2005 setup from command line prompt and include the SKUUPGRADE=1 parameter"

So here are my primary thoughts on this:

1. There should be some way to connect to the client SQL express database through the SQL server 2005 engine.

2. Can SQL Express 2005 be installed as a named instance on a machine that already has SQL server 2005 installed ? (Though I dont think this can be done)

Any pointers ???

~ Shrikant
   

- Advertisement -