Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What are the minimum SQL privileges required to install MIIS?

April 26, 2017install MIIS minimum privileges sql

0

Posted

What are the minimum SQL privileges required to install MIIS?

1 Answer

0

Posted

The MIIS installation needs to create and permission a new database in SQL, so it needs SQL administrator access. The installation process will permission the database such that the MIIS service account has sufficient privileges to access the database. If your DBA demands that they install the database before you run the MIIS setup, and that they will not allow the MIIS setup process to create databases and set permissions in SQL then you can run setup on a different server and supply them with a backup of the database created by setup. When setup runs and detects an existing database it will allow you to use that database, so the setup process will not need to create or permission anything in SQL.