Please start any new threads on our new site at http://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Cannot Find Server - SQL Server 2005 Enterprise
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

dominican1979
Starting Member

USA
18 Posts

Posted - 09/11/2008 :  13:37:37  Show Profile  Reply with Quote
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

USA
38200 Posts

Posted - 09/11/2008 :  13:41:35  Show Profile  Visit tkizer's Homepage  Reply with Quote
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

USA
18 Posts

Posted - 09/11/2008 :  13:53:53  Show Profile  Reply with Quote
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

USA
38200 Posts

Posted - 09/11/2008 :  14:13:50  Show Profile  Visit tkizer's Homepage  Reply with Quote
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

USA
18 Posts

Posted - 09/11/2008 :  14:28:19  Show Profile  Reply with Quote
Hi tkizer,

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

tkizer
Almighty SQL Goddess

USA
38200 Posts

Posted - 09/11/2008 :  14:34:26  Show Profile  Visit tkizer's Homepage  Reply with Quote
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

USA
18 Posts

Posted - 09/11/2008 :  15:55:55  Show Profile  Reply with Quote
Yeah it is started
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
38200 Posts

Posted - 09/11/2008 :  15:59:37  Show Profile  Visit tkizer's Homepage  Reply with Quote
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

USA
18 Posts

Posted - 09/12/2008 :  14:13:30  Show Profile  Reply with Quote
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

USA
38200 Posts

Posted - 09/12/2008 :  14:17:20  Show Profile  Visit tkizer's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.04 seconds. Powered By: Snitz Forums 2000