Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server 2005 security issue is related to logins Expand / Collapse
Author
Message
Posted Tuesday, August 13, 2013 2:17 PM


Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, April 21, 2014 12:41 PM
Points: 65, Visits: 234
Will the below code run in sql server 2005 and 2008 ?

Issue with SQL Server 2008, and future products is known. The fix is to run:

CREATE LOGIN [BUILTIN\Administrators] FROM WINDOWS
go
sp_addsrvrolemember
@LogiName=''BUILTIN\Administrators'',
@RoleName=''sysadmin''
The important point being that cannot add a "group" to a server role directly. You have to add a "login" for that "group". Then you can add that "login":


thnx....reply
Post #1483955
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse