Login failed for user :18456.Please advise

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Administration

Author

Topic

Ravikumarc
Yak Posting Veteran

51 Posts

Posted - 2011-03-03 : 18:01:20

Dear All,

In the event Viewer the below mentioned error is throwing..I have checked all my ODBC connectivity user names and password,Scheduled jobs etc..i have Google it but unable to find the root cause. Please advise and help me out in this issues..

Event Type: Failure Audit
Event Source: MSSQLSERVER
Event Category: Logon
Event ID: 18456
Date: 3/2/2011
Time: 3:00:14 AM
User: N/A
Computer: AsdaQA
Description:
Login failed for user 'SamProd'. Reason: Failed to open the explicitly specified database. [CLIENT: 187.143.10.27]

Thanks & Regards
Ravi

X002548
Not Just a Number

15586 Posts

Posted - 2011-03-03 : 18:09:28

is it a windows or sql server login?

I'm guessing sql server

Have you checked to login?

Has it been revoked?

Try reseting the password

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2011-03-04 : 05:58:26

"Reason: Failed to open the explicitly specified database."

Check the user's default database.
Check the database specified in the connection string.

If you can, read/post the associated message in the SQL Server error log.

Ravikumarc
Yak Posting Veteran

51 Posts

Posted - 2011-03-04 : 12:01:04

Hi Brett,

Yes iam using Sql sever logins,i checked d Logins and also i am able to login and Verified d connection strings and default DB all are fine.Iam getting this error for a particular period of time i.e from 2:30AM to 3:30 Am... Please advice

Thanks
Ravi

quote:
Originally posted by X002548

is it a windows or sql server login?

I'm guessing sql server

Have you checked to login?

Has it been revoked?

Try reseting the password

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

TG
Master Smack Fu Yak Hacker

6065 Posts

Posted - 2011-03-04 : 17:03:03

>>for a particular period of time i.e from 2:30AM to 3:30 Am
Perhaps the db is not available during this time. For instance is it a database that is log shipped from another server? Are there maintenance plans running during that time that sets the state to single user, etc...

Be One with the Optimizer
TG

Ravikumarc
Yak Posting Veteran

51 Posts

Posted - 2011-03-04 : 19:09:03

Thanks for your information TG,it helps me to solve the issue.Yes u r right there is a restore job scheduled at that time..Thanks again

Regards
Ravi

quote:
Originally posted by TG

>>for a particular period of time i.e from 2:30AM to 3:30 Am
Perhaps the db is not available during this time. For instance is it a database that is log shipped from another server? Are there maintenance plans running during that time that sets the state to single user, etc...

Be One with the Optimizer
TG

mtyson79
Starting Member

3 Posts

Posted - 2011-07-11 : 12:14:17

Hello all, we have the same error that developed this weeeknd and no changes were made. We are using SQL 2008R2 and SharePoint 2010 with a windows AD account. All app pools are started and account can log into servers.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources