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:45 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 #1483976
Posted Wednesday, August 14, 2013 12:02 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, May 30, 2014 8:15 AM
Points: 1,056, Visits: 2,687
the code will work and

yes a group has to be created as a login and then necessary role has to be provided hope these are basic.



Regards
Durai Nagarajan
Post #1484081
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse