Could no longer login into SQL Express 2005

Hi All,
I have this weird problem and hope someone can help me.
I have a SQL Express 2005 installed in a Windows 2000 server. After the
initial installation, I can login into the SQL server using the SQL
2005 console. However suddenly, I no longer can login either using SA
or Windows Authentication after a server reboot. I have enabled TCP/IP
and Named Pipes in the Network configuration.
The error message is,
TITLE: Connect to Server
--
Cannot connect to servername\MERCURY.
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: SQL Network Interfaces, error: 26 - Error
Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
For help, click:
http://go.microsoft.com/fwlink?Prod...-1&LinkId=20476
BUTTONS:
OK
--
So now I am stuck. Is there anyway I can login or reset the password
for sa?
Thanks in advance.This is a very general message that the application can't find the SQL
Server. The most likely cause on a reboot, is that SQL Server was not
configured to start automatically, so you must start SQL Server. Use the SQL
Server Configuration Manager to do that.
Other common reasons are:
- Typed the name and instance wrong.
- You are connecting from another computer and the firewall is blocking you.
--
Rick Byham, MS
This posting is provided "AS IS" with no warranties, and confers no rights.
"mousehunt" <mousehunt@.gmail.com> wrote in message
news:1153043598.176242.291440@.m79g2000cwm.googlegroups.com...
> Hi All,
> I have this weird problem and hope someone can help me.
> I have a SQL Express 2005 installed in a Windows 2000 server. After the
> initial installation, I can login into the SQL server using the SQL
> 2005 console. However suddenly, I no longer can login either using SA
> or Windows Authentication after a server reboot. I have enabled TCP/IP
> and Named Pipes in the Network configuration.
> The error message is,
> TITLE: Connect to Server
> --
> Cannot connect to servername\MERCURY.
> --
> 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: SQL Network Interfaces, error: 26 - Error
> Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)
> For help, click:
> http://go.microsoft.com/fwlink?Prod...-1&LinkId=20476
> --
> BUTTONS:
> OK
> --
>
> So now I am stuck. Is there anyway I can login or reset the password
> for sa?
> Thanks in advance.
>