How to create a new Enterprise Reporter SQL Database? (4374893)

How to create a new Enterprise Reporter SQL Database?

How to create a new database to replace the existing one in case of database corruption?

IMPORTANT:
You must RDP or login to your Enterprise Reporter Server using an account member of Domain Admins AD group and is a SYSADMIN on the target SQL Server. This is required to be able to run the database wizard, create the database on target SQL server with proper roles and permissions and to create the AD security groups that will grant access to the database.

The following is the process to run the Database Wizard to create a new database:

Login to your Enterprise Reporter server, then go to Programs > Quest and select Database Wizard.



In the welcome screen click Next.


Select Create Database and click Next.


Enter SQL Server name, database name and select authentication method and click next.



You may leave the default location or select where to store the data file and the log file by selecting the override default option and click Next.



Make sure the correct domain is displayed and security groups as well and click next.


If the above security groups exist you will get a warning. Just click ok and then click finish.



Go through the wizard until it completes.