Silly sql error question

This issue has been solved. See solution.
syarlett's picture
syarlett
November 23rd, 2008

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)

Filed under: ,
0 votes
jharings's picture
jharings
1 year 2 days ago

Solution

That should work. It shouldn't require sa privileges, but usually for a first setup I grant dbo.

Jim Harings
Technical Solutions Consultant
Xcend Group
http://xcendgroup.com

0 votes
SOLUTION