SQLServer2005SQLAgentUser$ServerName$InstanceName group was missing.

luyan
luyan used Ask the Experts™
on
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?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Author

Commented:
Can I re-create them as the new groups in Window Server Group? Anything special should I add to these groups?
Vitor MontalvãoMSSQL Senior Engineer
Distinguished Expert 2017

Commented:
Those users should be local users in the server.
If you don't have problems till now why you need to recreate them?
Commented:
Yes, you can create those accounts..

For Default Instance, these are the logins will be available.

<ServerName>\SQLServer2005MSFTEUser$<ServerName>$MSSQLSERVER
<ServerName>\SQLServer2005MSSQLUser$<ServerName>$MSSQLSERVER
<ServerName>\SQLServer2005SQLAgentUser$<ServerName>$MSSQLSERVER

Replace <ServerName> with your OS Server Name
Announcing the Winners!

The results are in for the 15th Annual Expert Awards! Congratulations to the winners, and thank you to everyone who participated in the nominations. We are so grateful for the valuable contributions experts make on a daily basis. Click to read more about this year’s recipients!

Author

Commented:
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!

Commented:
Provide SysAdmin access to those logins.

Author

Commented:
Thanks Smuni! I will recreate the groups.

Author

Commented:
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?

Author

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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial