I am new to SAG webMethods tool. I am planning to install webMethods integration software for first time (downloaded latest free trial version)
I would like to know if there are any best practices or recommended user rights settings for the SQL Server user that webMethods integration software (or its components) will use for SQL Server DB connection?
For example should we give admin rights to that user? Or should we assign any other specific role or may be minimum access/rights only?
If there is anything that you guys can comment/advice based upon your prior experience then it will be really useful
Are you aware of any Tech Community post/topic that may have some info/steps explaining how we can make webMethods installation wizard connect with SQL Server DB (instead of embedded DB) during installation?
I am asking it because it is first time I am going to install webMethods, and I am not sure if I need to specify connection string in some specific format etc or if we can just select appropriate values from drop down list during installation process for DB connection?