Post reply

Add computer name as a login in sql server

  • December 11, 2010 at 10:49 am

    #244310

    Hi All,

    I have very strange request from my application team and they want to add the server name as a login in sql server.

    Can anybody help with the way to do it.....

    I am able to add the computer name as a member of the local administrators and not able to do the same for the sql server logins....

    Regards

    Nimesh

  • December 12, 2010 at 9:08 am

    #1261427

    You can make use of a script similar to the one below.

    CREATE LOGIN [computername$] FROM WINDOWS;

    Pradeep Adiga
    Blog: sqldbadiaries.com
    Twitter: @pradeepadiga

  • December 12, 2010 at 10:30 pm

    #1261521

    Thanks Very much...

    I also found another way to do this....

    When you create a new login in SQL don't use Browse dialog box to search Active Directory accounts. Instead manually type name in the following format: <Domain Name>\Servername$ and give necessary permission

  • December 14, 2010 at 1:26 am

    #1262068

    The reason your developers want you to do this is most likely because they have a service running on the other machine as Local System (or Network Service) and want it to access the SQL server. Have to wonder why they don't just change the account the service starts as, though--would have been a much better solution, IMHO!

  • December 14, 2010 at 10:20 pm

    #1262620

    Or someone is trying to activly mask the originating accoiunt accessing the SQL server. I'd caution against allowing this type of access.

  • September 3, 2014 at 3:59 am

    #1742709

    Thanks a lot. it helped me very-very)

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply