Versions Compared

Old Version 12

changes.mady.by.user eric revollo

Saved on

compared with

New Version Current

changes.mady.by.user Fabiola Arias Navia

Saved on

Key

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

...

Depending on the level of access and actions you want IDERA SQL Inventory Manager to perform on your environment, you should check you have the following permissions in each account:

AccountActionPermissions required
Windows User Account To install IDERA SQL Inventory Manager componentsWindows Administrator permission on the Target computer

To create and access the IDERA SQL Inventory Manager repository databases

  • Create Database Rights on the target SQL Server Instance
  • Read and write privileges on the IDERA SQL Inventory Manager Repository Databases



SQL Server login account

For most SQL queries

VIEW SERVER STATE

VIEW ANY DATABASE

VIEW ANY DEFINITION

To monitor database information

ALTER ANY DATABASE server level permission or

CREATE DATABASE in the master database

For DBCC CHECKDBsysadmin server roles
LinuxTo install  SQL Inventory Manager Repository on a Linux SQL Server
  • The
LInux
  • Linux server must be a domain member.
  • A domain user with SQL permissions on the target SQL Linux.
To query Linux Server Info
  • a Linux user.
  • a domain user with Linux login rights.
Tip

IDERA suggests that you provide SQL connection credentials with "sysadmin" server roles if you want to be able to collect all information from your environment.



SQL Inventory Manager Discover and visualize your SQL Server environment.
Scroll Ignore
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