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:
> 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/
> >
> >|||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:
> 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/
> >
> >|||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,program_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:
> > 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/
> > >
> > >
>
>|||Thanks,
I'll restart the server some times, try to see how...
Currently Query Analyzer also cannot run.
"jrpm" wrote:
> 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,program_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:
> >
> > > 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/
> > > >
> > > >
> >
> >
> >
No comments:
Post a Comment