Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

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 have just downloaded SQL Server 2005 express edition from here:

To be used as a database for a program.

But I'm confused in using sql server. I do not know where to start from here:

Do I have to create the database in>

If not, where could I create the ms sql database? I'm a beginner and I want to learn.

Please help.

Do you have any tutorials there that could help a beginner like me.

share|improve this question
up vote 1 down vote accepted

If you installed Visual Studio 2005, you probably installed SQL Server 2005 express with it. Re-Run the installer, if you haven't

If you already have SQL Server 2005 express installed, download and use SQL Server Management Studio

You can find programming tutorials for beginners here:

share|improve this answer

You can create a database using the SQL Server Management Studio. Most configuration can be done through this application. If your server is ready for the prime time, you can use SQL Server Configuration Manager to enable remote TCP/IP connections.

share|improve this answer
how do I create a server?I just want to use ms sql server 2005 for database programming in – user28233 Mar 10 '10 at 10:29
The server will be created when SQL Server is installed. As Andrei Drynov said, it comes with Visual Studio 2005 and 2008. If not installed, you can download and install it from… There is a good writeup on how to install it here: You will also need to install the management studio. – Mar 10 '10 at 21:45

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.