Home Forums SQL Server 2005 Administering SQLSERVERAGENT service on Local Computer started and then stopped RE: SQLSERVERAGENT service on Local Computer started and then stopped

  • November 24, 2010 at 7:12 am

    #1255078

    We had same issue on a sql 2008 Sp1 box.

    The Analysis Service was pointing to folder "d:\program files\microsoft sql server\msas10.mssqlserver\olap\config" for the msmdsrv.ini file. However the config folder was at location D:\Program Files\Microsoft SQL Server\MSSQL.2\OLAP\Config, copying back to the original location fixed the issue.

    Binu