Authentication failed in EM

Hi,
We are using SQL Server 2000 SP3A and we have 3 instances in 3 different
servers.
I am facing strange issue in 2 of our 3 instances.
When I open EM and try to open it says Authentication failure, I tried both
methods viz. windows authentication and SQL authentication but failed though
I am giving correct username and passwords
While installation I had prefered mixed mode authentication.
through ODBC connection is successful, SQL server service is running but
application
is unable to get database.
What could be the problem, I am unable to find out, can somebody please help
me to find the cause of this problem and solution.
Thanks,
Kishor.
since what event you are facing this problem.i mean any updations or patches
made before this failure?
"Kishor Yadav" wrote:

> Hi,
> We are using SQL Server 2000 SP3A and we have 3 instances in 3 different
> servers.
> I am facing strange issue in 2 of our 3 instances.
> When I open EM and try to open it says Authentication failure, I tried both
> methods viz. windows authentication and SQL authentication but failed though
> I am giving correct username and passwords
> While installation I had prefered mixed mode authentication.
> through ODBC connection is successful, SQL server service is running but
> application
> is unable to get database.
> What could be the problem, I am unable to find out, can somebody please help
> me to find the cause of this problem and solution.
> Thanks,
> Kishor.
|||No updation or patches, it started giving me this problem suddenly.
"Khwaja Arshaduddin" wrote:
[vbcol=seagreen]
> since what event you are facing this problem.i mean any updations or patches
> made before this failure?
> "Kishor Yadav" wrote:

Authentication failed in EM

Hi,
We are using SQL Server 2000 SP3A and we have 3 instances in 3 different
servers.
I am facing strange issue in 2 of our 3 instances.
When I open EM and try to open it says Authentication failure, I tried both
methods viz. windows authentication and SQL authentication but failed though
I am giving correct username and passwords
While installation I had prefered mixed mode authentication.
through ODBC connection is successful, SQL server service is running but
application
is unable to get database.
What could be the problem, I am unable to find out, can somebody please help
me to find the cause of this problem and solution.
Thanks,
Kishor.since what event you are facing this problem.i mean any updations or patches
made before this failure?
"Kishor Yadav" wrote:
> Hi,
> We are using SQL Server 2000 SP3A and we have 3 instances in 3 different
> servers.
> I am facing strange issue in 2 of our 3 instances.
> When I open EM and try to open it says Authentication failure, I tried both
> methods viz. windows authentication and SQL authentication but failed though
> I am giving correct username and passwords
> While installation I had prefered mixed mode authentication.
> through ODBC connection is successful, SQL server service is running but
> application
> is unable to get database.
> What could be the problem, I am unable to find out, can somebody please help
> me to find the cause of this problem and solution.
> Thanks,
> Kishor.|||No updation or patches, it started giving me this problem suddenly.
"Khwaja Arshaduddin" wrote:
> since what event you are facing this problem.i mean any updations or patches
> made before this failure?
> "Kishor Yadav" wrote:
> > Hi,
> > We are using SQL Server 2000 SP3A and we have 3 instances in 3 different
> > servers.
> > I am facing strange issue in 2 of our 3 instances.
> > When I open EM and try to open it says Authentication failure, I tried both
> > methods viz. windows authentication and SQL authentication but failed though
> > I am giving correct username and passwords
> > While installation I had prefered mixed mode authentication.
> > through ODBC connection is successful, SQL server service is running but
> > application
> > is unable to get database.
> > What could be the problem, I am unable to find out, can somebody please help
> > me to find the cause of this problem and solution.
> > Thanks,
> > Kishor.

Authentication failed in EM

Hi,
We are using SQL Server 2000 SP3A and we have 3 instances in 3 different
servers.
I am facing strange issue in 2 of our 3 instances.
When I open EM and try to open it says Authentication failure, I tried both
methods viz. windows authentication and SQL authentication but failed though
I am giving correct username and passwords
While installation I had prefered mixed mode authentication.
through ODBC connection is successful, SQL server service is running but
application
is unable to get database.
What could be the problem, I am unable to find out, can somebody please help
me to find the cause of this problem and solution.
Thanks,
Kishor.since what event you are facing this problem.i mean any updations or patches
made before this failure?
"Kishor Yadav" wrote:

