Selecting a proper authentication mode when configuring SQL
Server connection
Of the authentication modes provided by SQL Server Management
Studio (SSMS), the following modes are supported for connecting with the
SQL Server database.
-
Windows Authentication (Server Credentials)
-
SQL Server Authentication
-
Active Directory Password Authentication
-
Active Directory Integrated Authentication
The modes are available as options in the Authentication dropdown when you set up the
connection to SQL Server in the Database
Configuration dialog box. Be aware of the following before
deciding which mode to select:
-
If SSMS uses the SQL Server
Authentication or Active Directory
Password Authentication mode, you may directly select the
same mode in the Authentication
dropdown. -
If SSMS uses the Windows
Authentication or Active Directory
Integrated Authentication mode, it means that the SQL
server has integrated Windows authentication. There is an important
difference between how the mode works in traditional C/S app and
installable cloud apps:-
In traditional C/S apps, the Windows
Authentication or Active
Directory Integrated Authentication mode would use
the Windows user account at the client
machine for authentication by the SQL Server; -
In installable cloud apps, the Windows Authentication or Active Directory Integrated
Authentication mode would use the Windows user
account at the web server for
authentication by the SQL Server;
If you cannot accept the difference, it is strongly
recommended that you change the authentication mode at SSMS and then
here in the Authentication dropdown to be SQL
Server Authentication or Active
Directory Password Authentication. -