LAE

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

Originally posted by: dwong80

I'm using BRAIN 4.1.6 trying to connect to an MS SQL database.

I'm running the graph locally. So I downloaded the sqljdbc4.jar file and placed it into the /java/ext directory. I'm using the following connection strings:

• User: quotausr
• Pass: <some password>
• dbURL: jdbc:sqlserver://TJMSPAPP047
• Driver: com.microsoft.sqlserver.jdbc.SQLServerDriver

However the error message I get is:

"unable to connect: Login failed for user 'quotausr'."; File: "DBNode.java"; Line: 78; Context: "connectToDB"

The username and password are correct as I can setup an ODBC connection via Windows XP Admin Console.

The only difference I can see is on the ODBC settings, I use the following SQL Server name: TJMSPAPP047\VGNSOURCE

Do I need to include the VGNSOURCE part of the SQL Server Name into the DbURL? If so, do you know how the string would look afterward? I tried the following:

jdbc:sqlserver://TJMSPAPP047\VGNSOURCE . But this appears to be invalid.
jdbc:sqlserver://TJMSPAPP047\VGNSOURCE:1433 -- This one gives the same error message

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

Originally posted by: timonk

Darren,

In other graphs I use with JDBC query nodes, the DbURL has the following type of value:

jdbc:sqlserver://<Ip address>:1433;databaseName=Helpdesk7;

Yours ; jdbc:sqlserver://TJMSPAPP047\VGNSOURCE:1433 , looks like it is missing the "databaseName=" value. Can you try adding that in?

Regards,
Timon Koufopoulos
MDA Support.