> Hi,
> We are using SQL Server 2000 SP3A and we have 3 instances in 3 different
> servers.
> I am facing strange issue in 2 of our 3 instances.
> When I open EM and try to open it says Authentication failure, I tried bot
h
> methods viz. windows authentication and SQL authentication but failed thou
gh
> I am giving correct username and passwords
> While installation I had prefered mixed mode authentication.
> through ODBC connection is successful, SQL server service is running but
> application
> is unable to get database.
> What could be the problem, I am unable to find out, can somebody please he
lp
> me to find the cause of this problem and solution.
> Thanks,
> Kishor.|||No updation or patches, it started giving me this problem suddenly.
"Khwaja Arshaduddin" wrote:
[vbcol=seagreen]
> since what event you are facing this problem.i mean any updations or patch
es
> made before this failure?
> "Kishor Yadav" wrote:
>

Attaching MDF and LDF Files Error

i am facing a problem for SQL 2000 Database .. We have SQL 2000 Database on
customer site installed on C Partition ...MDF file is 300 MB but LDF file
became 12 GB which took all of the C Partition Space.. Our Tech Supp Person
have moved these Physical Files From C to D partition and Deleted the files
and database from C partition and he created new database and tried to Attach
from D partion but that gives an error(Error 9003: The
LSN(12560:120211:1) Passed to log scan in database 'DatabaseName' is invalid)
another problem is that latest backup is not available only old backup
available.
we restored old backup and tried to attach those files (300 MB and 12 GB)
but didnt work.. another error comes that CAN NOT ATTACH FILES FROM
DIFFERENT DATABASES.
please can any one help in this case ...my email is raza_noor@.hotmail.comHi
Was the file detached correctly?
Try renaming the log file and using sp_attach_single_file_db to create a new
log, and then detaching/move/attaching the log or in SQL 2005 you can use
CREATE DATABASE with the ATTACH_REBUILD_LOG option instead of
sp_attach_single_file_db.
John
"razanoor" <razanoor@.discussions.microsoft.com> wrote in message
news:4D14A1C6-EE37-463B-A4E3-9B4F79BBA684@.microsoft.com...
> i am facing a problem for SQL 2000 Database .. We have SQL 2000 Database
> on
> customer site installed on C Partition ...MDF file is 300 MB but LDF file
> became 12 GB which took all of the C Partition Space.. Our Tech Supp
> Person
> have moved these Physical Files From C to D partition and Deleted the
> files
> and database from C partition and he created new database and tried to
> Attach
> from D partion but that gives an error(Error 9003: The
> LSN(12560:120211:1) Passed to log scan in database 'DatabaseName' is
> invalid)
> another problem is that latest backup is not available only old backup
> available.
> we restored old backup and tried to attach those files (300 MB and 12 GB)
> but didnt work.. another error comes that CAN NOT ATTACH FILES FROM
> DIFFERENT DATABASES.
> please can any one help in this case ...my email is raza_noor@.hotmail.com|||Hi
Does he try top attach with single file option (for more details please see
BOL) i.e without specifying .LDF file?
Don't you have proper BACKUP?
"razanoor" <razanoor@.discussions.microsoft.com> wrote in message
news:4D14A1C6-EE37-463B-A4E3-9B4F79BBA684@.microsoft.com...
> i am facing a problem for SQL 2000 Database .. We have SQL 2000 Database
> on
> customer site installed on C Partition ...MDF file is 300 MB but LDF file
> became 12 GB which took all of the C Partition Space.. Our Tech Supp
> Person
> have moved these Physical Files From C to D partition and Deleted the
> files
> and database from C partition and he created new database and tried to
> Attach
> from D partion but that gives an error(Error 9003: The
> LSN(12560:120211:1) Passed to log scan in database 'DatabaseName' is
> invalid)
> another problem is that latest backup is not available only old backup
> available.
> we restored old backup and tried to attach those files (300 MB and 12 GB)
> but didnt work.. another error comes that CAN NOT ATTACH FILES FROM
> DIFFERENT DATABASES.
> please can any one help in this case ...my email is raza_noor@.hotmail.com|||If the Tech Supp Person did no detach database file before move it, he is
not qualified to manage a server/computer with production SQL Server.
"razanoor" <razanoor@.discussions.microsoft.com> wrote in message
news:4D14A1C6-EE37-463B-A4E3-9B4F79BBA684@.microsoft.com...
> i am facing a problem for SQL 2000 Database .. We have SQL 2000 Database
> on
> customer site installed on C Partition ...MDF file is 300 MB but LDF file
> became 12 GB which took all of the C Partition Space.. Our Tech Supp
> Person
> have moved these Physical Files From C to D partition and Deleted the
> files
> and database from C partition and he created new database and tried to
> Attach
> from D partion but that gives an error(Error 9003: The
> LSN(12560:120211:1) Passed to log scan in database 'DatabaseName' is
> invalid)
> another problem is that latest backup is not available only old backup
> available.
> we restored old backup and tried to attach those files (300 MB and 12 GB)
> but didnt work.. another error comes that CAN NOT ATTACH FILES FROM
> DIFFERENT DATABASES.
> please can any one help in this case ...my email is raza_noor@.hotmail.com

