none
how to create a windows login who is not in a domian RRS feed

  • General discussion

  • Hi experts i am looking for a suggestion on how to create a Windows login and then grant access to SQL Server who is not in our XYZ domain, he is a consultant, and we are obligated to create sql logins.

    Thanks,

    Wednesday, June 21, 2017 2:48 PM

All replies

  • Connect to the SQL Server machine - ie using RDP.

    Create a local user account using Computer Management.

    If the machine name is SQLServerDEV you would add his login as

    SQLServerDEV\HisName

    ie

    CREATE LOGIN [SQLServerDEV\HisName] FROM WINDOWS WITH DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english]


    As long as his password he uses to logon to his desktop/laptop, matches the password you enter on the SQL Server machine, he should be able to logon.
    Wednesday, June 21, 2017 2:52 PM