Move CRM 4 Database and Reports from SQL 2005 to 2008 R2

All replies

• 

  

  0

  Sign in to vote

  Can you access the report server url from the web browser? http://yourserver/reports 

  if not go to the Report Services Configuration Manager and see it everything is setup correctly.

  ---

  MSCRM Bing'd - http://bingsoft.wordpress.com

  Tuesday, July 13, 2010 10:17 AM

  Moderator
• 

  

  0

  Sign in to vote

  I can access the URL but on http or https, both ask for a certificate. if i accept this in my ie, there comes an auth page.
  after entering my userdata, there comes the message rsAccessDenied. My user has not enough rights to access.
  
  but exactly this messages comes on my running system with sql 2005 and on it everything works fine?!
  do i have to install iis 7 first and then install sql 2008 r2? is the sql dataconnector required on crm server? atm it works without it.

  Tuesday, July 13, 2010 10:26 AM
• 

  

  0

  Sign in to vote

  Hi Oliver,

  Yes try to intall IIS 7 with Windows and Basic Authentication Checked, also ASP.net and Application Server role installed.

  Then run the Reporting Services Configuration Manager and configure it, then make sure that you have access to the report server and the report manager, if not create new site for the reporting server and manager and check.

  And for the DataConnector, it's better to have it installed after checking the report server.

  Hope this helps.

  Thanks,

  ---

  Ahmed ElNoby http://ahmedelnoby.blogspot.com

  • Edited by Ahmed ElNoby Tuesday, July 13, 2010 11:25 AM DataConnector

  Tuesday, July 13, 2010 11:23 AM
• 

  

  1

  Sign in to vote

  You do not need IIS on your SQL box with SQL 2008.

  You are going to have to connect to the Reports site and the user that you use when using deployment manager needs access to this. If you account does not then log in with accoutn that does and gove yourself access or run deplyment manager as the account that does have access.

  ---

  MSCRM Bing'd - http://bingsoft.wordpress.com

  Tuesday, July 13, 2010 11:33 AM

  Moderator
• 

  

  0

  Sign in to vote

  Hmm,

  i don't get it handled with ReportingServer. I changed the service account to a domain admin (for testing), restarted services etc.
  on page http://sqlserver/Reports i get http 404 Page not found and on http://sqlserver/Reportserver

  Now i deleted the SSL Ports for Reportingservice and then i get this page loaded "http://srvsql/Reports/Pages/Folder.aspx" with an error

  My CRM deplyement manager now says. 401 Unauthorised. The Certificate error is gone.
  
  In which group do i i have to put my adminuser/server to get access to this server? is it in local groups on sqlserver? Or do i have to add
  someone with the sql config manager?

   

  Tuesday, July 13, 2010 2:17 PM
• 

  

  1

  Sign in to vote

  You need access to the Reports site so you can add your user deployment manager to the report server security. I assume the CRM Reporting AD Group does not have permissions to the new SQL Report site yet either but I imagine this gets set when you run through deployment manager but to do so, your deployment manager account needs access to the Reports site/Reportserver web service to be able to handle this.

   

  I hope someone corrects me if I'm heading down the wrong road here but I'm fairly certain this is correct.

  ---

  MSCRM Bing'd - http://bingsoft.wordpress.com

  • Marked as answer by Jim Glass Jr Wednesday, July 21, 2010 4:23 PM

  Tuesday, July 13, 2010 3:16 PM

  Moderator
• 

  

  0

  Sign in to vote

  If you mean through the /Reports Page, there is the same Problem. I can't access this page.
  it stops with error "http://srvsql/Reports/Pages/Folder.aspx", that it could not connect to the backend server?
  
  i changed to explicit ip v4 adress for both services, changed the service account but it doesn't matter.
  
  
  

  Tuesday, July 13, 2010 4:23 PM
• 

  

  0

  Sign in to vote

  Have you checked your event log to see if you get a more specific error message or the reporting services log. What is the reporting services service account running as. This account needs access to SQL server too.

  ---

  MSCRM Bing'd - http://bingsoft.wordpress.com

  • Marked as answer by Jim Glass Jr Wednesday, July 21, 2010 4:23 PM

  Wednesday, July 14, 2010 9:01 AM

  Moderator
• 

  

  0

  Sign in to vote

  I can't see any special events that could point to my problem.
  
  I have reinstalled my complete sql server twice with many different settings but i can't connect to this annoying ReportServer.
  
  - Tried different Service accounts for sql db server and reporting server

  - tried with and without iis (but this should not matter because of sqls own iis server)

  - added my admin user in setup screen to all services i have installed as default admin

  - disabled uac and firewallsettings

  - only started Reports and Reportserver on port 80 without ssl. with ssl it instantly fails

   

  are there any other recommend settings for sql 2008 r2? which accounts should i use to run db service and reportingservice?

  My next try will be installing sql 2008 sp1. maybe this one will work in the default install settings...i have never had such a problem
  with sql server.

  Thursday, July 15, 2010 1:16 PM
• 

  

  0

  Sign in to vote

  So i think i have fixed my problem. it was the dns name which was wrong.
  i tried http://sqlserver/Reports but the webserver only seems to accept http://sqlserver.domain.local
  
  The server only accepts https connections so the http will be redirected to a wrong dns name.
  
  Note: This now works with sql 2008 sp1! i did not test it with sql 2008 R2 but maybe it will help too
  
  
  

  Thursday, July 15, 2010 4:38 PM