LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: mw9286

Running BRE 5.0.0.1 Enterprise Version

Connecting to SQL Server 2008 SR2

Currently use Windows Authentication when connecting via Teradata SQL Assistant

What should my password, DbUrl & DBDriver be set to use Lavastorm BRE to connect?

Thank you

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: prashanth

Hi,

If you mean you are using the LAE client with one of the JDBC Query nodes to connect to sqlserver, the DbUrl should be of the format: jdbc:sqlserver://your_sql_server_name

and DbDriver should be: com.microsoft.sqlserver.jdbc.SQLServerDriver as a default if the driver is available. The password is the database username's password.



-Prashanth

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Mckaya

Just new to this Thread but am experiencing the same issue.

Standard JDBC node to SQLserver -

DbUrl jdbc:sqlserver://{ServerName};1433;databaseName={DatabaseName}
DbDriver com.microsoft.sqlserver.jdbc.SQLServerDriver

I have even tried to manually turn off Integrated Auth with..
jdbc:sqlserver://{ServerName};databaseName={DatabaseName},integrate dSecurity=false;

Still No Joy!

Cheers,

Mac

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

Which error message are you getting?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: william.murphy

hi all,
i'm also having issues connecting to a MS SQL database. The error is get is ERROR: failed to connect:login failed for user 'username'

i've been using connection details as found all over various threads in the forum without any luck so far, including the above settings

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: mgajdosik

Try to pass in username and password within DbUrl, something like jdbc:sqlserver://localhost;user=MyUserName;password=*****;

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: william.murphy

sure, i've tried that too but get the same error. if i try to leave the username and pw field blank then the node doesnt run