locked
MSCRM 2011 - Installation issue with external SQL server RRS feed

  • Question

  • Hi all,

     

    I am getting an issue during MS CRM installation on Microsoft SQl Sever verification. The error message is SQLSERVERAGENT service is not running on the server CRMSQLSERVER.

    I can log to this server using SQL management studio. I also test that there is no firewall issue with telnet command I can access from one server to the other. User that runs MS CRM installation is sysadmin on dB server.

    Could you help to solve this configuration problem?

     

    Thanks in advance,

     

    CC  

    Tuesday, August 9, 2011 9:18 AM

Answers

All replies

  • Hi,

    In SQL Server Machine, type services.msc in Run Command prompt and then in Services List look for service with name SQL Server Agent (MSSQLSERVER), right click on it and select start.


    Jehanzeb Javeed

    http://worldofdynamics.blogspot.com
    Linked-In Profile |CodePlex Profile

    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".

    Tuesday, August 9, 2011 9:35 AM
  • Hello Cedric,

    You should log in (or ask person who has an access) to server where SQL server installed and check that SQL Server Agent Service is running. In the case it doesn't you should run it and retry the verification.


    Microsoft CRM Freelancer

    My blog (english)
    Мой блог (русскоязычный)
    Follow Andriy on Twitter
    Tuesday, August 9, 2011 9:36 AM
    Moderator
  • Hi,

    Yes it is running I forgot to write it down in my post. It is running under Network system user. Should it work under CRM domain user or it does not matter. On my Dev platform application and database server are hosted on same virtual machine. I did not have the problem.

    Thanks for your help.

     

    CC

    Tuesday, August 9, 2011 9:44 AM
  • Hi,

    Try restart the Agent Service and also make sure that SQL Server (MSSQLSERVER) is running. If you have multiple SQL instance installed then make sure that the SQL Server Instance Name passing to CRM Setup wizard services are running.


    Jehanzeb Javeed

    http://worldofdynamics.blogspot.com
    Linked-In Profile |CodePlex Profile

    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".
    Tuesday, August 9, 2011 9:53 AM
  • It is unnamed SQL instance is it possible that this is the origin of the problem?

    Thanks,

     

    CC

    Tuesday, August 9, 2011 9:56 AM
  • Hi,

    SQL Server default instance should not be the problem try change the Agent Service login to domain user having local administrative privileges and then start service again.


    Jehanzeb Javeed

    http://worldofdynamics.blogspot.com
    Linked-In Profile |CodePlex Profile

    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".
    Tuesday, August 9, 2011 9:59 AM
  • I did it but it does not help.

    CC

    Tuesday, August 9, 2011 11:52 AM
  • Does the message say that the service is not running, or that setup cannot tell if it is running ? The distinction is important; if it's the latter, then the problem is most likely to be permissions (ACL rather than SQL) related - if possible, make the CRM installation account a member of the local administrators group on the SQL Server for the duration of setup
    Microsoft CRM MVP - http://mscrmuk.blogspot.com  http://www.excitation.co.uk
    • Proposed as answer by Eric Lim L K Sunday, May 18, 2014 3:50 PM
    Tuesday, August 9, 2011 12:53 PM
    Moderator
  • On the logs I got exactly this error message

    15:08:17|   Info| Group Microsoft SQL Server™
    15:09:21|  Error| Check SqlServerAgentValidator : Failure: SQLSERVERAGENT (SQLSERVERAGENT) service is not running on the server

    My domain user is memeber of SQl group and sysdamin as dB role.

     

    Tuesday, August 9, 2011 1:38 PM
  • Hi,

    Make sure that your SQL Server meets the minum CRM 2011 requirements:

    Any one of the following Microsoft SQL Server editions is required and must be installed on a Windows Server 2008 64-bit or later version, running, and available for Microsoft Dynamics CRM:

    · Microsoft SQL Server 2008, Standard Edition, x64 SP1 or later version

    · Microsoft SQL Server 2008, Enterprise Edition, x64 SP1 or later version

    · Microsoft SQL Server 2008 Datacenter x64 SP1 or later version

    · Microsoft SQL Server 2008 Developer x64 SP1 or later version (for non-production environments only)

    Important

    · 32-bit versions of SQL Server 2008 database engine or Reporting Services are not supported for this version of Microsoft Dynamics CRM.

    · Microsoft SQL Server 2008 Workgroup, Web, Compact, or Microsoft SQL Server 2008 Express Edition editions are not supported for running Microsoft Dynamics CRM Server 2011.

    · Microsoft SQL Server 2000 and Microsoft SQL Server 2005 editions and are not supported for this version of Microsoft Dynamics CRM.

    · Running 64-bit SQL Server 2008 versions for Itanium (IA-64) systems in conjunction with Microsoft Dynamics CRM will receive commercially reasonable support. Commercially reasonable support is defined as all reasonable support efforts by Microsoft Customer Service and Support that do not require Microsoft Dynamics CRM code fixes. Microsoft Dynamics CRM Server 2011 supports a named instance of SQL Server for configuration and organization databases.


    Jehanzeb Javeed

    http://worldofdynamics.blogspot.com
    Linked-In Profile |CodePlex Profile

    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".
    Tuesday, August 9, 2011 1:43 PM
  • It is Microsoft SQL Server 2008, Standard Edition, x64 SP1. I really do not understand what happen. I have asked IT operation to look into it normally it should work without any problem.

    Tuesday, August 9, 2011 1:48 PM
  • Hi,

    You may also check System port 445 TCP that is needed to be opened at the firewall from front-end to back-end VLANs. Used "netstat -n" to verify established active connection to SQL instance.


    Jehanzeb Javeed

    http://worldofdynamics.blogspot.com
    Linked-In Profile |CodePlex Profile

    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer".
    Tuesday, August 9, 2011 1:51 PM
  • Dear all,

     

    Thanks for your help. IT operation has to modufy rules on their firewall. Ports were opened on the sever but not on the LAN (firewall).

     

    CC

    Wednesday, August 10, 2011 9:33 AM
  • All - just as an update. I ran into the same error message, even with the firewalls turned off on both web and db servers. The installing user was a SQL admin on the SQL instance, but they were not a local admin on the DB server. Adding the install user as a local admin on the db server fix this problem for me, as suggested by David Jennaway above.

     

    Cheers,

    Paul


    Paul Dowman, CRM Developer
    • Proposed as answer by SaraGoncalves Wednesday, November 23, 2011 4:59 PM
    Friday, September 2, 2011 9:37 PM
  • I also got the same issue. I hv checked, the service was running, still i in installation of crm i was getting the error. Also i checked, the user was local admin. Now i have requested to the Infra team to open up the port in between DB and App server. Hope this sud help me...
    yes.sudhanshu

    http://bproud2banindian.blogspot.com
    http://ms-crm-2011-beta.blogspot.com
    Thursday, December 1, 2011 9:40 AM
  • Spot on. After adding the user account that was logged in to the CRM server during installation, in to the Administrators group of the SQL Database server, the error went away and I was able to continue with the CRM installation. Thanks.

    Warm regards, Eric Lim

    Sunday, May 18, 2014 3:52 PM