locked
Problems Installing CRM 4.0 on Win Sever 2003, SQL2005 and Exchange 2003 RRS feed

  • Question

  • I'm trying to install CRM 4.0 on a windows 2003 server. SQL server 2005 (SP 3 with reporting services loaded) is resident on the same box. Exchange server 2003 is located on a different box which happens to be the domain controller for the domain. The install gets as far as checking the system requirements and fails with an error "Setup failed to validate specified Reporting Services Report Server...". There are a pair of error messages in the event log Event Id 17207 and Event Id 17204 both of which indicate a problem with the file C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\crm_MSCRM.mdf.

    Since this file doesn't exist I assume its trying to create it so I set full control to everyone temporarily to see if that would solve the problem. It didn't. What needs to be done to help this install progress.

    I have also tried on a totally unrelated Windows Server 2008 box with Exchange 2007 and SQL 2008 on it and get the same result.
    Wednesday, May 6, 2009 4:41 PM

Answers

  • Hi

    I was unable to open the reports website, the errors pointed to thwe network service account not having write permissions into C:\windows\microsoft.net\framework\v2.0.50727\temporary ASP.NET files folder.

    Tiaan - I looked at the SSRS configuration screen and there were no red crosses.

    So, I gave the networkservice accout modify permissions to the temporary ASP.NET files folder. This now enables the web site to start, but I now get an error, Could not find stored procedure 'GetOneConfigurationInfo'.

    I reran the installation and it still ends at the same point, but now its pointing to a permissions error. I'm using the network service account (as I was recommended to) is this correct or should I be using a domain admin user. What permissions should I have to set where?

    Thanks

    Nigel Fisher

    Thursday, May 7, 2009 2:41 PM

All replies

  • are you able to open the report server in a browser window with a URL like http://ReportServerName/reportserver on the machine where you are installing CRM?
    Best Regards, Donna
    Wednesday, May 6, 2009 5:35 PM
  • HI Nigel!
    Donna is correct!
    Open the SSRS in the web http://servername/reports see if you are seeing a yellowish web application!
    If you do then your SSRS is not configured correctly or you can
    Use the SSRS configuration Wizard and make use that all the red crosses are green.

    You menetioned that there seems to be a problem with:
    C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\crm_MSCRM.mdf. This is your actual MSCRM database.

    To get arround the diagnostic wizard at the installation section:
    try:

    SSRS Server: http:// ip address/reportserver
    http://Servername/reportserver
    http://localhost/reportserver

    Tiaan van Niekerk http://crmdelacreme.blogspot.com Skype:tiaan.van.niekerk1
    Thursday, May 7, 2009 3:44 AM
  • Hi

    I was unable to open the reports website, the errors pointed to thwe network service account not having write permissions into C:\windows\microsoft.net\framework\v2.0.50727\temporary ASP.NET files folder.

    Tiaan - I looked at the SSRS configuration screen and there were no red crosses.

    So, I gave the networkservice accout modify permissions to the temporary ASP.NET files folder. This now enables the web site to start, but I now get an error, Could not find stored procedure 'GetOneConfigurationInfo'.

    I reran the installation and it still ends at the same point, but now its pointing to a permissions error. I'm using the network service account (as I was recommended to) is this correct or should I be using a domain admin user. What permissions should I have to set where?

    Thanks

    Nigel Fisher

    Thursday, May 7, 2009 2:41 PM