locked
Add computer to security users RRS feed

  • Question

  • How it is possible to grant the rights to the participant security (computer) on instance SQL Server 2008? I can add only users, but not computers.
    Thursday, May 20, 2010 9:18 AM

Answers

  • Hi,

    you can use this SQL code to create login from a computer:

    CREATE LOGIN [domain\computername$] FROM WINDOWS

    I hope it helps.

    J.


    There are 10 type of people. Who knows binary and who does not.
    Thursday, May 20, 2010 9:42 AM
  • open ssms> security > right click on login > create new login > select desired server role

    or

    CREATE

     

    LOGIN [sekhar] FROM WINDOWS WITH DEFAULT_DATABASE=[master]

    go

    EXEC

     

    master..sp_addsrvrolemember @loginame = N'sekhar', @rolename = N'sysadmin'

    GO

    Thursday, May 20, 2010 11:42 AM

All replies

  • Hi,

    you can use this SQL code to create login from a computer:

    CREATE LOGIN [domain\computername$] FROM WINDOWS

    I hope it helps.

    J.


    There are 10 type of people. Who knows binary and who does not.
    Thursday, May 20, 2010 9:42 AM
  • open ssms> security > right click on login > create new login > select desired server role

    or

    CREATE

     

    LOGIN [sekhar] FROM WINDOWS WITH DEFAULT_DATABASE=[master]

    go

    EXEC

     

    master..sp_addsrvrolemember @loginame = N'sekhar', @rolename = N'sysadmin'

    GO

    Thursday, May 20, 2010 11:42 AM