Attaching MDF and LDF Files Error

i am facing a problem for SQL 2000 Database .. We have SQL 2000 Database on
customer site installed on C Partition ...MDF file is 300 MB but LDF file
became 12 GB which took all of the C Partition Space.. Our Tech Supp Person
have moved these Physical Files From C to D partition and Deleted the files
and database from C partition and he created new database and tried to Attach
from D partion but that gives an error(Error 9003: The
LSN(12560:120211:1) Passed to log scan in database 'DatabaseName' is invalid)
another problem is that latest backup is not available only old backup
available.
we restored old backup and tried to attach those files (300 MB and 12 GB)
but didnt work.. another error comes that CAN NOT ATTACH FILES FROM
DIFFERENT DATABASES.
please can any one help in this case ...my email is raza_noor@.hotmail.com
Hi
Was the file detached correctly?
Try renaming the log file and using sp_attach_single_file_db to create a new
log, and then detaching/move/attaching the log or in SQL 2005 you can use
CREATE DATABASE with the ATTACH_REBUILD_LOG option instead of
sp_attach_single_file_db.
John
"razanoor" <razanoor@.discussions.microsoft.com> wrote in message
news:4D14A1C6-EE37-463B-A4E3-9B4F79BBA684@.microsoft.com...
> i am facing a problem for SQL 2000 Database .. We have SQL 2000 Database
> on
> customer site installed on C Partition ...MDF file is 300 MB but LDF file
> became 12 GB which took all of the C Partition Space.. Our Tech Supp
> Person
> have moved these Physical Files From C to D partition and Deleted the
> files
> and database from C partition and he created new database and tried to
> Attach
> from D partion but that gives an error(Error 9003: The
> LSN(12560:120211:1) Passed to log scan in database 'DatabaseName' is
> invalid)
> another problem is that latest backup is not available only old backup
> available.
> we restored old backup and tried to attach those files (300 MB and 12 GB)
> but didnt work.. another error comes that CAN NOT ATTACH FILES FROM
> DIFFERENT DATABASES.
> please can any one help in this case ...my email is raza_noor@.hotmail.com
|||Hi
Does he try top attach with single file option (for more details please see
BOL) i.e without specifying .LDF file?
Don't you have proper BACKUP?
"razanoor" <razanoor@.discussions.microsoft.com> wrote in message
news:4D14A1C6-EE37-463B-A4E3-9B4F79BBA684@.microsoft.com...
> i am facing a problem for SQL 2000 Database .. We have SQL 2000 Database
> on
> customer site installed on C Partition ...MDF file is 300 MB but LDF file
> became 12 GB which took all of the C Partition Space.. Our Tech Supp
> Person
> have moved these Physical Files From C to D partition and Deleted the
> files
> and database from C partition and he created new database and tried to
> Attach
> from D partion but that gives an error(Error 9003: The
> LSN(12560:120211:1) Passed to log scan in database 'DatabaseName' is
> invalid)
> another problem is that latest backup is not available only old backup
> available.
> we restored old backup and tried to attach those files (300 MB and 12 GB)
> but didnt work.. another error comes that CAN NOT ATTACH FILES FROM
> DIFFERENT DATABASES.
> please can any one help in this case ...my email is raza_noor@.hotmail.com
|||If the Tech Supp Person did no detach database file before move it, he is
not qualified to manage a server/computer with production SQL Server.
"razanoor" <razanoor@.discussions.microsoft.com> wrote in message
news:4D14A1C6-EE37-463B-A4E3-9B4F79BBA684@.microsoft.com...
> i am facing a problem for SQL 2000 Database .. We have SQL 2000 Database
> on
> customer site installed on C Partition ...MDF file is 300 MB but LDF file
> became 12 GB which took all of the C Partition Space.. Our Tech Supp
> Person
> have moved these Physical Files From C to D partition and Deleted the
> files
> and database from C partition and he created new database and tried to
> Attach
> from D partion but that gives an error(Error 9003: The
> LSN(12560:120211:1) Passed to log scan in database 'DatabaseName' is
> invalid)
> another problem is that latest backup is not available only old backup
> available.
> we restored old backup and tried to attach those files (300 MB and 12 GB)
> but didnt work.. another error comes that CAN NOT ATTACH FILES FROM
> DIFFERENT DATABASES.
> please can any one help in this case ...my email is raza_noor@.hotmail.com

