October 25, 2002 at 8:37 am
Are there any issues if you remove builtin/administrator from sql server logins? We have builtadmin as sysadmin for sqlserver and I want to remove this. The account that strats SQL server is seperate though. What rights does this accounts need to have in order for it to start SQL server?
Thanks.
October 25, 2002 at 9:31 am
Check Microsoft KB Q263712.
November 1, 2002 at 3:01 pm
You can remove it but you will probably want to add another nt group that are you sql server admins. (especially if you forget the sa password, if using mixed security)
Simon Sabin
Co-author of SQL Server 2000 XML Distilled
http://www.amazon.co.uk/exec/obidos/ASIN/1904347088
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
November 1, 2002 at 3:30 pm
Here are the requirements for the various services should you choose to use non-administrator level accounts for them:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/instsql/in_overview_6k1f.asp
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
http://www.netimpress.com/shop/product.asp?ProductID=NI-SQL1
K. Brian Kelley
@kbriankelley
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply