Security

  • 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

  • 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

  • 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.

  • 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