<div>
how about a You-tube Video<br />
<br />
<a href="http://www.youtube.com/watch?v=5Yq75lkXtL4?" rel="ugc">www.youtube.com/watch?v=5Yq75lkXtL4?</a>
</div>


<div>
You should be able to do this with <br />
<br />
setup /qn ADMINPASSWORD=Password1 INSTANCENAME=WSUS<br />
<br />
The options you have are in the code below.<br />
<br />

<pre><code class="code-1 nolinks" id="code-120969"><span>start /wait &lt;DVD Drive&gt;:\setup.exe /qn UPGRADE=SQL_Engine VS=&lt;VSName&gt; INSTALLVS=Analysis_Server </span>
<span>INSTANCENAME=MSSQLSERVER SQLACCOUNT=&lt;DomainName\UserName&gt; SQLPASSWORD=&lt;StrongPassword&gt; </span>
<span>ADMINPASSWORD=&lt;StrongPassword&gt; ADDLOCAL=Analysis_Server,AnalysisDataFiles,Client_Components </span>
<span>INSTALLASDATADIR=&quot;I:\DATA\&quot; INSTALLSQLDATADIR=&quot;I:\DATA\&quot; SQLCLUSTERGROUP=&quot;DomainName\GroupName&quot; </span>
<span>ASCLUSTERGROUP=&quot;DomainName\GroupName&quot; AGTCLUSTERGROUP=&quot;DomainName\GroupName&quot; </span>
<span>FTSCLUSTERGROUP=&quot;DomainName\GroupName&quot; SQLBROWSERACCOUNT=&lt;DomainName\UserName&gt; </span>
<span>SQLBROWSERPASSWORD=&lt;StrongPassword&gt; ASACCOUNT=&lt;DomainNane\UserName&gt; ASPASSWORD=&lt;StrongPassword&gt;</span>
<span> PIDKEY=&lt;pidkey value without a &quot;-&quot;&gt;</span>
</code></pre>
</div>


<div>
<a href="http://msdn.microsoft.com/en-us/library/ms144259.aspx" rel="ugc">http://msdn.microsoft.com/en-us/library/ms144259.aspx</a>
</div>


<div>
none of this is what I'm looking for . . . <br />
<br />
I've got SQL Express 2005 installed. &nbsp;When I open SQL Server Management Studio Express, it gives me the option to edit all the instances on the server, including the MSDE instances:<br />
<br />
SQLEXPRESS<br />
SHAREPOINT<br />
SBSMONITORING<br />
BKUPEXEC<br />
<br />
now, I want to create a new instance called BLACKBERRY<br />
<br />
Step by step, how do I do that?
</div>


<div>
dbaduck - where would I go to set that up? &nbsp;the directory where SQL Express unzipped itself to do the install?
</div>


<div>
For example, here is what the BB documentation says about how to create an MSDE database, I'm looking for something similar:<br />
<br />
Install an MSDE instance for the BlackBerry Enterprise Server.<br />
a. Go to the Microsoft Download Center and install MSDE 2000 Service Pack 4.<br />
Note: SQL Server 2000 Service Pack 4 release notes are located at the Microsoft Download<br />
Center.<br />
b. Locate the directory to which the files were extracted. The default directory is C:\SQL2KSP4<br />
\MSDE.<br />
c. At a command prompt, browse to the installation directory.<br />
d. Type setup SAPWD= instancename=BlackBerry<br />
Note: To install a named instance of MSDE with mixed mode authentication (required for<br />
MDSS), type the following:<br />
setup SAPWD= INSTANCENAME=&quot;instance_nam<wbr />e&quot; SECURITYMODE=SQL
</div>


<div>
I was looking for a more plain English explanation. &nbsp;But eventually, even if SQL Express is already installed - if you run the install again, it lets you create a new database.
</div>


<div>
<div class="content wysiwyg-content">
This question is as simple as it seems.<br />
<br />
I have SQL Express 2005 on my Win2k3 SBS box. &nbsp;I want to create a new instance that another program can attach to. &nbsp;How do I do that? &nbsp;For MSDE, I could run this:<br />
<br />
setup sapwd=&quot;password&quot; instancename=&quot;WSUS&quot;<br />
<br />
What is the SQL Express 2005 equivalent?<br />
<br />
More background - <br />
I'm installing Blackberry Professional on my Win2k3 SBS box. &nbsp;It requires a SQL database. &nbsp;When I try to create a new instance using MSDE, it fails. &nbsp;I have troubleshot that for hours and now I just want to try SQL Express 2005. &nbsp;But I can't create an instance. &nbsp;I have looked and looked for a simple answer to that question and found nothing.<br />
<br />
Please don't just send me to a link - put the relevant text in your answer. &nbsp;Thank you
</div>
</div>


This question is as simple as it seems.

I have SQL Express 2005 on my Win2k3 SBS box.  I want to create a new instance that another program can attach to.  How do I do that?  For MSDE, I could run this:

setup sapwd="password" instancename="WSUS"

What is the SQL Express 2005 equivalent?

More background - 
I'm installing Blackberry Professional on my Win2k3 SBS box.  It requires a SQL database.  When I try to create a new instance using MSDE, it fails.  I have troubleshot that for hours and now I just want to try SQL Express 2005.  But I can't create an instance.  I have looked and looked for a simple answer to that question and found nothing.

Please don't just send me to a link - put the relevant text in your answer.  Thank you

Creating a new instance in SQL Express 2005

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.