SQL Server Standard - Connection with Windows Integrated Authentication failed
Check that the network connectivity to the SQL Server Standard instances, on the given Windows server, is open, as per the info in the SQL Server Configuration Manager, which shows which network port is being used by which SQL instance. All the given network ports (for SPLA-relevant SQL Server Standard instances should be accessible from the OC Scanner server, so we can enumerate the SQL Server Standard users on the given instances).
Check that the account running the scan has access to each and every SQL Server Standard instance that is SPLA relevant. To access the SQL Server Standard instances, we use an ODBC connection, and to allow the account to access the server, we need to add the account as a login on each SQL Server Standard instance, and assign that login the ‘sysadmin’, and ‘public’ SQL roles. To scan the SQL Server Standard systems, we can use either a Domain account (with the appropriate privileges added, as above), or we can also use a local SQL account (with the same privileges as above). If using a local SQL account, then we need to navigate to OC Configurator > Specific scan file > Servers > Specific entry > User settings > SQL Server Standard > Add > Add the given SQL Server FQDN/IP, and the appropriate local SQL account. If all the SQL instances on the given server can be accessed with the same account we can leave the Instance IP Address/Instance name section blank, or if they are using different credentials, then we need to define each instance with its own set of credentials, and the Instance IP/Name.
Make sure that Windows integrated authentication and SQL authentication is active on all SPLA relevant SQL instances, as required.
If you do not want to scan SQL Server Standard users on a specific SQL Server Standard machine, then we can navigate to OC Configurator > Specific scan file > Servers > Specific entry > User settings > SQL Server Standard > Add > Add the given SQL Server FQDN/IP, and toggle the SQL user scan to off. Such as SQL Server Standard machine would be automatically reported as a SQL Server Standard licensed per Core.
If the OC Scanner server and the SQL Server Standard machine are not in the same AD Domain, then we need to use a local SQL account, to enumerate the SQL Server Standard users, as described above.