Are members of the servers local admins group by default
members of the sysadmins role'
If so, does a login account still need to be made on the
sql server in order for that user to function properly
within sql?
thanks.Hi,
Yes, But default the BUILDIN\Administrators will be having 'sysadmin' SQL
Serevr server role.
Obviously you can use this accout to access sql server.
Since this user is powerful it is not safe to provide this Login id to
Developers. So is always advisable to create a group specifically meant for
developers with less privileges.
Thanks
Hari
MCDBA
"JRD" <anonymous@.discussions.microsoft.com> wrote in message
news:98ca01c3ea6f$05b73cb0$a601280a@.phx.gbl...
quote:
> Quick question...
> Are members of the servers local admins group by default
> members of the sysadmins role'
> If so, does a login account still need to be made on the
> sql server in order for that user to function properly
> within sql?
> thanks.
No comments:
Post a Comment