Enable the Super Admin (sa) User on an SQL Server
In some iMonnit Enterprise configurations, you may use the Super Admin (sa) user on the SQL Server to manage your iMonnit Enterprise database. The sa user is disabled by default. You may need to enable this user to complete the database connection during the iMonnit Enterprise installation. You can accomplish this using the steps below.
As SQL Server is software supported by another company (Microsoft), any issues you encounter following these steps should be referred to the party that supports your SQL Server installation.
Enable the sa User
- Launch SSMS (SQL Server Management Studio).
- Log into your server.
- Expand the server by selecting the + icon to the left of the server in the Object Explorer
- Expand Security.
- Expand Logins .
Locate the sa login and right- click .
sa SQL user - Properties - Select Status.
- Enable the sa user by selecting the Enabled radial under the Login: heading
Select OK.
Set the Password for the sa User
Once the sa user is enabled, you can set the password. To do this, follow the steps below.
- Launch SSMS (SQL Server Management Studio).
- Log into your server.
- Expand the server by selecting the + icon to the left of the server in the Object Explorer.
- Expand Security.
- Expand Logins.
Locate the sa login and right-click and select Properties.
sa SQL user - Properties - Under the General tab, enter the password, and confirm the password.
Select OK.
Restart the Server
- Right click the SQL Server in the Object Explorer.
- Select Restart.
After enabling the sa user and setting the password, you should be able to successfully verify the database credentials on the first step of the Enterprise Configuration Utility.