Create Login getting Windows NT user or group not found.

  • I'm unfamiliar with creating Logins and Im trying to run the following query

    CREATE LOGIN [CORP\NCG_009SOCSB_DBO_AP] FROM WINDOWS WITH DEFAULT_DATABASE = [db009];

    But I get the following error:

    Msg 15401, Level 16, State 1, Line 1

    Windows NT user or group 'CORP\NCG_009SOCSB_DBO_AP' not found. Check the name again.

    Can someone help me understand what the problem is?

  • Does the user NCG_009SOCSB_DBO_AP exist in the CORP domain?

  • Hmm, more than likely not. How do I find out? Im thinking thats not something I can add through TSQL?

  • It would be a regular windows user account, that is part of an Active Directory domain. How do you log into your machine (not SQL\SSMS)?

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

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