Wednesday, March 7, 2012

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 not start
I find 3 lines in errorlog
2004-01-30 08:00:44.61 spid55 Error: 15457, Severity:
0, State: 1
2004-01-30 08:00:44.61 spid55 Configuration
option 'show advanced options' changed from 1 to 1. Run
the RECONFIGURE statement to install..
2004-01-30 08:00:44.79 spid55 Using 'xplog70.dll'
version '2000.80.760' to execute extended stored
procedure 'xp_msver'.
any help wellcomeThese are not error messages in real sense, or linked with your problem.
Where did you set the (local) to machine name? Try connect to sql server by
using (local) or "." or machine name then execute
Select SERVERPROPERTY('ServerName')
The result is the name sql server's default instance is listening.
ashish
"Michael" <anonymous@.discussions.microsoft.com> wrote in message
news:860501c3e9d0$10d8d120$a101280a@.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 not start
> I find 3 lines in errorlog
> 2004-01-30 08:00:44.61 spid55 Error: 15457, Severity:
> 0, State: 1
> 2004-01-30 08:00:44.61 spid55 Configuration
> option 'show advanced options' changed from 1 to 1. Run
> the RECONFIGURE statement to install..
> 2004-01-30 08:00:44.79 spid55 Using 'xplog70.dll'
> version '2000.80.760' to execute extended stored
> procedure 'xp_msver'.
>
> any help wellcome
>
|||I use . (period) to register
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

No comments:

Post a Comment