Silly sql error question
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)
Comments
That should work. It shouldn't require sa privileges, but usually for a first setup I grant dbo.
Jim Harings
HP Enterprise Services
1st Rule of Connect Club: Mark the post that helped you the most as a 'solution'. 2nd Rule of Connect Club:You must talk about Connect club.
Would you like to reply?
Login or Register to post your comment.