Altiris Deployment Server and Database issue

I have an issue where we have setup an Altiris deployment server, anyone in local admins can access the Altiris console with no issues, as they have sysadmin provileges within SQL to the express database.
But a separate group of non admin users that I have given the public role within the DB keep getting prompted to enter credentials when launching the console.
The logs within SQL produce the following error:

Login failed for user "CURRA\XXXXXX".CLIENT 10.1.1.1
Error 18456. Severity 14 State 16

If I give the group the sysadmin rights, they can login without issue and the deployment
server works as it should.

The server is a Windows 2003 box with SQL2005.
The version of Altiris RDP is 6.8 SP2
LVL 6
rimmenaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
>> Error 18456. Severity 14 State 16

Your error state mentions that Default Database is missing for this login:

http://blogs.msdn.com/chrissk/archive/2008/12/02/troubleshooting-error-18452-login-failed-for-user.aspx

Run this from some other high privileged login:

ALTER LOGIN [CURRA\XXXXXX] WITH DEFAULT_DATABASE = master
0
rimmenaAuthor Commented:
Tried that and still get the same issue.
0
Raja Jegan RSQL Server DBA & Architect, EE Solution GuideCommented:
>> But a separate group of non admin users that I have given the public role within the DB

Grant CONNECT privilege to your database and then try it out..
If not, then create a new login with db_owner privilege and try which should work.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rimmenaAuthor Commented:
This helped, but looks like the group does require the sysadmin role.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Software

From novice to tech pro — start learning today.