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 name and password are used to verify the user's identity. To authenticate to 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
Windows authentication verifies the user's identity 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 rights required for authentication.