SQL Server 2005 security issue is related to logins

• Saggy

  SSCrazy

  Points: 2003

  More actions

  August 13, 2013 at 2:45 pm

  #395297

  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

• durai nagarajan

  SSCoach

  Points: 15778

  More actions

  August 14, 2013 at 12:02 am

  #1641216

  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