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
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Cannot Find Server - SQL Server 2005 Enterprise

Author  Topic 

dominican1979
Starting Member

18 Posts

Posted - 2008-09-11 : 13:37:37
Hello everyone, thanks for reading my post. I'm fairly new to SQL Server and I just ran into a little problem after installation. Basically I downloaded the evaluation version of SQL Server 2005 Enterprise. I installed it on my home computer (XP SP2) and everything works great when I open SQL Management Studio. However, I did the exact same installation with the same options on my work computer (XP SP2), but when I open SQL Server Management studio, the server name box is blank. At my home computer, the server name is my computer's name so it installed as a local server. Im not sure why this is happening on my work computer, is it because the computer is part of a domain? I mean I can browse for network instances on our file server and I can find an SQL server instance for BackupExec and connect to it, but I really need this to be installed as a local server with the sample databases. Thank you so much for reading my post again and hope to hear from you.

MS

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-09-11 : 13:41:35
Why don't you type in the server name?

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

Subscribe to my blog
Go to Top of Page

dominican1979
Starting Member

18 Posts

Posted - 2008-09-11 : 13:53:53
Hi tkizer,

I tried typing in my computer's name as the server name, but got an error message saying that it could not open a connection to the server. I was looking at the installation at my home computer under C:\program files\microsoft sql server\ and it has a lot more folders and files than the installation at work where i can even see the default instance folder. My work computer only has two folders named: 80 and 90 I don't know if that's any help, but i'm trying to figure it out.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-09-11 : 14:13:50
Did you install a named instance? If so, specify serverName\instanceName.

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

Subscribe to my blog
Go to Top of Page

dominican1979
Starting Member

18 Posts

Posted - 2008-09-11 : 14:28:19
Hi tkizer,

No I just installed the default instance, that's the weird thing.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-09-11 : 14:34:26
Is the SQL Server service started?

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

Subscribe to my blog
Go to Top of Page

dominican1979
Starting Member

18 Posts

Posted - 2008-09-11 : 15:55:55
Yeah it is started
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-09-11 : 15:59:37
Try connecting with (local).

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

Subscribe to my blog
Go to Top of Page

dominican1979
Starting Member

18 Posts

Posted - 2008-09-12 : 14:13:30
Hi tkizer,

There is no server showing at all on the drop down list, so there's nothing for me to connect to, I looked at my installation at home under program files and sql server folder and i can see the default instance there, however here at work i can't see that, so it looks like it wasnn't created at all, I rean the setup again but it wont let me install anything because it says it find components are already installed.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-09-12 : 14:17:20
There doesn't need to be anything in the dropdown list. You can type things in there.

Show us what services you have that start with SQL.

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

Subscribe to my blog
Go to Top of Page
   

- Advertisement -