September 23, 2019 at 8:57 pm
Just inherited a bunch of 2008 r2 servers. Trying to resharpen those skills, I thought starting with 2008r2 being admin on the server did not by default give you sysadmin rights on sql, didn't that end with 2005?
September 23, 2019 at 9:02 pm
That stopped with SQL 2005. More precisely, SQL 2008 was the first version where BUILTIN\ADMINISTRATORS were not added by default.
[font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]
September 23, 2019 at 9:17 pm
It is possible the database was upgraded to 2008 R2 from an older version that did already have BUILTIN\Administrators as a login. I don't think there is anything in the upgrade that would prevent that existing login from working.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply