For installation of a DPA data repository in an MSSQL server, can it use an already existing login that is dbo in an already existing db
For registering an instance of a MSSQL server to be monitored, can I run an .sql file outside of DPA to do the setup?
I found this web page which is somewhat related:
Thanks in advance
Ben near DC
In addition to Rob's information, there is an option to register a DB without a sysadmin user via the mass registration interface and by leveraging a domain account.
Check out the Success Center article Register a SQL Server instance for DPA monitoring without sysadmin credentials
As you found, for monitoring, you can remove the sysadmin role, but have to replace them with quite a few. Check it out here: Success Center
Keep in mind that *some* functionality may be missing should the monitoring user not have sysadmin.
For the repo, sysadmin is used to create the new database and schema owner. After that, sysadmin for the repo is not persisted or used.
Are you in a position where you absolutely don't have access to sysadmin credentials?
SolarWinds solutions are rooted in our deep connection to our user base in the THWACK® online community. More than 150,000 members are here to solve problems, share technology and best practices, and directly contribute to our product development process. Learn more today by joining now.