What are the SQL components are required for NPM, NTA, IPAM

Question

Hi All,

Can someone please help me to understand, what all SQL Components are required for Solarwinds NPM, NTA, IPAM. I've explore much but couldn't find exact details. Any suggestions are much appreciated.

Br,

Vijay

vijay.ithape · Answer

There are couple of SQL Component Option that we get while installing SQL, as per Solarwinds Documentations, it says below components to be selected -

SQL Server System Common Language Runtime (CLR) Types. Orion products use secure SQL CLR stored procedures for selected, non-business data operations to improve overall performance.
Microsoft SQL Server Native Client
Microsoft SQL Server Management Objects

I couldn't find these options rather, I see, SQL Agent, etc. etc. There is no such documentation also available that can help :(

Any leads would be highly appreciated.

mesverrum · Answer

What do you mean by sql components? You need to have a working sql server to connect to with an SA level account to set up the databases but the installer does all that work for you and deploys everything the app servers need.  You basically just next next next through the install and it handles what needs to be handled.