Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Does SQL Server 2005 Express have a problem with installing on single user systems?

share|improve this question
1  
Can you add more info to your setup, the problem you see etc? The simple answer is "no" but that won't help you... –  gbn Jan 3 '12 at 9:50
add comment

closed as not constructive by RolandoMySQLDBA, Derek Downey, Leigh Riffel, Marian, Martin Smith Oct 13 '12 at 8:36

As it currently stands, this question is not a good fit for our Q&A format. We expect answers to be supported by facts, references, or expertise, but this question will likely solicit debate, arguments, polling, or extended discussion. If you feel that this question can be improved and possibly reopened, visit the help center for guidance.If this question can be reworded to fit the rules in the help center, please edit the question.

2 Answers

Sql Server 2005 will install just fine on a single user system. A better question is why you would want to. Most of the time when I've seen people want to do this, they're using it as a simple data store for a desktop application they are building. If that's what you're doing, you should probably choose an in-process database like Sqlite, Sql Server Compact Edition, or even MS Access instead. Of course there are exceptions, but really if this is part of an app that must coexist with other apps on a machine that will serve as some user's primary desktop, you should really avoid trying to push a whole server at them.

share|improve this answer
add comment

If you are facing some sort of problem then look at the Microsoft documentation for How to: Install SQL Server Express to step by step approach and the compatibilities related information.

There are few links that will go through the detailed step by step approach of SQL Server install. Check these:
install_sql_server_2005_2008_as_database_server
Installing SQL Server 2005 Express Edition: step-by-step guide

If you still facing problem in installation then specify the exact error that you are facing..

Hope this help..

share|improve this answer
add comment

Not the answer you're looking for? Browse other questions tagged or ask your own question.