Log-In error

SQL Server does not exist or access denied!
Dear all,
I'm using SQl Server 2K on a webserver and the sa password is "abcde". Using
this user name and password, and with ADO, I established our website.
Now the website is still working well,can input data,show data,even after
restart the computer. (does it means the sa password still correct?)
But I cannot login to this SQL Server with "Enterprise Manager" or "Query
Analyzer". Either with sa or Windows-Authenticate. (I user the administrator
to login to the server).
It seems some-virus has attacked this server because I found under the
administrators group, the user name of "guest" is there. I have disabled this
guest account now.
Please tell me how to run up the Enterprise Manager? Thanks a lot.
Are you able to ping the SQL Server machine? Where are you loading the
Enterprise Manager from? is it directly on the SQL Server? It looks like a
connectivity issue to me
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"goldenshine" <goldenshine@.discussions.microsoft.com> wrote in message
news:6D183EDD-FAEA-49C8-A84C-EC0B1B09C9C8@.microsoft.com...
SQL Server does not exist or access denied!
Dear all,
I'm using SQl Server 2K on a webserver and the sa password is "abcde". Using
this user name and password, and with ADO, I established our website.
Now the website is still working well,can input data,show data,even after
restart the computer. (does it means the sa password still correct?)
But I cannot login to this SQL Server with "Enterprise Manager" or "Query
Analyzer". Either with sa or Windows-Authenticate. (I user the administrator
to login to the server).
It seems some-virus has attacked this server because I found under the
administrators group, the user name of "guest" is there. I have disabled
this
guest account now.
Please tell me how to run up the Enterprise Manager? Thanks a lot.
|||Thanks, Narayana,
I'm trying to run the Enterprise Manager on another computer.
If run Enterprise Manager on the server, the error message is:"connection
failed,check SQL Server Registration Properties."
Error dialog is: A connection could not be established to server\instance.
Reason: Timeout expired.
=====
If run the query analyzer on the server, also can not (with sa or Windows
Authenticate)
"Narayana Vyas Kondreddi" wrote:

> Are you able to ping the SQL Server machine? Where are you loading the
> Enterprise Manager from? is it directly on the SQL Server? It looks like a
> connectivity issue to me
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
|||And this system has been running for some months. The Enterprise Manger and
query-analyzer run well before. Just for some weeks I didn't look it, then I
cannot login.
I'm sure the server has been infected by some virus. But how can I run
enterprise manager?
The website is still working well.
"goldenshine" wrote:
[vbcol=seagreen]
> Thanks, Narayana,
> I'm trying to run the Enterprise Manager on another computer.
> If run Enterprise Manager on the server, the error message is:"connection
> failed,check SQL Server Registration Properties."
> Error dialog is: A connection could not be established to server\instance.
> Reason: Timeout expired.
> =====
> If run the query analyzer on the server, also can not (with sa or Windows
> Authenticate)
> "Narayana Vyas Kondreddi" wrote:
|||Is the system too busy? Is the CPU maxed out? From control panel, make sure
the ODBC tracing is turned off.
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"goldenshine" <goldenshine@.discussions.microsoft.com> wrote in message
news:4A77150D-749F-4196-A283-6BD5E8151D23@.microsoft.com...
And this system has been running for some months. The Enterprise Manger and
query-analyzer run well before. Just for some weeks I didn't look it, then I
cannot login.
I'm sure the server has been infected by some virus. But how can I run
enterprise manager?
The website is still working well.
"goldenshine" wrote:
[vbcol=seagreen]
> Thanks, Narayana,
> I'm trying to run the Enterprise Manager on another computer.
> If run Enterprise Manager on the server, the error message is:"connection
> failed,check SQL Server Registration Properties."
> Error dialog is: A connection could not be established to server\instance.
> Reason: Timeout expired.
> =====
> If run the query analyzer on the server, also can not (with sa or Windows
> Authenticate)
> "Narayana Vyas Kondreddi" wrote:
a[vbcol=seagreen]
|||If the SS server has been running for several weeks without a reboot, then
from a machine that can use Enterprise manager check the instance to see if
there are any exchange waits. We have had issues where network issues have
caused 3 or more sessions to go into an exchange wait state that seems to
block normal user signons.
You might have to use Query Analyzer and run a statement like
select lastwaittype, waittime, loginame, spid, b.name, uid, physical_io,
last_batch,open_tran,a.status,loginame,hostname,pr ogram_name,cmd,net_address
from sysprocesses a left join sysdatabases b on b.dbid=a.dbid
where cmd not in ('LAZY WRITER','LOG WRITER','CHECKPOINT SLEEP','LOCK
MONITOR')
and waittime>0 order by lastwaittype,waittime
(wait type 200 may show up, it is an exchange wait.)
If you run this statement a couple of times and 3 or more sessions show up
every time, then you need to boot the server. At least that has been our
experience.
Joseph R.P. Maloney, CSP,CCP,CDP
"Narayana Vyas Kondreddi" wrote:

> Is the system too busy? Is the CPU maxed out? From control panel, make sure
> the ODBC tracing is turned off.
> --
> HTH,
> Vyas, MVP (SQL Server)
> SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
>
> "goldenshine" <goldenshine@.discussions.microsoft.com> wrote in message
> news:4A77150D-749F-4196-A283-6BD5E8151D23@.microsoft.com...
> And this system has been running for some months. The Enterprise Manger and
> query-analyzer run well before. Just for some weeks I didn't look it, then I
> cannot login.
> I'm sure the server has been infected by some virus. But how can I run
> enterprise manager?
> The website is still working well.
> "goldenshine" wrote:
> a
>
>
|||Thanks,
I'll restart the server some times, try to see how...
Currently Query Analyzer also cannot run.
"jrpm" wrote:
[vbcol=seagreen]
> If the SS server has been running for several weeks without a reboot, then
> from a machine that can use Enterprise manager check the instance to see if
> there are any exchange waits. We have had issues where network issues have
> caused 3 or more sessions to go into an exchange wait state that seems to
> block normal user signons.
> You might have to use Query Analyzer and run a statement like
>
> select lastwaittype, waittime, loginame, spid, b.name, uid, physical_io,
> last_batch,open_tran,a.status,loginame,hostname,pr ogram_name,cmd,net_address
> from sysprocesses a left join sysdatabases b on b.dbid=a.dbid
> where cmd not in ('LAZY WRITER','LOG WRITER','CHECKPOINT SLEEP','LOCK
> MONITOR')
> and waittime>0 order by lastwaittype,waittime
> (wait type 200 may show up, it is an exchange wait.)
> If you run this statement a couple of times and 3 or more sessions show up
> every time, then you need to boot the server. At least that has been our
> experience.
> --
> Joseph R.P. Maloney, CSP,CCP,CDP
>
> "Narayana Vyas Kondreddi" wrote: