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
 Creating a new Server SQL Server 2005

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2007-01-03 : 14:18:36
Darren writes "Hi

I just have installed SQL Server 2005 on my home desktop and want to know how I can create a server to create databases, run queries etc..

I am quite a novice, so only need it for practicing at home, but do not know how to get started.

Best Regards

Darren"

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-01-03 : 14:25:03
Just open up Management Studio, connect to the SQL Server that you installed, then perform the work.

Tara Kizer
Go to Top of Page

dnf999
Constraint Violating Yak Guru

253 Posts

Posted - 2007-01-03 : 16:24:52
I'm not sure if I installed a Server. There are no available servers for me to connect to.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-01-03 : 16:31:18
Well what did you install?

Tara Kizer
Go to Top of Page

dnf999
Constraint Violating Yak Guru

253 Posts

Posted - 2007-01-03 : 18:20:40
I installed SQL Server Enterprise Edition.

But I my options for a Server name are blank, therefore I cannot connect to anything....
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-01-03 : 18:27:13
What operation system did you install it on? If XP, then that's the problem. You can't install the server portion of Enterprise Edition onto XP. You either need a server operating system such as Win2k3 or you need to install Developer Edition.

Tara Kizer
Go to Top of Page

dnf999
Constraint Violating Yak Guru

253 Posts

Posted - 2007-01-04 : 04:19:14
...Yes it's windows XP.

Do you know if I install the Express Edition (free from Microsoft Website) it will work...?

Thanks

Go to Top of Page

monty
Posting Yak Master

130 Posts

Posted - 2007-01-04 : 05:03:04
it will work..

its me monty
Go to Top of Page
   

- Advertisement -