cant connect 2005 - SQL Server Forums

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

cant connect 2005

Author

Topic

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2007-09-11 : 13:24:46

installed 2005 on my laptop.

how do i find out my server name?

=============================
http://www.sqlserverstudy.com

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2007-09-11 : 13:27:02

if you didn't type in a name during installation, it's the name of your machine...go to services and you'll see the name

or connect to local
then do a select @@servername

--------------------
keeping it simple...

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-09-11 : 13:29:30

select @@servername

E 12°55'05.25"
N 56°04'39.16"

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2007-09-11 : 13:31:37

went to services. the mssqlserver service is not there.
how can i reinstall it

=============================
http://www.sqlserverstudy.com

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-09-11 : 13:33:30

1) Are you using VISTA? If so, have you run the "User Elevation Tool"?
2) On a laptop, you can always connect to "(local)" instead of machinename.
3) Do you get any errors?

E 12°55'05.25"
N 56°04'39.16"

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-09-11 : 13:36:55

quote:
Originally posted by funketekun

went to services. the mssqlserver service is not there.

But you told us it was?

quote:
Originally posted by funketekun

how can i reinstall it

Run the installation program again.

E 12°55'05.25"
N 56°04'39.16"

funketekun
Constraint Violating Yak Guru

491 Posts

Posted - 2007-09-11 : 13:45:58

i wonder how the services got uninstalled.

=============================
http://www.sqlserverstudy.com

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-09-11 : 13:53:27

It's magic.

E 12°55'05.25"
N 56°04'39.16"

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-09-11 : 15:16:13

I logged into your system and uninstalled SQL Server.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-09-11 : 15:18:32

You're bad Tara, bad