SQL error logs filling up

Question

SQL error logs filling up

Austin_123

SSCommitted

Points: 1648
More actions
February 21, 2017 at 6:00 am

#340961

Hi All.
We recently started seeing issues in a sql login on DR instance\server which is configured for database mirroring and login was replicated from PROD instance. Below error is filling the SQL errorlog with ratio of 200 MB / hr on DR server.
This error is occurring for single database only whereas the login has access on other databases on PROD and mirroring is configured for them also.
Login failed for user 'xyzuser'. Reason: Failed to open the explicitly specified database 'abc'. [CLIENT: xx.xx.xx.xx]
Message
Error: 18456, Severity: 14, State: 38.
Thanks in advance.
Regards,
Austin

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

You need to investigate why the client machine (the IP address you blanked out) is trying to connect to the wrong server. This isn't something that can be fixed on the server, the mirror DB is inaccessible.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Austin_123 SSCommitted Points: 1648 More actions · Answer 2

Thanks Gail for the help.
Yes, I have overlooked the client connection where it was originating.
Thanks again.

Eric M Russell SSC Guru Points: 125524 More actions · Answer 3

You might as well disable the login until the application is fixed.

"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

Steve Jones - SSC Editor SSC Guru Points: 734552 More actions · Answer 4

I'd be careful about disabling if the login can access other databases.

I'd track down what the client is doing here, as Gail noted.