Forum Discussion
Information Scanner - SQL connection fails
Hello everyone,
we are currently deploying the information scanner.
The issue appeared after the scanner was already installed successfully
SQL Server is running on a custom TCP port (49999), encrypted connection, and the scanner database is existing with the correct owner (service account). We also acquired the Entra token
Error
Failed to access scanner database. Verify the database is up and running and can be accessed by scanner service account and by the currently logged in user that executes the command.
Troubleshooting steps taken:
Diag show:
Invalid database schema or cannot access the scanner DB. To update the database schema, run Update-ScannerDatabase. Make sure all nodes run the same MIP client version. SQL error: Message Could not obtain information about Windows NT group/user 'Domain\scanaccount', error code 0x5.
Update-ScannerDatabase executed - same error
Login to SQL Servers are successful
SQL CMD:
sqlcmd -S SQL.company.de,4321 -E -N -Q "SELECT @@VERSION" ## Worked
Other configs:
Tried to reregister database multiple times / service account is sysadmin at SQL server (shared)
SQL DB Alias used instead of Port / SQL Browser did not work
Allowed everything through firewall on SQL server - still fail
4h of troubleshooting gone by - and i am stuck - what can i do next?
BR
Stephan