Forum Discussion

pvsharish9's avatar
pvsharish9
New Contributor II
4 years ago

SQL Server account connection setup failing with multiple error

Hello Community, We are trying to setup SQL server account in Snaplogic, however, getting below error Invalid username password- Able to login with windows authentication in microsoft sql mana...
accounts
service_account
sqlserver
JensDeveloper's avatar
JensDeveloper
Contributor II
4 years ago
Copy LinkReport

hi @pvsharish9 ,

Is the user emp added to the DB where you trying to connect to? with the right password?
If Yes,

Which JDBC Jars are you using have you tried this?
JDBC Driver Class: com.microsoft.sqlserver.jdbc.SQLServerDriver

And maybe try also only with this Url properties:

  • selectMethod : cursor
    Or do you need those other properties?

Advanced properties:

Regards

Jens

Related Content