Skip to Content
0
Former Member
Jan 12, 2011 at 06:26 PM

Change SQL server location for Crystal Reports Server XI

314 Views

We are running Crystal Reports Server XI and we want to migrate our SQL Server portion off of the current box and onto our new SQL cluster. The Crystal Reports Server install should remain intact, and I want to move the SQL server to the new box and then point the install to that new server and be on my way. Unfortunately I'm having a real tough time with this.

I've searched through the forums and looked through the documentation and I'm not sure what to do. I've copied over the SQL database to the new server, but I'm having trouble getting the connection to work. I've tried goin gto the connection page of the CMC properties page (from the CCM) and setting the CMS Data Source to point to the DNS (by select a data source). I'm using "use trusted connection" and it says "CMS database setup completed", but when I try and start the CMC it stops right away with the error:

"The root server reported an error Initialization Failure. (Reason: Unable to connect to the database using the provided connection string. Reason: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.).

" I've tested the File DNS and it says that it is setup successfully.

So what am I doing wrong? Is there some kind of step by step guide on how I can do what I need to do?

Edited by: holodude on Jan 12, 2011 7:27 PM