What are the challenges you face when working across database platforms? Take the survey

Stop SQL Server from trying to login to all databases on the instance

SQL Prompt attempts to login to all databases on an instance - even databases the current user has no access to. This pollutes the SQL Server logs with errors like this:

Date 1/11/2022 1:38:35 AM
Log SQL Server (Current - 1/11/2022 2:35:00 AM)

Source Logon

Login failed for user 'DOMAIN\someuser'. Reason: Failed to open the explicitly specified database 'MyDatabase'. [CLIENT:]

Is there a way to make SQL Search not do this, or at least allow the list of databases it attempts to search be configurable?

This has been requested before in a number of places over the last few years but still is an issue in the current version.

Major KNOWN Issue --- Stop requiring product to login to all databases on server – Customer Feedback for Redgate (uservoice.com)
SQL Search causing Login failures — Redgate forums (red-gate.com)
restrict/hide database — Redgate forums (red-gate.com)



Sign In or Register to comment.