When your security policies or database infrastructure change, update your Control Center connections to your database with our Database Setup Tool. Updating your database user credentials or your connection settings ensures your systems work correctly with your new configuration.
Note
For your Database Setup Tool installation, read Phase 2: Creating your database in a failover cluster.
To update your database connection settings:
-
Open Database Setup Tool.
-
Under Select your changes select or clear the following options depending on what are you updating:
Updating with Database Setup Tool
-
SQL server name or database name or authentication was changed option renames your database and sets new user authentication methods. When selected, enter the SQL Server that Control Center connects to section to change:
-
Under SQL Server that Control Center connects to > New SQL Server name enter the name of the server instance that hosts your Control Center database.
-
Under New database name enter the name of your Control Center database. NiceAN is your default database name.
-
Under Authentication type choose your login method for your SQL server. Select Windows Authentication or SQL Server Authentication depending on your SQL server configuration.
-
To log in to your database with your current Windows credentials, select Use currently logged on user.
-
To log in with different Windows credentials, clear Use currently logged on user checkbox and enter your user name and password.
-
To log in with SQL Authentication, enter your SQL user name and password.
-
-
-
User names were changed: changes your user names of your database owner and users:
-
EPM_DBADMIN is your default database owner.
-
EPM_USER is your default database user.
Note
Option User that owns the database is only available when you use a SQL Server or an Azure SQL Database Managed Instance when you set up your database.
-
-
Passwords were changed: change the passwords of your database owner and users.
-
-
Click Update.
The Database Setup Tool displays a notification - Success: Database configuration update was successful. Your database is configured and your applications are ready to use.