Attached DB not working properly in Vista Ultimate enviroment

hi,

i have installed SQLEXPRESS (SQL Server 9.0.3042) on my windows ultimate laptop. of late am facing this issue of database. this database is from SQl 7.0 Desktop edition(the one that i use in my office machine with Xp SP2). As such it works fine in SQL 2000 server after attachment (for test).

i have run SQLEXPRESS as administrator to make/attach new database. i can attach the database easily and can even view tables and other stuffs inside database in administrator mode. the issue pops up when i run SQLEXPRESS in normal mode. when i try to open and view the same DB's content, error pops up stating

"The database XXX is not accessible. (Micorosoft.sqlserver.express.objectExplorer)"

i cannot access this DB via VB 6 form as it dosnt show up at all in database list when tried to connect via ADODC.

i want to make this DB accessibility as normal operation, not previliged only to administrator as application run on normal mode only.

the issue dosnt arise when i locally make a new database as it can be accessed when run in normal mode also. why does this happen to database that is attached and not to ones locally made.

pls guide me as i usually do my works at home and making whole database again will surely take lots of pain. why not it just attach then start working, not asking for preveliged mode.

thanks in adv
Nyaken

Hi,

Try checking the owner of the attached database. I found that when i restored a db I had to then set the ownership afferwards otherwise I couldn't access it.

Chris

|||

hi,

thanks for the prompt re. well, as per ur suggestion i have explored all possibiliites to find a way to change the ownership of database but alas!!! i just couldnt make it. can you pls guide me to take this corrective measure, please. i hope everything must be done in administrative mode only, isnt it?

awaiting for your re

regs

ken

|||

Hi,

If you right click on the attached database and select properties then go the the files page, you should see that the second text box down (the owner field) is blank. If so, set an owner by clicking the elipsis next to the box. After you have clicked all the ok's you can check the owner was set by going back to the files page, and if the box now is not empty then the owner was set. You should be able to use the database now.

Hope this helps,

Chris

P.s. I did try to post this yesterday several times but the forum kept giving me an "unkown error"