October 31, 2017 at 11:32 am
In one of prod server i can see logon failures, the login is windows account and has sysadmin access, which is trying to access offline database,
we have enabled failure logons auditing, can some one help me how do i stop them in error log,
the account is service account for one of other SSIS server,
Thanks
Sunny
October 31, 2017 at 12:09 pm
Potentially, if it's a service account, there's an SSIS package that is trying to access the offline database.
Alternatively, it could be that the login on the SQL Server for that account has its default database set to the offline database.
I'd start with the second possibility for troubleshooting as it's the quickest and easiest to check.
October 31, 2017 at 12:20 pm
I used to see these errors a lot with SQL Search from RedGate. If you have all the databases ticked, it would try to search the offline databases, generating the error.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 31, 2017 at 12:45 pm
jasona.work - Tuesday, October 31, 2017 12:09 PMPotentially, if it's a service account, there's an SSIS package that is trying to access the offline database.
Alternatively, it could be that the login on the SQL Server for that account has its default database set to the offline database.I'd start with the second possibility for troubleshooting as it's the quickest and easiest to check.
Thanks Jasona, the default database for the login is master, how could i find the SSIS package trying to access the offline database?
-Sunny
October 31, 2017 at 12:54 pm
G Sunny - Tuesday, October 31, 2017 12:45 PMjasona.work - Tuesday, October 31, 2017 12:09 PMPotentially, if it's a service account, there's an SSIS package that is trying to access the offline database.
Alternatively, it could be that the login on the SQL Server for that account has its default database set to the offline database.I'd start with the second possibility for troubleshooting as it's the quickest and easiest to check.
Thanks Jasona, the default database for the login is master, how could i find the SSIS package trying to access the offline database?
-Sunny
Presuming the package is being run as an Agent job, match up the times when you see the failed login to jobs that run around that time.
If the package is being run "manually," you'll need to try to find the person running it and ask them which package they ran.
Otherwise, you'd probably need to go through each SSIS package you have looking at connections and SQL steps for the offender.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply