May 13, 2009 at 2:46 am
Service account should be set up as a separate login. I think SQL Server creates that user and sets up the rights if you use the SQL Configuration manager to set it up. So it should not be a problem. But double check if the individual user is there in the login and is a SysAdmin.
-Roy
May 13, 2009 at 2:51 am
Hi Roy,
Thanks for reply,
All the users are in os administrator's group, if I remove sysadmin role to BUILTIN\Administrators group all the users will loss the
Sysadmin role in windows authentication. So, How can I create new login with sysadmin role?
Can I Create New group in OS (Operating system) and send those (who need administration roles) users and gave the permissions?
Lee
May 13, 2009 at 5:18 am
Lee From Bangalore (5/13/2009)
Hi Roy,Thanks for reply,
All the users are in os administrator's group, if I remove sysadmin role to BUILTIN\Administrators group all the users will loss the
Sysadmin role in windows authentication. So, How can I create new login with sysadmin role?
Can I Create New group in OS (Operating system) and send those (who need administration roles) users and gave the permissions?
Lee
If you want to give someone sysadmin in SQL, go to their login in SQL server and under server roles give them sysadmin.
If you want, you could have an active directory group created, put some people in there, make that group a login in SQL server and give it sysadmin.
Or create a local windows group, add some users, make that group a SQL login and give it sysadmin.
May 13, 2009 at 11:27 pm
Hi,
In Sql server Can I able to remove 'Sysadmin' role (Windows authenticated) with out remove 'Sysadmin' role in 'BUILTIN\Administrators' group?
Regards,
Lee
Viewing 4 posts - 16 through 18 (of 18 total)
You must be logged in to reply to this topic. Login to reply