SQL Server backups in a Cluster
Running SQL Server 2008 R2 in a MS 2 Node Server Cluster.
My setup is as follows:
Cluster Name: KOCSQLC02D
Physical Server (Node1): KOCWSQL03D
Physical Server (Node2): KOCWSQL04D
SQL Server Default Instance: KOCSQL02DDI
SQL Server Named Instance: KOCSQL02DI1\AML
I am trying to backup both SQL Server Instances using Netbackup 7.5
We have an admin server and I am running the NetBackup 7.5 (with the SQL agent) on both physical nodes of my Cluster
Our Backup Admin has set up one Policy for both SQL instances. the policy name is: Onsite_Supreme_SQL-Cluster_Database
I have identical scripts on both phyical nodes of the cluster in this folder: C:\Program Files\Veritas\NetBackup\DbExt\MsSql
I also logged in directly to both of the phyical Servers in the Cluster and configured the Server connection settings for both SQL Server Instances.
With the Cluster Resources owned by Node 1 of the Cluster - the backups run fine.
When I fail the Cluster Resources over to Node 2 of the Cluster - I get the following error:
DBMS MSG - ODBC return code <-1>, SQL State <28000>, SQL Message <18456><[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'sa'.>.
ERR - Unable to login into SQL instance <KOCSQL02DI1\AML> as user <sa> using standard connection.
ERR - Internal error. See the dbclient log for more information.
INF - Results of executing <C:\Program Files\Veritas\NetBackup\DbExt\MsSql\KOCSQL02DI1_Full_Backups.bch>:
<0> operations succeeded. <3> operations failed.
INF - The following object(s) were not backed up successfully.
INF - Admin
Can anyone tell me what I might be doing wrong?