cancel
Showing results for 
Search instead for 
Did you mean: 

MS SQL connection problem with JDBC

Former Member
0 Kudos

Hi,

I am trying to connect to the JDBC driver. But i get the error below. Is it a problem related to the JDBC driver I deployed?

---

Error when attempting to get processing resources: com.sap.aii.af.service.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection to URL 'jdbc:microsoft:sqlserver://192.20.107.106:1433;databaseName=Northwind;': SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Login failed for user 'administrator'.

---

My connection parameter of JDBC:

com.microsoft.jdbc.sqlserver.SQLServerDriver

jdbc:microsoft:sqlserver://ip:1433;databaseName=Northwind;

By the way i am using the login username and password of the server. I looked at the users of the database but couldn't find the password.

Thanks in advance.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

The problem is solved. It was the authentication and not the driver. Thank god It is working now.

agasthuri_doss
Active Contributor
0 Kudos

Hi,

>By the way i am using the login username and password of the server. I looked at the users of the >database but couldn't find the password.

Check with the Database Admin Team

Cheers

Agasthuri Doss