Re: SQL intergration error (208 Views)
Reply
Occasional Advisor
Tan SP
Posts: 9
Registered: ‎02-21-2003
Message 1 of 5 (234 Views)

SQL intergration error

Hi,

We are moving to new domain and new cluster account been created for SQL cluster. There is 2 cluster account created for SQL cluster server, 1 for quorom and 1 for SQL server.

Both cluster server has been imported to DP cell manager, 1 SQL cluster account has been added to  SQL management studio under security and assigned serveradmin role. And also map as backup operator and owner for each database.

When try to modify current SQL backup, choose show all for the database, will get error message (attached screenshot).

So try to configure the SQL backup from fresh, after choosing the cluster server, DP GUI will hang (attached screenshot).

Please advise what is causing the problem. Thanks.

Please use plain text.
Honored Contributor
JBasilio
Posts: 530
Registered: ‎11-25-2008
Message 2 of 5 (225 Views)

Re: SQL intergration error

Hello

 

Please check that users are added to DP admin group. As workaround you can add <any> <any> <any> and to check the behaviour.

Please use plain text.
Honored Contributor
Sebastian.Koehler
Posts: 1,125
Registered: ‎02-27-2007
Message 3 of 5 (221 Views)

Re: SQL intergration error

Please check if the FQDN of the physical nodes and/or virtual nodes has changed. If this is the case, you might need to export and import the clients/cluster again into the cell to match current name resolution. If the FQDN has changed, check the user configuration as JBasilio mentioned and make sure the hostname is correct for the user as well.

Regards,
Sebastian
---
Assign a kudo to this post, if you find it useful.
Please use plain text.
Occasional Advisor
Tan SP
Posts: 9
Registered: ‎02-21-2003
Message 4 of 5 (216 Views)

Re: SQL intergration error

Hi,

I do not see any previous domain account added for SQL backup so I did not add the current SQL cluster account into DP admin group.

I did the workaround step you suggested, it still have same error.

Thanks.

Please use plain text.
Occasional Advisor
Tan SP
Posts: 9
Registered: ‎02-21-2003
Message 5 of 5 (208 Views)

Re: SQL intergration error

Hi,

The SQL backup is working now. After I add <any><any><any> to admin group, then try export and import client. Configure new SQL backup, it can proceed the setup. Tested backup ok.

Thanks JBasilio and Sebastian for your suggested solution.

Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation