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
-
Microsoft Entra Password
-
Microsoft Entra Integrated
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 Microsoft Entra Password mode, you may directly select the same mode in the Authentication dropdown. The user credentials specified in the Database Configuration dialog or the transaction LogID and LogPass will be used for authentication.
When "Allow dynamic connection using the transaction LogID and LogPass" is selected, the user credentials from the transaction LogID/LogPass will be used for authentication. This way, different users may use different credentials. (And the user credentials specified in the Database Configuration dialog is still required, not for the authentication, but for the build process to convert DataWindows to models).
And the active directory being connected is configured in the SQL Server.
-
If SSMS uses the Windows Authentication or Microsoft Entra Integrated 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 Microsoft Entra Integrated 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 Microsoft Entra Integrated 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 Microsoft Entra Password.
-
