Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Need help getting started (I think this is basic)

Author  Topic 

WorldFamousBigB
Starting Member

5 Posts

Posted - 2009-11-11 : 19:11:54
Hello, I've got a basic question here, but I've been searching and searching for the past hour on google, and have been unable to find anything helpful. I think I must not be searching for the proper names of what I'm looking for, or maybe I just don't have the right software installed, or who knows what! Anyhow, my question is:
How do I make my computer into a server I can host a database from? Or, how do I create a new database? I know how to code in a query to create a new database, but I mean the server maybe? I'm using SQL management studio, and when I want to connect to a server when I start the program, I would like to put in my computer's name (as a server, I think?) and have it connect to a server (database?) that is stored on my computer, so that I can just practice when SQL queries at home.

I think that must be a pretty simple thing to do, but I'm not sure how to go about doing it. Do I need to have something like IIS or Apache? I installed Apache, though I'm not sure if that's that's going to help me or not...

Thanks for any help.

X002548
Not Just a Number

15586 Posts

Posted - 2009-11-11 : 19:16:50
do you have the sql server media?

what version do you have

you need to install the server software

simple enough?



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

WorldFamousBigB
Starting Member

5 Posts

Posted - 2009-11-11 : 19:29:18
ah.. if I understand correctly X002548, the part of SQL that I'm looking for is the part that you have to pay for. (I'm still pretty new to SQL)
No, I don't have the SQL server media, I downloaded the free version of mnagement studio, and it didn't occur to me at what point the things I wanted to do would cross over into the relm of monatary exchange.

Thanks for your quick reply.
Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2009-11-11 : 19:32:07
well....you can download sql server express from Microsoft

That's free



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

X002548
Not Just a Number

15586 Posts

Posted - 2009-11-11 : 19:33:00
Here

Download this

http://www.microsoft.com/express/sql/default.aspx



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

WorldFamousBigB
Starting Member

5 Posts

Posted - 2009-11-11 : 19:58:27
Brett,

thank you very much. I thought I had installed the whole sh-bang already, but I guess I only downloaded Management studio before. I'm installing SQL Server Express now (boy is it taking a while!) and hopefully I won't have to ask any more silly questions.
Go to Top of Page

WorldFamousBigB
Starting Member

5 Posts

Posted - 2009-11-11 : 20:08:57
Ah, I've finally got it up and running!

Thanks again for your help Brett.
Go to Top of Page
   

- Advertisement -