Post reply

linked server

  • November 4, 2009 at 10:21 am

    #211780

    How can we map SQL group login to SQL Login in Linked server?

    i tried it gave me error?

    that login name is invalid or you do not have permission while i am SYSadmin on both server

  • November 4, 2009 at 10:34 am

    #1074921

    How was it mapped?

    CEWII

  • November 4, 2009 at 10:49 am

    #1074927

    when i am trying to map login . i am getting thats kind of error. login i am trying to map is group login of AD. and it is created on SQl server

  • November 4, 2009 at 12:11 pm

    #1074980

    Hi,

    You can't map a group login in any linked server.

    Regards.

    José Santiago Oyervides.

  • November 4, 2009 at 7:23 pm

    #1075110

    Ah yes, I agree, that is not going to work..

    You'll have do to more user based mapping..

    CEWII

  • November 5, 2009 at 12:43 am

    #1075194

    create dedicated logins to be used for linked server configuration. Use that logins to map sql user logins and it will work fine.

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

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