Cannot create an account in my SQL

  • I have a sql server 2008R2 in domain A, I have a domain trust (full forest trust) between domain A & B, can create users of Domain A no problem, but get the error while adding domain B,

    Error is as,

    Windows NT user or group not found. Check the name again. (Microsoft Server, Error: 15401)

  • It looks like the trust relationship is not fully propagated or does not exist both ways.

    Try setting an explicit trust where Domain A trusts Domain B.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Trust is fine, I tested that

  • Is the SQL Service account a domain account? If so, which domain?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • yes it is domain A

  • Can you add logins from Domain A to Domain B in SQL Server?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

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

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