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

• 
  Hi jluebbers,
  Thank you for your forum post.
  
  Yes this is a known problem and one that still exists in SQL Search.
  
  If you have not already done so, please may you vote and comment on the UserVoice forum post:
  Major KNOWN Issue --- Stop requiring product to login to all databases on server – Customer Feedback for Redgate (uservoice.com)
  
  Unfortunately there is not any option in SQL Search to prevent this from occurring or configure a list of databases for the tool to connect.
  
  I will feedback your comments to the Development Team.
  
  Many Thanks
  Eddie
  

  Eddie D November 03, 2022 16:24

  - 0 +
• 
  Thanks Eddie - I voted on the UserVoice page, for clarity here's the comment I put there:
  
  

  This should be trivial to fix: whatever SQL query SQL Search is emitting to enumerate databases on an instance just needs to have a condition added to its WHERE clause to check whether the current user has access to a given DB, eg:

  
  

  ...WHERE has_dbaccess(name) = 1 

  
  

  or similar.

  jluebbers November 03, 2022 21:42

  - 0 +
• 
  Hi jluebbers,
  I have some further information you maybe pleased to hear.
  
  The Development Team responsible for SQL Search are in the process of adding a fix for this situation.  I do not have an accurate ETA but the team plan to release this fix sometime next week.
  
  I will update this post, when I have information that the new version has become available
  
  Many Thanks
  Eddie

  Eddie D November 07, 2022 17:27

  - 0 +
• 
  Thanks Eddie - please let us know when the fixed release is available.

  jluebbers November 15, 2022 22:31

  - 0 +
• 
  Hi Eddie - any update on when the fixed version will be released?

  jluebbers December 12, 2022 23:15

  - 0 +
• 
  How does SQLSearch_3.6.1.3286.exe released on February 21, 2023 resolve this issue (if at all)? Thank you

  iokevins March 09, 2023 23:21

  - 0 +
• 
  Hi,
  To answer your question:
  
  

  How does SQLSearch_3.6.1.3286.exe released on February 21, 2023 resolve this issue (if at all)? Thank you

  According to the SQL Search V3.6.1 releases notes does include fix for the problem, where it stops the attempted indexing of databases that the current user has no access to.

   Do you still experience the reported problem?
  

  Many Thanks

  Eddie

  Eddie D March 20, 2023 11:24

  - 0 +
• 
  Thank you, I'll re-install.

  iokevins March 20, 2023 19:04

  - 0 +

Add comment

Please sign in to leave a comment.