Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Corresponds to warning on UI / Exception in Logs:
  • Failed to load file permissions for target SQL Server [UI]
  • Failed to load file permissions for '{0}' audit folder [UI]
  • Failed to load file permissions for SQL Services on target SQL Server [UI]
Type of exceptionUnauthorizedAccessException
CauseThe path parameter specified a directory that is read-only.-or- This operation is not supported on the current platform.-or- The caller does not have the required permission.
SolutionIn order to fix this, we need to go to the sql server installation directory and make sure that the user under which Sql Secure collector is running have enough access permissions on all the folders and files inside installation directory(uncheck "Read Only" checkbox in the properties) and not Read-only access.
New Error Message

Collector tried accessing an unauthorized directory/credentials saved on the target server

does not have the required permission.
Scroll pdf ignore
Excerpt
SQL Secure  sees who has access to what and how permissions are granted in SQL Server.
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
|
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
|
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse