cancel
Showing results for 
Search instead for 
Did you mean: 

sql exception: not associated with a trusted SQL Server connection

Former Member
0 Kudos

Hi,

Scenario: File to JDBC

DB Server: MS SQL 2005 Server.

Scenario successful in MONI. But I am getting error in Adapter Monitoring.

I tried with/without user, but i am getting same error.

We have installed requried Drivers(which works fine for other scenarios involving MS SQL 2003 server).

Error during database connection to the database URL 'jdbc:microsoft:sqlserver://10.10.102.156:1433;DatabaseName=DISA_XI' using the JDBC driver 'com.microsoft.jdbc.sqlserver.SQLServerDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:microsoft:sqlserver://10.10.102.156:1433;DatabaseName=DISA_XI': SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Login failed for user ''. The user is not associated with a trusted SQL Server connection.'

Accepted Solutions (0)

Answers (1)

Answers (1)

JaganMohan
Participant
0 Kudos

Dear Mani,

Just check your driver parameters are correct for the SQL server with use of the following link.

http://www.devx.com/tips/tip/28818

Regards,

Jagan.