Connecting to SQL Server 2005 (Developer Ed)

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

Connecting to SQL Server 2005 (Developer Ed)

Author

Topic

CSharpNewbie
Starting Member

39 Posts

Posted - 2009-01-03 : 16:15:11

I am trying to connect to SQL Server 2005 Developer Edition. I just installed it (selected default instance name and Windows Authentication options)

Now when I attempt to connect via Mgmt Stdio, I get a message "Cannot Connect to <servername>"

Any ideas?

Thanks

Mike

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2009-01-03 : 16:21:26

Is the service started?
What OS?

--
Gail Shaw
SQL Server MVP

CSharpNewbie
Starting Member

39 Posts

Posted - 2009-01-03 : 18:17:34

yep.

quote:
Originally posted by GilaMonster

Is the service started?
What OS?

--
Gail Shaw
SQL Server MVP

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2009-01-04 : 05:29:18

What OS?

--
Gail Shaw
SQL Server MVP

CSharpNewbie
Starting Member

39 Posts

Posted - 2009-01-04 : 10:49:58

Vista Home Premium

quote:
Originally posted by GilaMonster

What OS?

--
Gail Shaw
SQL Server MVP

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-04 : 10:53:33

Did you put your hostname in servername?

CSharpNewbie
Starting Member

39 Posts

Posted - 2009-01-04 : 11:00:17

if it is locally hosted, how do i put in my host name?

quote:
Originally posted by sodeep

Did you put your hostname in servername?

CSharpNewbie
Starting Member

39 Posts

Posted - 2009-01-04 : 11:03:47

actually, I just typed in localhost, and it connected.

thanks

quote:
Originally posted by CSharpNewbie

if it is locally hosted, how do i put in my host name?

quote:
Originally posted by sodeep

Did you put your hostname in servername?

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-04 : 11:06:00

quote:
Originally posted by CSharpNewbie

actually, I just typed in localhost, and it connected.

thanks

quote:
Originally posted by CSharpNewbie

if it is locally hosted, how do i put in my host name?

quote:
Originally posted by sodeep

Did you put your hostname in servername?

I mean your computername.Right-click Mycomputer-Properties.

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2009-01-04 : 11:11:28

quote:
Originally posted by CSharpNewbie

actually, I just typed in localhost, and it connected.

thanks

quote:
Originally posted by CSharpNewbie

if it is locally hosted, how do i put in my host name?

quote:
Originally posted by sodeep

Did you put your hostname in servername?

Better put your servername.

CSharpNewbie
Starting Member

39 Posts

Posted - 2009-01-04 : 11:21:56

What difference would that make?

quote:
Originally posted by sodeep

quote:
Originally posted by CSharpNewbie

actually, I just typed in localhost, and it connected.

thanks

quote:
Originally posted by CSharpNewbie

if it is locally hosted, how do i put in my host name?

quote:
Originally posted by sodeep

Did you put your hostname in servername?

Better put your servername.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources