Setup SQL Server 2005

I am trying to learn SQL/Database/Tables etc, and Installed SQL Server 2005 on Windows XP VM.  I am new to the software.  I am not sure how to get into the server to create Database/Tables.  
I try to use the SQL Server Management Studio, but it is asking for the Server Name. I tried using the XP VM Computer Name, but it does not connect to it.

Can someone help me set this up?

Thank you
aacrzAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

AnuroopsunddCommented:
use .
.  or localhost
this way it will connect to same machine.
0
aacrzAuthor Commented:
Neither the "." or the "localhost" (without quotes) worked. Same error.  The server was not found or was not accessible.
0
AshokSr. Software EngineerCommented:
Which options (besides userid and password) do you see when connecting (login) screen?

Do not use Windows mode.

HTH
Ashok
0
10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

Paul JacksonSoftware EngineerCommented:
Select Browse for more from the Server name dropdown, then expand Database Engine and it should show your server there.
0
aacrzAuthor Commented:
Here is the error message

http://i.imgur.com/3wFgP.jpg?1
0
aacrzAuthor Commented:
Local Servers is Empty, Network Servers is also empty.  When Installing the server, I never set anything up.
0
AnuroopsunddCommented:
try to use browse option and try to connect.
0
AshokSr. Software EngineerCommented:
Make sure you type in all required fields first....

Could you post the "Connect to Server" screen (before pressing the Connnect button)?
0
Paul JacksonSoftware EngineerCommented:
SOunds like you have just installed SQL Server 2005 Management Studio and not actually SQL Server 2005
0
Paul JacksonSoftware EngineerCommented:
Here's where you can download the actual database engine from :  

http://www.microsoft.com/download/en/details.aspx?id=21844
0
aacrzAuthor Commented:
ashok, here is the screen
http://i.imgur.com/OcIjJ.png?1
0
AshokSr. Software EngineerCommented:
Do you see Server Name(s) in Server Name Dropdown?

Ashok
0
AshokSr. Software EngineerCommented:
What happens when you press down arrow key (on the right side of the dropdown) for Server Name?
Do you see 1 or more Server Names in the Dropdown list?

In Authentication, do not use Windows Authentication.
Change it.

Then type in userid and passowrd.

HTH
Ashok
0
aacrzAuthor Commented:
This is what I have Installed,
http://i.imgur.com/tGERx.png?1

 and for Ashok,
When I click on the dropdown, there are No Server Names.  even when changing auth mode.
0
AshokSr. Software EngineerCommented:
If you do not see any Server, you will not be able to connect.

Is this Local or Network Server?

Ashok
0
aacrzAuthor Commented:
Ashok,  I understand that I will not be able to connect to the server if the name is not there, and that is what I need help with.  I am confused as to what configuration steps need to be taken, or what am I missing.  I installed the SQL Server 2005, but it seems that I may have not done this as stated by Jacko.

All I want to do is have a test environment for MS SQL, where I can import tables/create database, create relations etc...
0
AshokSr. Software EngineerCommented:
Could you uninstall
and
install it again?

Make sure when installing, give Server Name, give password for sa user, etc.

Then, if you start SQL Server Management Server, you should see at least two Servers.

HTH
Ashok
0
Paul JacksonSoftware EngineerCommented:
You need to install the SQL Server 2005 Express that I linked earlier, what you have installed is just the UI not the database engine
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
AshokSr. Software EngineerCommented:
As jacko72 has said.....

Your installation may be incomplete.
Do you have the Full version of SQL Server 2005 (on CDs)?
If so, I would recommend you install the full version (uninstall & install it again).

Make sure you install everything (standard installation).

If you are using SQL Server Express, do as jacko72 said.

HTH
Ashok
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.