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)
 Problem to create/install a new instance wtih SQL

Author  Topic 

pb
Starting Member

13 Posts

Posted - 2009-06-19 : 20:28:52
Hi,

I am install an installer, inside which there is a SQL2005Express install process. But when a target system already has SQL2005Express installed, the installer will have trouble to install SQL2005Expr. The process invokes the following commandline:

SQLEXPR.EXE -q /norebootchk /qb reboot=ReallySuppress addlocal=all instancename=Instance_Name SCCCHECKLEVEL=IncompatibleComponents:1;MDAC25Version:0 ERRORREPORTING=1 SQLAUTOSTART=1 SAPWD=Some_PSWD SECURITYMODE=SQL DISABLENETWORKPROTOCOLS=0

Instance_Name and Some_PSWD are replaced for the posting purpose here.

If there is no installed SQL2005Expr, installation works fine; otherwise, the SQL2005Express install process will complain that there are contents in the folder [ProgramFiles]\Microsoft SQL Server\MSSQL.1\, if I (for testing purpose) delete the contents there, and click 'Retry' button, the SQL2005Express install complete successfully.

What I want here is that even there is an instance installed, my installer still go ahead install or create 'Instance_Name' instance for me. Is this a named instance? I don't know much about all the kinds of instances (default, named, user, etc.), but I want my instance to be a normal instance that bearing all the properties and features of SQL2005Express.

So is that doable via a commandline install? How should I modify the above command to accomplish it?


Thanks,
PB

HCLollo
Starting Member

49 Posts

Posted - 2009-06-24 : 09:11:22
Hmm...sorry, I'm getting a little rusty with the age but...why should you want to install another instance of SSEE on a box that
already has one?

Just my wondering...

HCL

"If it works fine, then it doesn't have enough features"
Go to Top of Page
   

- Advertisement -