How to set the authentication type in MS MSQL 2016

book

Article ID: 127794

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction

I am unable to install UIM 9.02. I am unable to get past the test button when testing the database connection. 

<Please see attached file for image>

uim database test fails

When MS SQL 2016 is installed you have to make sure that you select Server Authentication SQL Server and WIndows Authentication mode
 

Environment

Release:
Component: UIMINS

Resolution

1. login to the DB environment where MSSQL 2016 is installed.

2. Login to DB via SSMS using windows authentication mode.

3. Right click on the localhost/machine name coming in the first line and select properties.(Properties panel will open)

4. select the security tab from the left pane of the properties panel.

5. Server authentication mode to SQL server and windows authentication mode (That is the second check box).click ok if it ask to restart.

6. after this you have to restart the MSSQL service so for that go the services by and look for MSSQL restart the service click of if it ask for more services to start along with MSSQL.

<Please see attached file for image>

MS SQL 2016 security gui

 

To enable the sa login

  1. In Object Explorer, expand Security, expand Logins, right-click sa, and then click Properties.

  2. On the General page, you might have to create and confirm a password for the login.

  3. On the Status page, in the Login section, click Enabled, and then click OK.

Attachments

1558689793171000127794_sktwi1f5rjvs16g12.png get_app
1558689790158000127794_sktwi1f5rjvs16g11.png get_app