asked on

SQLServer2005SQLAgentUser$ServerName$InstanceName group was missing.

When I install a new SQL Server 2005, I will see the following two groups in Window Server Group.
- SQLServer2005MSSQLUser$ServerName$InstanceName
- SQLServer2005SQLAgentUser$ServerName$InstanceName

When I checked one existing SQL 2005, there are no these two groups in Window Server Group. Why? Is someone delete them by mistake? How to create them in Window Server Group?

luyan

ASKER

Can I re-create them as the new groups in Window Server Group? Anything special should I add to these groups?

Vitor Montalvão

Those users should be local users in the server.
If you don't have problems till now why you need to recreate them?

ASKER CERTIFIED SOLUTION

smuni

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

luyan

ASKER

Thanks Smuni!
Yes, I could recreate those group in Window Server. The group should have the required access and privileges.
Recently I set up log shipping and need to grant some user in group SQLServer2005SQLAgentUser$<ServerName>$MSSQLSERVER. So I would like to know what kind permission those groups should have.
Thanks!

smuni

Provide SysAdmin access to those logins.

luyan

ASKER

Thanks Smuni! I will recreate the groups.

luyan

ASKER

The group SQLServer2005SQLAgentUser$<ServerName>$MSSQLSERVER
was created. But when I tried to add it to SQL Server as a login, I got the error message - Windows NT user or group 'SQLServer2005SQLAgentUser$<ServerName>$MSSQLSERVER' not found.
Anything wrong?

luyan

ASKER

It works now - create the login by command line not by GUI.
Thanks!