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:
> 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/
> > > >
> > > >
> >
> >
> >

Login account in two servers

Dear All,
The background is: I create a set of login account in the
production SQL 2K server (namely A) and assign some roles
to them. I usually backup the database and restore it to
our backup SQL 2K server (namely B) daily.
I would like to create the same set of login acount in B
server but it usally prompt me that there is already an
account in the related database. I believe this is
because I restore the whole database from A to B. In SQL
6.5, I will do a trick to update the uid/sid so that both
server of those login account are the same but in SQL 2K,
it dosen't allow me to do so.
Any idea?
Thanks.
Hi,
Looks like the Login and user chan has lost. To bring up the chain you could
use the stored procedure "sp_change_users_login". Have a look in SQL server
books online for the usage of the stored procedure.
Thanks
Hari
MCDBA
"Charles Lee" <leech@.dnb.com> wrote in message
news:49eb01c47389$30889df0$a401280a@.phx.gbl...
> Dear All,
> The background is: I create a set of login account in the
> production SQL 2K server (namely A) and assign some roles
> to them. I usually backup the database and restore it to
> our backup SQL 2K server (namely B) daily.
> I would like to create the same set of login acount in B
> server but it usally prompt me that there is already an
> account in the related database. I believe this is
> because I restore the whole database from A to B. In SQL
> 6.5, I will do a trick to update the uid/sid so that both
> server of those login account are the same but in SQL 2K,
> it dosen't allow me to do so.
> Any idea?
> Thanks.
|||In books on line, look up "log shipping". While changing the roles for log
shipping, one must ensure that the new server has all of the logins, etc
from the old server. There is really nice documentation about all of the
steps necessary to do this.. ( including the use of sp_change_users_login)
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Charles Lee" <leech@.dnb.com> wrote in message
news:49eb01c47389$30889df0$a401280a@.phx.gbl...
> Dear All,
> The background is: I create a set of login account in the
> production SQL 2K server (namely A) and assign some roles
> to them. I usually backup the database and restore it to
> our backup SQL 2K server (namely B) daily.
> I would like to create the same set of login acount in B
> server but it usally prompt me that there is already an
> account in the related database. I believe this is
> because I restore the whole database from A to B. In SQL
> 6.5, I will do a trick to update the uid/sid so that both
> server of those login account are the same but in SQL 2K,
> it dosen't allow me to do so.
> Any idea?
> Thanks.

Login account in two servers

Dear All,
The background is: I create a set of login account in the
production SQL 2K server (namely A) and assign some roles
to them. I usually backup the database and restore it to
our backup SQL 2K server (namely B) daily.
I would like to create the same set of login acount in B
server but it usally prompt me that there is already an
account in the related database. I believe this is
because I restore the whole database from A to B. In SQL
6.5, I will do a trick to update the uid/sid so that both
server of those login account are the same but in SQL 2K,
it dosen't allow me to do so.
Any idea?
Thanks.Hi,
Looks like the Login and user chan has lost. To bring up the chain you could
use the stored procedure "sp_change_users_login". Have a look in SQL server
books online for the usage of the stored procedure.
Thanks
Hari
MCDBA
"Charles Lee" <leech@.dnb.com> wrote in message
news:49eb01c47389$30889df0$a401280a@.phx.gbl...
> Dear All,
> The background is: I create a set of login account in the
> production SQL 2K server (namely A) and assign some roles
> to them. I usually backup the database and restore it to
> our backup SQL 2K server (namely B) daily.
> I would like to create the same set of login acount in B
> server but it usally prompt me that there is already an
> account in the related database. I believe this is
> because I restore the whole database from A to B. In SQL
> 6.5, I will do a trick to update the uid/sid so that both
> server of those login account are the same but in SQL 2K,
> it dosen't allow me to do so.
> Any idea?
> Thanks.|||In books on line, look up "log shipping". While changing the roles for log
shipping, one must ensure that the new server has all of the logins, etc
from the old server. There is really nice documentation about all of the
steps necessary to do this.. ( including the use of sp_change_users_login)
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Charles Lee" <leech@.dnb.com> wrote in message
news:49eb01c47389$30889df0$a401280a@.phx.gbl...
> Dear All,
> The background is: I create a set of login account in the
> production SQL 2K server (namely A) and assign some roles
> to them. I usually backup the database and restore it to
> our backup SQL 2K server (namely B) daily.
> I would like to create the same set of login acount in B
> server but it usally prompt me that there is already an
> account in the related database. I believe this is
> because I restore the whole database from A to B. In SQL
> 6.5, I will do a trick to update the uid/sid so that both
> server of those login account are the same but in SQL 2K,
> it dosen't allow me to do so.
> Any idea?
> Thanks.

