SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Frequent Login failure errors


Frequent Login failure errors

Author
Message
Robin35
Robin35
Mr or Mrs. 500
Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)

Group: General Forum Members
Points: 592 Visits: 1221
Hello,

I'm seeing continuous login failure error messages in error log.

Environment :

SQL 2005
Windows 2003
Login : service account ( it is enabled and it has Sa access , and sql and agent services are running under the same service account ).

No one uses this instance, error log gets filled up frequently because of these continuous messages.

I disabled all the job including replication jobs and i have removed replication also, still i'm seeing the same error messages. Not sure who is connecting the instance , i ran a profiler trace to see the activity.

I dont see any different activity except the following, can anyone please help to get rid this issue

EXECUTE msdb.dbo.sp_sqlagent_log_jobhistory @job_id = 0x25A8936F3CA0FE4E92565625F577E97C, @step_id = 2, @sql_message_id = 0, @sql_severity = 0, @run_status = 2, @run_date = 20140509, @run_time = 140311, @run_duration = 1, @operator_id_emailed = 0, @operator_id_netsent = 0, @operator_id_paged = 0, @retries_attempted = 37451, @session_id = 36, @message = N'The replication agent encountered an error and is set to restart within the job step retry interval. See the previous job step history message or Replication Monitor for more information.'

EXECUTE msdb.dbo.sp_sqlagent_log_jobhistory @job_id = 0x25A8936F3CA0FE4E92565625F577E97C, @step_id = 2, @sql_message_id = 0, @sql_severity = 0, @run_status = 4, @run_date = 20140413, @run_time = 105524, @run_duration = 6270748, @operator_id_emailed = 0, @operator_id_netsent = 0, @operator_id_paged = 0, @retries_attempted = 0, @session_id = 36, @message = N'
2014-05-09 18:03:11.941 Copyright (c) 2005 Microsoft Corporation
2014-05-09 18:03:11.941 Microsoft SQL Server Replication Agent: logread
2014-05-09 18:03:11.941
2014-05-09 18:03:11.941 The timestamps prepended to the output lines are expressed in terms of UTC time.
2014-05-09 18:03:11.941 User-specified agent parameter values:
-Publisher xxxxx
-PublisherDB xxxxx
-Distributor xxxxx
-DistributorSecurityMode 1
-Continuous
-XJOBID 0x25A8936F3CA0FE4E92565625F577E97C
-XJOBNAME xxxxx-xxxx-xx
-XSTEPID 2
-XSUBSYSTEM LogReader
-XSERVER xxxxx
-XCMDLINE 0
-XCancelEventHandle 0000000000000920
-XParentProcessHandle 0000000000000EEC
2014-05-09 18:03:12.019 Status: 0, code: 20015, text: ''Cannot open database "xxxxx" requested by the login. The login failed.Login failed for user ''domain\xxxxx''.''.
2014-05-09 18:03:12.019 Cannot open database "xxxxx" requested by the login. The login failed.Login failed for user ''domain\xxxxx''.
durai nagarajan
durai nagarajan
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1603 Visits: 2775
is this ''domain\xxxxx'' is your service account?

if it is are your sure it is Sysadmin in that server, looks like it doesn't have access to the DB as per the error.

Regards
Durai Nagarajan
Beatrix Kiddo
Beatrix Kiddo
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2668 Visits: 4391
Does database 'xxxxx' definitely exist?
HanShi
HanShi
SSCarpal Tunnel
SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)SSCarpal Tunnel (4.4K reputation)

Group: General Forum Members
Points: 4363 Visits: 3668
This type of error usually occurs when the default database defined for the login is not accessible by this login (either no permission or does not exist)

** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Robin35
Robin35
Mr or Mrs. 500
Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)

Group: General Forum Members
Points: 592 Visits: 1221
Beatrix Kiddo (5/12/2014)
Does database 'xxxxx' definitely exist?


Thanks for the response...

The database xxxx doesnt exist....i'm not sure where this connection is coming from....
Robin35
Robin35
Mr or Mrs. 500
Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)Mr or Mrs. 500 (592 reputation)

Group: General Forum Members
Points: 592 Visits: 1221
durai nagarajan (5/12/2014)
is this ''domain\xxxxx'' is your service account?

if it is are your sure it is Sysadmin in that server, looks like it doesn't have access to the DB as per the error.



Thanks for the response...

yes, its a service account and it has Sa access on the box and instance.
Beatrix Kiddo
Beatrix Kiddo
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2668 Visits: 4391
Robin35 (5/12/2014)
Beatrix Kiddo (5/12/2014)
Does database 'xxxxx' definitely exist?


Thanks for the response...

The database xxxx doesnt exist....i'm not sure where this connection is coming from....


Is there anything in the SQL Server log? It usually gives you the IP address the login is trying to connect from, and you can do a ping -a to get the hostname.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search