Post reply

Windows authentication across domains

  • November 12, 2010 at 11:35 am

    #149310

    Hello All

    I have a situation where the SQL 2005 database belongs to one domain and the ASP.Net application servers belong to another domain.

    Is it possible for me to use Windows authentication for SQL without explicitly setting up full trust between the 2 domains?

    Thanks in advance for your response.

    Regards

    Anish

  • November 12, 2010 at 12:20 pm

    #1250197

    create a username in both domain with same name and password. I have tested for a workgroup and domain...

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

  • November 12, 2010 at 12:32 pm

    #1250206

    SQLFrenzy

    That did not work!

    Regards

    Anish

  • November 12, 2010 at 12:43 pm

    #1250211

    Create user in windows server(os user) in both with same name and password.

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

  • November 12, 2010 at 12:49 pm

    #1250216

    what exactly you did??Did you tried to login into the other server with the username you created.

    Regards,
    [font="Verdana"]Sqlfrenzy[/font]

  • November 12, 2010 at 2:28 pm

    #1250261

    Hi! Pavan

    This solution worked....thank you very much!

    Anish

  • November 12, 2010 at 2:29 pm

    #1250262

    You are welcome from SSC

    Regards,

    Pavan Srirangam

    [font="Tahoma"]
    --SQLFRNDZ[/url]
    [/font]

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

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