Missing Local Server after MSSQL 2005 Installed

Question

Missing Local Server after MSSQL 2005 Installed

carlos.antunez

Valued Member

Points: 69
More actions
November 2, 2009 at 3:48 pm

#216955

Hi All and thanks in advanced for all your help.
I formatted a PC. Installed Windows XP Professional in it, and a fresh install of MSSQL 2005.
Everything was fine. When I opened MS SQL 2005 Manegement Studio I get
Server Type: Database Engine
Server Name: Empty
Authentication : Windows Authentication
If I select Browse it does not find anything.
I read in the forum to type the name of the instance. However, I don't know the name what is it the instance? the Computer name? Where can I find this instance name?
What can I do?
Thanks

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Nabha SSCrazy Eights Points: 8534 More actions · Answer 1

Run command - > services.msc -> look for SQL Server. If you have 'MSSQLSERVER' within the parenthesis after sql server then its your default instance. something like this, SQL Server (MSSQLSERVER).

you can access this by entering, your system ip, computer name, or even just by typing . (dot) in the server field.

---------------------------------------------------------------------------------

carlos.antunez Valued Member Points: 69 More actions · Answer 2

Thanks for the responce.

I did step by step

1. Services.msc

2. Searched by (MSSQLSERVER) Not there

3. Entered in the Server field "." No Connection

4. I even entered "127.0.0.1 (The Local IP address) No Connection

Any other Idea?

Thanks

Steve-3_5_7_9 SSChampion Points: 10832 More actions · Answer 3

You're positive you selected the "Database Engine" during the install? If so, try installing again. If you already have an instance installed you will have the "named instance" radial checked when you get to the database engine portion of the install.

Additionally you installed as an "admin" on the pc, but after the install are you "logged in" as the admin. Perhaps you're not seeing the instance because of permissions or you're logged in as a less privledged account. You should see (MSSQL Server) when you go to "services".

carlos.antunez Valued Member Points: 69 More actions · Answer 4

Well, I am the only user on that machine when I go to the Users, my name is described as Administrator on this XP Professional PC. Unless there is another Administrator User hidden there besides my name

I will reinstall again.

Thanks

paul.knibbs SSCoach Points: 15320 More actions · Answer 5

Is this the Developer Edition or Express Edition of SQL 2005? Any other edition won't allow you to install the database engine on a non-server OS, as far as I know.

Steve-3_5_7_9 SSChampion Points: 10832 More actions · Answer 6

Excellent point, although I believe you get an error like "incompatible OS for this version".

carlos.antunez Valued Member Points: 69 More actions · Answer 7

Developer Edition. I reinstalled both WindowsXP pro. and SQLServer and still having the same issue.

One thing that I noticed was that when checking the boxes to install everything is grayed out except Workstation check box.

Any Ideas

carlos.antunez Valued Member Points: 69 More actions · Answer 8

Ok folks I got it fixed.

I formatted the entire Machine and re-installed the OS and the SQL Server Developers edition and now it works.

Thanks all for your help