Results 1 to 6 of 6
  1. #1
    Join Date
    Jun 2005
    Location
    Denver, CO
    Posts
    100

    Unanswered: Specify Alternate Windows Login Credentials

    Is it possible for me to login using windows login information that is separate from my current windows login? That is to say, can I login to a SQL server using windows athentication but actually specify the login and domain information? I woul like to login to a SQL server from a computer that is not part of the domain using my windows credentials and not a SQL user name.
    BillS

  2. #2
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    yes, if you use runas when opening SSMS.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  3. #3
    Join Date
    Jun 2005
    Location
    Denver, CO
    Posts
    100
    That doesn't seem to work. I'm running:
    Code:
    runas /user:myusername@domain.local "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe"
    and since my computer is not on the domain it can't find the domain controller.
    BillS

  4. #4
    Join Date
    Aug 2005
    Posts
    75
    To my knowledge, domain membership is required for authentication of a Domain acct with SQL Mgmt Studio.

    I currently have a shortcut set up on my local desktop to run as an alternate user - this is the target string:
    Code:
    C:\WINDOWS\system32\runas.exe /user:domain\user "C:\Program Files\Microsoft SQL Server\90\Tools\Binn\VSShell\Common7\IDE\SqlWb.exe"

  5. #5
    Join Date
    Jun 2005
    Location
    Denver, CO
    Posts
    100
    That's basically the same string. So it looks like my only option is SQL auth. Thanks.
    BillS

  6. #6
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I see a couple of choices.

    You can VPN into the domain, and implicitly join the domain that way.

    The domain administrators can create a trust relationship between the domains.

    Although it won't let you run applications, you can build an ODBC connection string that includes the Windows Authenticated connection information which will at least allow data to pass.

    -PatP

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •