Please help...can not connect to sql server 2005

I used to work on sql server 2005 on hosted on virtual pc 2004 with windows
2000 server as guest operating system on Windows XP professional as host
operating system.
No matter how much ram I threw at it, it was very slow.
I decided to wipe out the notebook and install Windows 2000 with service
pack 4.
Then I installed sql server 2005. Rebooted the machine and I am getting the
following error.
After googling, I went into sql server configuration manager and double
checked that tcp/ip was enabled under sql native client
configurationn/client protocols.
I am the admin on this computer.
I tried to run the sql server surface configuration and I get the following
error:
TITLE: Surface Area Configuration
--
No SQL Server 2005 components were found on the specified computer. Either
no components are installed, or you are not an administrator on this
computer. (SQLSAC)
BUTTONS:
OK
--
My Machine configuration is as follows:
==================
mobile intel pentium 4 cpu 2.8 ghz
at/at compatible
2 gig ram
===============
Inside sql server management studio, When I try to connect to sql server I
get the following error message
error message:
TITLE: Connect to Server
--
Cannot connect to mars.
ADDITIONAL INFORMATION:
An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the fact
that
under the default settings SQL Server does not allow remote connections.
(provider: Named Pipes Provider, error: 40 - Could not open a connection to
SQL Server) (Microsoft SQL Server, Error: 2)
For help, click:
http://go.microsoft.com/fwlink?Prod...=2&LinkId=20476
BUTTONS:
OK
--BTW... this has to do with November RTM release as follows Version: 9.00.139
9
Executable x86.
Please help and I thank you in advance.
"sqlster" wrote:

> I used to work on sql server 2005 on hosted on virtual pc 2004 with window
s
> 2000 server as guest operating system on Windows XP professional as host
> operating system.
> No matter how much ram I threw at it, it was very slow.
> I decided to wipe out the notebook and install Windows 2000 with service
> pack 4.
> Then I installed sql server 2005. Rebooted the machine and I am getting th
e
> following error.
> After googling, I went into sql server configuration manager and double
> checked that tcp/ip was enabled under sql native client
> configurationn/client protocols.
> I am the admin on this computer.
> I tried to run the sql server surface configuration and I get the followin
g
> error:
> TITLE: Surface Area Configuration
> --
> No SQL Server 2005 components were found on the specified computer. Either
> no components are installed, or you are not an administrator on this
> computer. (SQLSAC)
> --
> BUTTONS:
> OK
> --
>
> My Machine configuration is as follows:
> ==================
> mobile intel pentium 4 cpu 2.8 ghz
> at/at compatible
> 2 gig ram
> ===============
> Inside sql server management studio, When I try to connect to sql server I
> get the following error message
> error message:
> TITLE: Connect to Server
> --
> Cannot connect to mars.
> --
> ADDITIONAL INFORMATION:
> An error has occurred while establishing a connection to the server.
> When connecting to SQL Server 2005, this failure may be caused by the fact
> that
> under the default settings SQL Server does not allow remote connections.
> (provider: Named Pipes Provider, error: 40 - Could not open a connection
to
> SQL Server) (Microsoft SQL Server, Error: 2)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...=2&LinkId=20476
> --
> BUTTONS:
> OK
> --
>|||I forgot to mention that this is a Microsoft SQL Server 2005 Enterprise
Evaluation Edition
Please help...
"sqlster" wrote:
> BTW... this has to do with November RTM release as follows Version: 9.00.1
399
> Executable x86.
> Please help and I thank you in advance.
>
> "sqlster" wrote:
>|||sqlster (nospam@.nospam.com) writes:
> After googling, I went into sql server configuration manager and double
> checked that tcp/ip was enabled under sql native client
> configurationn/client protocols.
> I am the admin on this computer.
> I tried to run the sql server surface configuration and I get the
> following error:
> TITLE: Surface Area Configuration
> --
> No SQL Server 2005 components were found on the specified computer. Either
> no components are installed, or you are not an administrator on this
> computer. (SQLSAC)
So, you can see the service in SQL Configuration Manager, but not
in Surface Area Configuration?
Very strange, and I have no idea of how this situation may have occurred.

> Inside sql server management studio, When I try to connect to sql server I
> get the following error message
Are you running Mgmt Studio from the same machine SQL Server 2005 is on,
or from a remote machine?
The only thing that I can suggest is to verify that SQL Server is actually
running. If it is, restart the service, so that any protocol changes takes
effect.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx