Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm just a beginner and I want to know how to create a server in ms sql 2005. Because I want to use ms sql as my database for database program. I'm only using a single desktop computer. What would you recommend. This will only be used as a database for a program

share|improve this question
up vote 4 down vote accepted

If it's a single computer and a single program, then you should consider SQL Server Express instead. This page has info about the 2008 version:

If you're beginning, consider whether you should begin with something other than Is there a specific reason for using it? It could be a great opportunity to learn Visual C# or similar.

share|improve this answer
Even express edition is probably overkill here. – Joel Coel Mar 10 '10 at 18:52

Read the documentation, get into some VB.NET tutorials (as in: everyone that is not totally trivial has some section about databases).

share|improve this answer

I'm only using a single desktop computer.

I'd recommend going with an in-process or desktop engine rather than a server-class engine like sql server. Even Sql Server Express Edition is usually overkill. Use something like Sql Server Compact Edition, Sqlite, or even Access instead.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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