iMonnit Enterprise - Enabling the sa User on a SQL Server

In some iMonnit Enterprise configurations, you may use the sa (Super Admin) user in the SQL Server to manage your iMonnit Enterprise database. The sa user is disabled by default. You may need to enable this user in order to complete the database connection during the iMonnit Enterprise installation. You can accomplish this using the steps below.

Note: As SQL Server is a 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.

Enabling the sa user

  • Launch SSMS (SQL Server Management Studio)
  • Log into your server
  • Expand the server (select the + icon to the left of the server in the Oject Explorer)
  • Expand Security
  • Expand Logins
  • Locate the “sa” login and right click
    SA Properites
    View Full Size
  • Select Status
  • Enable the user by selecting the “Enabled” radial under the “Login:” heading
  • Select OK
    Enable SA

Settings the password for the sa user

Once the sa user is enabled, you will want to set the password. To do this, follow the steps below.

  • Launch SSMS (SQL Server Management Studio)
  • Log into your server
  • Expand the server (select 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 Properties Select
    View Full Size
  • Under the General tab, enter the password, confirm the password
  • Select OK
    SA Set Password
    View Full Size

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 Utilit.



×

Call today for live expert advice & save 10% on your first order!

 801.561.5555

Or enter your phone number or email and we'll contact you.