Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Frequent Login failure errors Expand / Collapse
Author
Message
Posted Friday, May 9, 2014 12:22 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 9:32 AM
Points: 94, Visits: 755
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''.
Post #1569410
Posted Monday, May 12, 2014 5:33 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
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
Post #1569781
Posted Monday, May 12, 2014 6:08 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 9:47 AM
Points: 481, Visits: 1,778
Does database 'xxxxx' definitely exist?
Post #1569799
Posted Monday, May 12, 2014 6:29 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 7:50 AM
Points: 2,262, Visits: 2,725
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’! **
Post #1569812
Posted Monday, May 12, 2014 7:30 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 9:32 AM
Points: 94, Visits: 755
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....
Post #1569843
Posted Monday, May 12, 2014 7:31 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Yesterday @ 9:32 AM
Points: 94, Visits: 755
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.
Post #1569844
Posted Monday, May 12, 2014 8:27 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 9:47 AM
Points: 481, Visits: 1,778
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.
Post #1569874
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse