Post reply

Creating an orphaned user

  • January 12, 2011 at 9:19 am

    #388618

    Ok, I appreciate that this is an odd request and most posts on the subject are how to resolve orphaned users, however, bear with me......

    For security reasons some of our SQL Servers sit on different domains, however, a requirement has arisen to log ship a database from a server on one domain to a server on a different domain, to be used for reporting.

    I was hoping to be able to create an orphaned user account on the primary server, which would then replicate across to the secondary server to allow connection to be made for the reports to use, but this doesn't seem plausible as SQL Server doesn't allow the user to be created without a corresponding windows user/group.

    Is there any 'trickery' that can get around this?

    Any help greatly appreciated.

  • January 12, 2011 at 10:19 am

    #1272478

    If it's a sql login, script out the login from the secondary server, and apply it to the primary. Then build your user, and delete the login from the primary.

    It it's a windows domain login, I don't know if this is possible.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

  • January 12, 2011 at 3:31 pm

    #1272685

    It is a Windows domain login.

  • January 16, 2011 at 8:26 am

    #1273981

    skosk (1/12/2011)

    It is a Windows domain login.

    there would need to be a trust relationship between the Forests\Domains

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 4 posts - 1 through 3 (of 3 total)

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