Solution to non-domain Windows Authentication-VBForums
Results 1 to 17 of 17

Thread: Solution to non-domain Windows Authentication

Hybrid View

  1. #1

    Thread Starter
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    CT
    Posts
    15,907

    Exclamation Solution to non-domain Windows Authentication

    If any of you have ever tried to access a SQL box on a network, from a laptop for instance, that is not part of the domain.

    You will remember getting an error:

    Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection
    This problem also happens when you VPN connect to an outside network - and attempt access to the remote network through the VPN.

    You can get around this error, on WINDOWS XP PROFESSIONAL machines by:

    START>CONTROL PANEL>USER ACCOUNTS

    ADVANCED TAB...MANAGE PASSWORDS...

    Click Add and then load the SERVER NAME of the SQL BOX on the other network and the WINDOWS AUTHENTICATION username and password that would give you authentication on that network!

    From that point on you have credentials to access that server without actually logging in to that domain.

    I was very impressed!
    Last edited by szlamany; Oct 14th, 2005 at 02:07 PM.

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:
    [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008

  2. #2
    Super Moderator Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,335

    Re: Solution to non-domain Windows Authentication

    You should send a PM to si_the_geek and ask him to make this a part of the Tutorials And Tips sticky thread at the top of the forum.

    This isn't something that should get lost in the thread shuffle.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    When you have received an answer to your question, please mark it as resolved using the Thread Tools menu.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    I dont answer coding questions via PM or EMail. Please post a thread in the appropriate forum section.

    Creating A Wizard In VB.NET
    Paging A Recordset
    What is wrong with using On Error Resume Next
    Good Article: Language Enhancements In Visual Basic 2010
    Upgrading VB6 Code To VB.NET
    Microsoft MVP 2005/2006/2007/2008/2009/2010/2011/2012/Defrocked

  3. #3
    Software Carpenter dee-u's Avatar
    Join Date
    Feb 2005
    Location
    Candon City, Ilocos Sur, Phils.
    Posts
    10,829

    Re: Solution to non-domain Windows Authentication

    Thanks a lot for sharing...
    Regards,


    As a gesture of gratitude please consider rating helpful posts. c",)

    Some stuffs: Mouse Hotkey | Compress file using SQL Server! | WPF - Rounded Combobox | WPF - Notify Icon and Balloon | NetVerser - a WPF chatting system

  4. #4
    Fanatic Member
    Join Date
    Sep 2004
    Location
    Jakarta, Indonesia
    Posts
    818

    Re: Solution to non-domain Windows Authentication

    sorry..where did i get Advanced Tab?
    Attached Images Attached Images  

    1st NF - a table should not contain repeating groups.
    2nd NF - any fields that do not depend fully on the primary key should be moved to another table.
    3rd NF - there should be no dependency between non key fields in same table.
    - E. Petroutsos -


    eRiCk

    A collection of "Laku-abis" Ebook, Permanent Residence

    Access Reserved Words, a Classic Form Bug, Access Limitation, Know run Process and the Lock they hold in, Logging User Activity in MSSQL,
    Kill Database Processes

  5. #5

    Thread Starter
    MS SQL Powerposter szlamany's Avatar
    Join Date
    Mar 2004
    Location
    CT
    Posts
    15,907

    Re: Solution to non-domain Windows Authentication

    Quote Originally Posted by erickwidya
    sorry..where did i get Advanced Tab?
    Is that PC currently in a domain, or simply a workgroup? You can find that out by right-clicking on MY COMPUTER and going to the COMPUTER NAME tab. Does it list a DOMAIN there?

    Did you switch to classic view in the CONTROL PANEL? You do have XP PROFESSIONAL - right?

    *** Read the sticky in the DB forum about how to get your question answered quickly!! ***

    Please remember to rate posts! Rate any post you find helpful - even in old threads! Use the link to the left - "Rate this Post".

    Some Informative Links:
    [ SQL Rules to Live By ] [ Reserved SQL keywords ] [ When to use INDEX HINTS! ] [ Passing Multi-item Parameters to STORED PROCEDURES ]
    [ Solution to non-domain Windows Authentication ] [ Crazy things we do to shrink log files ] [ SQL 2005 Features ] [ Loading Pictures from DB ]

    MS MVP 2006, 2007, 2008

  6. #6
    Fanatic Member
    Join Date
    Sep 2004
    Location
    Jakarta, Indonesia
    Posts
    818

    Re: Solution to non-domain Windows Authentication

    s that PC currently in a domain, or simply a workgroup? You can find that out by right-clicking on MY COMPUTER and going to the COMPUTER NAME tab. Does it list a DOMAIN there?

    Did you switch to classic view in the CONTROL PANEL? You do have XP PROFESSIONAL - right?
    yes..i have XP Proffesional SP1..the PC is in Workgroup not using domain..

    i think i switched it to Classic but can't find to restore it

    1st NF - a table should not contain repeating groups.
    2nd NF - any fields that do not depend fully on the primary key should be moved to another table.
    3rd NF - there should be no dependency between non key fields in same table.
    - E. Petroutsos -


    eRiCk

    A collection of "Laku-abis" Ebook, Permanent Residence

    Access Reserved Words, a Classic Form Bug, Access Limitation, Know run Process and the Lock they hold in, Logging User Activity in MSSQL,
    Kill Database Processes

Posting Permissions

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



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.