Skip to main content

Configuring MS SQL Server Admin Password

After successfully provisioning the instance, the next step is to configure SQL Server Account of System Administrator, which has full control and administrative rights. You can log in to the SQL Server using the OS credentials you received in the email.

Logging In and Setting Password​

To log in to MS SQL, follow these steps:

  1. Open SQL Server Management Studio (SSMS), enable the Trust server certificate option and click Connect. SQL Server
  2. Once connected, the following SQL Server screen appears. SQL Server Management Studio Screen
  3. Navigate to the Object Explorer window, right-click on SQL Server Agent, and click Start. SQL SERVER Agent
  4. Navigate to Security > Logins, right-click on sa, and click on the Properties option. SQL SERVER Security SQL SERVER Properties
  5. In the General tab, set the password in the Password and Confirm Password fields. Then, disable the Enforce password policy option. Confirm Password