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 |
|
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. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
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. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
dominican1979
Starting Member
18 Posts |
Posted - 2008-09-11 : 15:55:55
|
Yeah it is started |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
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. |
|
|
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 KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|