Date: 26/09/2006
NV Version: All
OS Version: Windows
Application version: MS SQL 2003
Plugin version: All
Description:
Steps to take to allow the SQL Plugin to log in for the backup
Symptoms:
Backup jobs for MS SQL can be configured and the instances can be browsed. However, once the backup starts it fails with the following error:
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
This error is most likely caused by insufficient user rights. First, if MSSQL is configured to use Windows authentication only, make sure that the SQL plugin is configured to use Windows authentication instead of SQL authentication - right-click) on "All instances" and select "Windows authentication".
Secondly, check which user the local NetVault Service is running as - right-click on the service in the Windows service panel and check the "log on" tab. If it is running as the "Local System" account, try running it as the same user than the SQL server service is running as. This should enable the backup. If this is not acceptable as a workaround, then create a user that has the same privileges and run the NetVault service as that.
