Deployment Solution

I have two servers. One of them is running the Altiris Deployment Server and a Console. We will call it server A
The other server is just running a console, we will call it server B.

I have two groups of users I want to have access to the deployment console:
The first group has full control to both servers and do anything in the console.
The second group has full control to only server B and is only allowed to use the remote control and run specified jobs in the console.

The problem is that when the users in the second group try to start the console from server B, it gives the following error:
The console was not able to connect to the site you selected. Enter a user name and password to connect to the site or select cancel to select another site.
And prompts for a Username and password.

If I put the users in the second tier in the local administrators group for server A, then they can open the console from server B with no problem. While they're in the console, all the permissions and rights I've set for them work perfectly. The only problem with this is that I do not want these users to have administrative rights to server A.

Adding the users to Power Users of Server A did not work.
Giving the users full control of the entire C: drive on Server A did not work.
Giving the users rights in SQL Enteprise Manager to the "Express" database did not work.

I called tech support and they suggested that I upgrade from 6.8 SP1 to 6.8 SP2. This did not solve the problem.

Basically, all I want to know is - of the rights granted by having administrative rights to Server A, which ones are nessicary to start the console from server B?

You need to give the users rights to access the DB 'express' in the SQL server. Also check the box for the 'public' role on 'express'.This is done under security>logins in the SQL management tool. I see you have done that but I would investigate that further. They may be missing the role or something simple.

By default you probably have access granted for BUILTIN\Administrators so when you give them local admin rights they hit that account. Instead add each of their windows accounts with grant acccess to the db I mentioned above. This does not sound like a file based permission issue at all.

Brandon is right.  I just had this same problem yesterday and after playing around with the Logins and the Security folders in MS SQL 2005 I was able to access the
First I had to create the user Logins, then give them the appropriate Server Roles, and then go to the eXpress database and grant the user the appropriate permissions on the database. 

I just used the Public and Sysadmin roles since trust the users.  After that they were able to open the Deployment Console on their desktop.

@cosborne:

You do realize you resurrected a thread that was more than a year old right?

Delayed feedback is better than no feedback