Authentication

Authentication

SQL Server Authentication

SQL Server Authentication is an alternative authentication mode that can be used when Windows Authentication is not available. In this mode, a SQL Server login and password are used to verify the user’s identity. To authenticate with SQL Server using SQL Server authentication, the user must have a valid SQL Server login account with the permissions required to perform the desired tasks.

Windows Authentication

With Windows authentication, the user’s identity is verified based on their Windows user account. This means that the user does not need to log in with a separate SQL Server username and password. Instead, the user is automatically authenticated when they log in with their Windows user account. This authentication is only relevant for Windows systems and does not work with Docker or Linux.

Important

Even if a different Windows user was used for the connection test, the OPC Router service user must have the necessary permissions for authentication.

Notes on configuring Windows user accounts for the OPC Router.