troubleshooting Question

Creating a new instance in SQL Express 2005

Avatar of Dave Messman
Dave MessmanFlag for United States of America asked on
Microsoft SQL Server 2005
8 Comments1 Solution11756 ViewsLast Modified:
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
DBAduck - Ben Miller
SQL Server Architect

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 8 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros