SPA cannot connect to the SQL database after it has been moved to a new server. (NETIQKB73197)
This document (7773197) is provided subject to the disclaimer at the end of this document.
Unable to connect to the SPA SQL database.
Receive: "Not associated with a trusted SQL Server connection" error.
To resolve this issue, validate that you are able to connect to the new SQL database using the SPA Service account credentials by performing this native test:
- Launch SQL Server Enterprise Manager
- Go to Tools and SQL Query Analyzer
- Select the SQL server the new SPA database has been moved to
- Select SQL Server authentication and put in the credentials for your SPA Service account
Provided the credentials are correct, you will be able to connect to the database. If you are not able to connect, please see the following Microsoft article for resolution: http://support.microsoft.com/kb/829868/
This Support Knowledgebase provides a valuable tool for NetIQ/Novell/SUSE customers and parties interested in our products and solutions to acquire information, ideas and learn from one another. Materials are provided for informational, personal or non-commercial use within your organization and are presented "AS IS" WITHOUT WARRANTY OF ANY KIND.
- Document ID:7773197
- Creation Date:07-OCT-11
- Modified Date:07-OCT-11
- NetIQSecure Password Administrator
Did this document solve your problem? Provide Feedback