Cannot Conenct To Server. [ Need Help ]

[RandomRoll]

Hi,
I have recently wanted to start my own private server. Due to the fact I haven't found a server I have liked (yet). For reasons of things I like in the game ect..
Anyway, i have downloaded all the files and instaled them. I then opened "Microsoft SQl Server Management Studio Express" and tried connecting to server. After this it was connecting for about 6 seconds and then i get a messege. I will not write the message since I have screenshotted it. =P
Screenshot of the message after connecting:

I am not sure what to do, and have no idea what to do. Especially because I am new to the whole server thing. I couldn't find a way to fix this or get help. So I have posted here.
Please, if you know why this is and what I have done wrong. I would deaply appreciate it.
Thanks alot, Random.

[MentaL]

[gReGiTh]

Did you install SQL 2005 before trying to connect with Management Studio?

[RandomRoll]

Did you install SQL 2005 before trying to connect with Management Studio?

Hmm... I think i did.
I must of odne really.
I might try re-install everything tommrow.

[RandomRoll]

I re-installed.
still hasn't connected. (Same Message)

Anyone else ever got this?
If so is it something wrong with my computer?

[etiolated]

Use SQL authentication when you set it up.. make a password for the 'sa' user, the server name should typically just be the NETBIOS name of your computer or localhost. Login with SQL authentication. :)

[RandomRoll]

Use SQL authentication when you set it up.. make a password for the 'sa' user, the server name should typically just be the NETBIOS name of your computer or localhost. Login with SQL authentication. :)

Thanks for you help! :)
But what do you mean NETBOIS name of your computer. Do you mean for instance, my computer was MRMEN, i just put that?
:juggle:
Sorry, I know i know crap. :D

[RandomRoll]

Will I have to do system restore and try again?

[Night2Dark2]

Its your computer name /SQLEXPRESS

So go to Start -> and right click my computer select properties. - > Click Computer name - > and copy the full computer name.

[RandomRoll]

Its your computer name /SQLEXPRESS

So go to Start -> and right click my computer select properties. - > Click Computer name - > and copy the full computer name.

Ya, done that already.
Still no luck. :P

[Omer]

Wanna put a server name in? :p

[RandomRoll]

Wanna put a server name in? :p

I ahve, but i rubbed it out since I don't want you to see it. :)

[brietje698]

kk, i had that problem to to, solution: just type your computername WITHOUT\SQLEXPRESS

[RandomRoll]

kk, i had that problem to to, solution: just type your computername WITHOUT\SQLEXPRESS

No luck. :(