We help IT Professionals succeed at work.

CRM Database move

Jesse_Sparks
Jesse_Sparks asked
on
1,374 Views
Last Modified: 2013-11-24
Hello, I am working on moving my CRM Database over to a new server, I have followed the Microft document on how to move the database and reconnect the CRM front end to the database and that all looks to work but I can not login to CRM now. On the new SQL server I get this message every few seconds:
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. [CLIENT: "IP of CRM frontend server]
Source: MSSQLSERVER Event ID: 18456

This is the MS article i followed to make this work: http://support.microsoft.com/kb/917948

I need to get this problem resolved as soon as possible please help.
Comment
Watch Question

Did you move your CRM Server as well? It sounds like you have "Anonymous Authentication" set on your CRM website (incorrect). Make sure "Integrated Windows" is set instead.
Take a look at that and let me know.
-Paul

Author

Commented:
If I take that same CRM server and point it back to the old Database server then the site works again with the no problem. I should also mention it is a SQL 2000 to SQL 2005 move not a straight move.
Ok,
Its most likely the user groups assignment for the database.
Map all the users allowed to access the old CRM database to the new CRM databases.
Also, make sure in the database properties you have "SQL 80 Compatibility Mode" turned on (backwards compatible SQL 2000 databases).
Try that and let me know
-Paul

Author

Commented:
Okay so I did a little work last night and i made it a bit further. i can now load the CRM while pointing to the new database server. What i can not do is click on the reports section in the CRM. When I do i get this:
Microsoft CRM Unhandled Error Details:
Server Error in '/' Application.
--------------------------------------------------------------------------------

The request failed with HTTP status 401: Unauthorized.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Net.WebException: The request failed with HTTP status 401: Unauthorized.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.  

Stack Trace:


[WebException: The request failed with HTTP status 401: Unauthorized.]
   System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) +1296
   System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) +218
   Microsoft.Crm.ReportingServices.ReportingService.GetResourceContents(String Resource, String& MimeType) +48
   Microsoft.Crm.Reports.ReportCache.get_CategoryList() +401
   Microsoft.Crm.Reports.Home.ConfigurePage() +918
   Microsoft.Crm.Application.Controls.AppPage.OnPreRender(EventArgs e) +20
   System.Web.UI.Control.PreRenderRecursiveInternal() +62
   System.Web.UI.Page.ProcessRequestMain() +1499

Author

Commented:
Any help on the above error would be great.
Jesse,
The reports server has its own authentication requirements, however, they can be customized. By default all users in the "PrivUser" group should have access to reporting. However, if something wasn't dont properly during installation, or if you are using SRS 2005 (which you would need to create a Kerberos ticket key for authentication). Can you tell me if you're using SQL 2005 with Reporting Services 2005? If not, we should look at the http://crmserver/reports and http://crmserver/ReportServer virtual directories on the report server and configure the proper authentication
-Paul

Author

Commented:
Yes I am using SQL 2005.

Here is the Setup:
Server1:
     -CRM Services
Server2:
     -SQL 2005
     -SQL 2005 Reporting services
Jessee,
On the "Server2" which is your ReportServer (please tell me this is also the server which hosts http://localhost/Reports) perform the following:
1. Go to www.microsoft.com and find a program called "adsiedit"
2. Load adsiedit on your workstation (not the server)
3. Connect to the domain with adsiedit and find the computer object for Server2
4. Right Click and go to Properties
5. Scroll down until you find the ServicePrincipalName field
6. Double click ServicePrincipalName to edit it
7. Ensure the following is in the list:
HOST/Server2
HTTP/Server2

8. Check to see if you still get the error
9. If you do open IIS Manager on Server2
10. Find the "Default Website"
11. Find the virtual directory called "ReportServer"
12. Right Click "ReportServer" and go to "Directory Security" tab
13. Ensure that "Integrated Windows" is checked and "Anonymous" is not checked
14. Perform an IIS-Reset
15. Check it again to see if you get the error
16. If you do, attempt to navigate to "http://localhost/Reports" from Server2
17. If you get the same error, post here and tell me so we can troubleshoot some more.

-Paul

Author

Commented:
Hey Paul,

Thanks for all of your help, I am still getting errors here is what I can do so far.

If I go to http://sqlsrv/reports or http://sqlsrv/reportserver I can access reporting services and I can see my organizations CRM reports.
If I go to http://crmsrv and login the interface comes up and then I click on Reports and I get an error.  I have checked the logs and I can not find any authentication errors.

Here is the error:
Microsoft CRM Unhandled Error Details:
Server Error in '/' Application.
--------------------------------------------------------------------------------

The request failed with HTTP status 401: Unauthorized.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Net.WebException: The request failed with HTTP status 401: Unauthorized.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.  

Stack Trace:


[WebException: The request failed with HTTP status 401: Unauthorized.]
   System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall) +1296
   System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters) +218
   Microsoft.Crm.ReportingServices.ReportingService.GetResourceContents(String Resource, String& MimeType) +48
   Microsoft.Crm.Reports.ReportCache.get_CategoryList() +401
   Microsoft.Crm.Reports.Home.ConfigurePage() +914
   Microsoft.Crm.Application.Controls.AppPage.OnPreRender(EventArgs e) +20
   System.Web.UI.Control.PreRenderRecursiveInternal() +62
   System.Web.UI.Page.ProcessRequestMain() +149
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION

Author

Commented:
Thank you

Author

Commented:
Still  need help with the report part.

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.