Login account in two servers

Dear All,
The background is: I create a set of login account in the
production SQL 2K server (namely A) and assign some roles
to them. I usually backup the database and restore it to
our backup SQL 2K server (namely B) daily.
I would like to create the same set of login acount in B
server but it usally prompt me that there is already an
account in the related database. I believe this is
because I restore the whole database from A to B. In SQL
6.5, I will do a trick to update the uid/sid so that both
server of those login account are the same but in SQL 2K,
it dosen't allow me to do so.
Any idea?
Thanks.Hi,
Looks like the Login and user chan has lost. To bring up the chain you could
use the stored procedure "sp_change_users_login". Have a look in SQL server
books online for the usage of the stored procedure.
Thanks
Hari
MCDBA
"Charles Lee" <leech@.dnb.com> wrote in message
news:49eb01c47389$30889df0$a401280a@.phx.gbl...
> Dear All,
> The background is: I create a set of login account in the
> production SQL 2K server (namely A) and assign some roles
> to them. I usually backup the database and restore it to
> our backup SQL 2K server (namely B) daily.
> I would like to create the same set of login acount in B
> server but it usally prompt me that there is already an
> account in the related database. I believe this is
> because I restore the whole database from A to B. In SQL
> 6.5, I will do a trick to update the uid/sid so that both
> server of those login account are the same but in SQL 2K,
> it dosen't allow me to do so.
> Any idea?
> Thanks.|||In books on line, look up "log shipping". While changing the roles for log
shipping, one must ensure that the new server has all of the logins, etc
from the old server. There is really nice documentation about all of the
steps necessary to do this.. ( including the use of sp_change_users_login)
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Charles Lee" <leech@.dnb.com> wrote in message
news:49eb01c47389$30889df0$a401280a@.phx.gbl...
> Dear All,
> The background is: I create a set of login account in the
> production SQL 2K server (namely A) and assign some roles
> to them. I usually backup the database and restore it to
> our backup SQL 2K server (namely B) daily.
> I would like to create the same set of login acount in B
> server but it usally prompt me that there is already an
> account in the related database. I believe this is
> because I restore the whole database from A to B. In SQL
> 6.5, I will do a trick to update the uid/sid so that both
> server of those login account are the same but in SQL 2K,
> it dosen't allow me to do so.
> Any idea?
> Thanks.

Logical File Rename

Dear All
How to rename the logical file name of the database?
thanks
Manoj kumarUse the ALTER DATABASE command. (See Books Online for syntax.)
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Manoj" <Manoj@.discussions.microsoft.com> wrote in message
news:4AE35774-3B5F-4C82-A7FF-A22E1EF27964@.microsoft.com...
> Dear All
> How to rename the logical file name of the database?
> thanks
> Manoj kumar|||Thanks Your very much
Manoj kumar
"Tibor Karaszi" wrote:

> Use the ALTER DATABASE command. (See Books Online for syntax.)
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "Manoj" <Manoj@.discussions.microsoft.com> wrote in message
> news:4AE35774-3B5F-4C82-A7FF-A22E1EF27964@.microsoft.com...
>
>