Home Forums SQL Server 7,2000 Security local login to remote server mapping issues RE: local login to remote server mapping issues

  • yep, i'm confirming the same thing you are seeing,

    i cannot map a domain group to a remote login, even if i know it exists as a login on the server.

    i think you'll end up having to iterate thru the current members with xp_logininfo , and script out the grants for them them individually.

    EXEC master..xp_logininfo @acctname = 'disney\dev',@option = 'members' -- show group members

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!