Symantec Management Platform (Notification Server)

 View Only

  • 1.  Silly sql error question

    Posted Nov 23, 2008 06:31 AM
    Hey,

    Aplogies but this is prob a dumb question....this error we getting int he logviewer....is it as simple as making sure the login account password in sql enterprise manager is the same as the user account in Recovery Solution General page?



    Log File Name: C:\Program Files\Altiris\Notification Server\Logs\a.log
    Priority: 2
    Date: 11/23/2008 7:25:01 PM
    Tick Count: 1839765
    Host Name: MBK1-AL01
    Process: aexsvc.exe (1260)
    Thread ID: 5404
    Module: AltirisNativeHelper.dll
    Source: Altiris.RecoverySolution.Utils.ProcessException
    Description: Exception in function Altiris.RecoverySolution.Policies.PatchIntegrationPolicy.PropagateClientsCriticalDates: System.Data.SqlClient.SqlException: Cannot open user default database. Login failed.
    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
    at Altiris.RecoverySolution.Policies.PatchIntegrationPolicy.PropagateClientsCriticalDates(ClusterItem oClusterItem)


  • 2.  RE: Silly sql error question
    Best Answer

    Posted Nov 23, 2008 12:19 PM
    That should work. It shouldn't require sa privileges, but usually for a first setup I grant dbo.