#3 NT Authentication with Oracle returns error

closed
None
5
2005-07-04
2005-07-04
Sean Flook
No

I am trying to use NT Authentication with Oracle. I have
Oracel setup to use NT Authentication and it works fine
with SQLPlus. The problem is that when trying to use
mimer I get the following message:

ORA-1017:invalid username/password; logon denied

Discussion

  • Bengt Gunne

    Bengt Gunne - 2005-07-04

    Logged In: YES
    user_id=895705

    What connection string are you using with your
    MpmConnection?

    Check also what connection string is passed to the
    underlying OracleConnection. Use NativeConnection property
    of the MpmConnection object.

     
  • Sean Flook

    Sean Flook - 2005-07-04

    Logged In: YES
    user_id=684148

    I am getting this error from within the Admin application.

    These are the settings I am using
    Data Source Name = TEST
    Plugin name = Oracle9
    SQL Filter List = ParametersMarkers
    DBMS type name = Oracle
    DataSource = SYMPHONY_HOLLY

    I am not providing any user name or password. As previously
    stated if I type the following from a command prompt I can
    logon to Oracle

    sqlplus /@symphony_holly

    Regards
    Sean

     
  • Bengt Gunne

    Bengt Gunne - 2005-07-04

    Logged In: YES
    user_id=895705

    The question is how you connect with Oracle's ADO.NET
    provider without supplying a username/password. In other
    providers, such as Mimer SQL and SQL Server, there is an
    IntegratedSecurity option that is used to tell the system to
    use NT Authentication. Oracle does not provide this option.
    The Mimer Provider Manager expose all options supported by
    the Oracle provider so as long as it is supported by the
    Oracle Data Provider you should be able to do it through
    Mpm too!

     
  • Bengt Gunne

    Bengt Gunne - 2005-07-04

    Logged In: YES
    user_id=895705

    Try setting User Id to /

     
  • Sean Flook

    Sean Flook - 2005-07-04

    Logged In: YES
    user_id=684148

    That works great!

    Thanks a lot.

    Sean

     
  • Bengt Gunne

    Bengt Gunne - 2005-07-04
    • assigned_to: nobody --> mimerbg
    • status: open --> closed
     

Log in to post a comment.

Get latest updates about Open Source Projects, Conferences and News.

Sign up for the SourceForge newsletter:

JavaScript is required for this form.





No, thanks