We help IT Professionals succeed at work.
Get Started

Creating a new instance in SQL Express 2005

11,755 Views
Last Modified: 2010-10-25
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
Comment
Watch Question
SQL Server Architect
CERTIFIED EXPERT
Commented:
This problem has been solved!
Unlock 1 Answer and 8 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE