'Failed to connect to SQL Server (local\TACVISTA). [18470] Login failed for user 'xxx\xxxxx'. Reason: The account is disabled.

Issue

'Failed to connect to SQL Server (local\TACVISTA). "[18470] Login failed for user 'xxx\xxxxx'. Reason: The account is disabled." message appears when trying to install Vista using another account than the account that is logged on to the server.

Product Line

TAC Vista

Environment

TAC Vista 5.1.X

SQL installation/connection

Cause

The TAC Vista installer SQL configuration settings page states 'Select authentication and specify SQL Login or Windows account and password to set how TAC Vista Server will access the SQL server.' This means how TAC Vista will access the SQL server when Vista is running, not during installation.

Resolution

Ensure that the user running the TAC Vista installer has the correct permissions to install an SQL server (if this is a new database) and configure it. The specified user will be used during runtime, but the launching user during installation. The installing user can then be removed from the SQL server security settings after installation is complete.