[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 915
  • Last Modified:

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
0
rimmena
Asked:
rimmena
  • 2
  • 2
1 Solution
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
>> 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 & ArchitectCommented:
>> 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
 
rimmenaAuthor Commented:
This helped, but looks like the group does require the sysadmin role.
0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now