Local Server not start

I changed my local server from
(local) to Machine Name and every thing seemed work fine
after restart Windows 2000 today the local SQL Server not
start.
Then I use . (period) to register again
But I got:
A connection could not be established to ...
Reason: SQL Server does not exist or access denied.
ConnectionOpen(Coonect())..
I used to connect the connection with Use Window
authentication.
and also can connect the connection with use SQLServer
authentication
for sa and a password
but right now both of them fail to logon.
Is re-setup SQL server is the only way to make it work?
ThanksMake sure the sql server service is running. Go to the services applet in
administrative tools and look for mssqlserver.
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 programming by Example
<anonymous@.discussions.microsoft.com> wrote in message
news:8f7401c3e9ee$83cbddd0$a501280a@.phx.gbl...

quote:

---

> I changed my local server from
> (local) to Machine Name and every thing seemed work fine
> after restart Windows 2000 today the local SQL Server not
> start.
> Then I use . (period) to register again
> But I got:
> A connection could not be established to ...
> Reason: SQL Server does not exist or access denied.
> ConnectionOpen(Coonect())..
>
> I used to connect the connection with Use Window
> authentication.
> and also can connect the connection with use SQLServer
> authentication
> for sa and a password
> but right now both of them fail to logon.
> Is re-setup SQL server is the only way to make it work?
> Thanks
>
>

---

|||Thanks.
I change
Log on as to
Local System account
and the Local SQL Server start