Results 1 to 11 of 11

Thread: Authentication

  1. #1
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Red face Unanswered: Authentication

    I have 2 instance on SQL Server, One remote the other local. Both authenticate via window NT.
    How can I change one or both?
    To connect to a application do I setup a usergroup? Grranted this is still in the testing stages.

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Quote Originally Posted by garrydawkins
    How can I change one or both?

    Huh? (Was not a long enough message....)

    If they want to parse something, they should parse the questions...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Red face Authentication

    1. How can I change one or both for authenicating throw SQL Server & Windows. From the application standpoint eash database within the instance could have restricted access.

    2. Most user will only have access to the data via there particular application that interfaces with the dataBASE. Would you say this would fall under the category of Usergroup Brett. Where your buddy, who always has great instinct and insigght.

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I'm sorry...

    Are you saying 1 Application is connecting to multiple databases?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Unhappy Authentication

    No, application Users should have access through authentication of Windows NT. If it's a outside user(offsite) and I want to make fo-sure he is allowed to have access. How would that be done.

  6. #6
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    Are you planning to change server authentication mode from Windows Only to Mixed through FE code?
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  7. #7
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Angry Authentication

    Yes, that sound like what I'm looking for. What is FE Mode?

  8. #8
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    FE Mode? It's front-end code


    Authentication mode is not a dynamic property. And I don't think that "messing" with server security is a proper role for an application. Any thoughts?
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  9. #9
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,799
    Provided Answers: 11
    The connection string you use will determine how you authenticate to the SQL Server. If you specify a User ID and a Password, then you will be authenticated based on the SQL Login. If you supply Integrated Security=SSPI, then you get windows authentication. Windows authentication is preferred, in case you try to put both in.

    From this, you could try to modify the connection logic of the application to chose a connection string on startup. Or are the people in fixed locations just on different sides of the firewall?

  10. #10
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Wink Authentication

    Mixed authentication. Different sides of the firewall using VMware product as the base repository. It come down to setting up the agent on the user site with the proper setting. After all they dont have access through EM, Just there application.

    Thanks

  11. #11
    Join Date
    Apr 2003
    Location
    Washington DC area
    Posts
    1,770

    Cool Found it

    It's in the profile Check out the attachments
    Attached Files Attached Files

Posting Permissions

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