InfoSphere Optim

 View Only
Expand all | Collapse all

How can i create a SQL Server data store alias with NTLM authentication?

  • 1.  How can i create a SQL Server data store alias with NTLM authentication?

    Posted Thu May 02, 2024 03:00 AM
    Edited by Anthony García Thu May 02, 2024 03:02 AM

    Hello everyone,

    I'm trying to create a SQL Server data store Alias in Optim Designer. Apparently, the database uses NTLM authentication.

    By default, Optim uses system DSNs, but since it's NTLM, I need to start the application with the user I'm going to connect to the database, which is not possible.

    I added a connection URL:

    jdbc:sqlserver://HOST:1433;databaseName=db;Encrypt=false;integratedSecurity=true;authenticationScheme=NTLM;user=optimuser;password=password;

    This URL works if I execute it directly with the JDBC libraries, but in Optim Designer, I get the error "The authenticationScheme NTLM is not valid."

    Has anyone made a similar connection?

    I would appreciate your help,

    Thank you



    ------------------------------
    Anthony García
    ------------------------------



  • 2.  RE: How can i create a SQL Server data store alias with NTLM authentication?

    Posted Thu May 02, 2024 07:50 PM

    Hello,

    I solved the error. If anyone else encounters the same issue, they should add the JDBC in the driver definitions within the preferences of Optim Designer. With that, the connection works.

    Right now, I'm facing another issue. When I finish configuring the data store alias, I get the following error: "Optim Configuration could not create the DB Alias. Please edit the DB Alias information and try again." Does anyone know how to resolve this?



    ------------------------------
    Anthony García
    ------------------------------

    Original Message