Privacy guaranteed - Your email is not shared with anyone.

Welcome to Glock Forum at

Why should YOU join our forums?

  • Reason #1
  • Reason #2
  • Reason #3

Site Description

SQL Server Security Question

Discussion in 'Tech Talk' started by N2DFire, Jan 31, 2005.

  1. N2DFire

    N2DFire Who Me ???

    Apr 29, 2003
    Ferrum, VA
    I have better luck getting answers here than most all of the Tech. specific forums I visit, so here goes nuttin.

    VB.NET program connecting to SQL Server via SSPI (NT Security).

    1 All users must be on a "secure" subnet to be able to access the Server through the firewall.
    2 SQL Server is using security account info. from domain SE
    3 There can be NO (Zero, zip, zilch, nada) Trust relationships to other domains
    4 Cannot use SQL Built in accounts

    The Scenario:
    99% of all person using application X will be logged on to the SE domain. Their account info. will be passed by the application via SQL connection to the SQL server which will then validate if they are allowed to access the data.

    1% may be logged on to other domains or even the local machine (these users DO have accounts on the SE domain).

    I can trap the error for bad credentials but I have no clue how to go back and allow that 1% to enter their SE credentials and pass them to the SQL server.

    Anyone with thoughts on how to do this feel free to chip in.

    I have already tried combining the 2 methods (didn't work)
    "Integrated Security=SSPI;Persist Security Info=False;Data Source=MyServer;Initial Catalog=MyData;User ID=SE\Fred;Password=Dorfman"
  2. NetNinja

    NetNinja Always Faithful

    Oct 23, 2001
    HotLanta, GA

    Sign up for a free account and assign 100 points to your question.

    I don't know a thing about SQL. ;)

  3. Clyde

    Clyde Lost in KY Millennium Member

    Jan 28, 1999
  4. N2DFire

    N2DFire Who Me ???

    Apr 29, 2003
    Ferrum, VA
    Problem solved - thanks for the input guys.
    And for any SQL folks looking over this - look at impersonation *wink*