Data Deploy ERROR "login failed for user"

Hi everyone,
--->I am using Open deploy 7.1 on windows 2003 platform.
--->I have configured data deploy to work with SQL server 2005.
--->when i try to run a script to connect to database i get the following error:-

DBD: Connecting to the database...
DBD: Try connecting using jdbc:inetdae:nc006vdevd001:1433?database=kmsdevdb&sql7=true...
DBD: SQL failure
DBD: ERROR:ERROR: Could not connect to [jdbc:inetdae:nc006vdevd001:1433?database=kmsdevdb&sql7=true]
DBD:
DBD: *******************************************************
DBD: SQLException occured in JdbcCheckup:MakeConnection()
DBD: Exception Message: [NC006VDEVD001]Login failed for user 'iwdbadmin'.
DBD: Vendor Error Code: 18456
DBD: SQL state: 28000
DBD: *******************************************************
DBD:
DBD: *******STACK TRACE*************
DBD: ERROR:
java.sql.SQLException: [NC006VDEVD001]Login failed for user 'iwdbadmin'.
at com.inet.tds.e.a(Unknown Source)
at com.inet.tds.e.a(Unknown Source)
at com.inet.tds.e.(Unknown Source)
at com.inet.tds.TdsDriver.connect(Unknown Source)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:154)
at com.interwoven.dd100.dd.JdbcCheckup.MakeConnection(JdbcCheckup.java:447)
at com.interwoven.dd100.dd.JdbcCheckup.TryConnect(JdbcCheckup.java:551)
at com.interwoven.dd100.dd.TDbConnectionManager.GetConnection(TDbConnectionManager.java:78)
at com.interwoven.dd100.dd.TDbAgent.EstablishConnection(TDbAgent.java:550)
at com.interwoven.dd100.dd.TDbAgent.(TDbAgent.java:272)
at com.interwoven.dd100.dd.TDbSchemaAgent.(TDbSchemaAgent.java:64)
at com.interwoven.dd100.dd.TConsumerManager.getDbAgentBasedOnGroupUpdate(TConsumerManager.java:514)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumer(TConsumerManager.java:587)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumersForOneDeployment(TConsumerManager.java:192)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumers(TConsumerManager.java:133)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:105)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:598)
at com.interwoven.dd100.dd.TDASThread.ProcessItem(TDASThread.java:203)
at com.interwoven.dd100.dd.TDASThread.run(TDASThread.java:128)
DBD: ERROR:Could not connect to [nc006vdevd001:1433?database=kmsdevdb]
DBD: ERROR:Unable to connect to nc006vdevd001:1433?database=kmsdevdb
DBD: ERROR:TDbAgent constructor failed.
DBD: Error occured in TDbSchemaAgent

--->Username iwdbadmin is working fine if i run it from sql management studio.
--->I have attached the configuration file and the log file.
--->Please advice me how to fix this problem.
Thanks in advance.

Find more posts tagged with

Comments

Migrateduser_427

We also just upgraded to 7.1 OD Base from 6.2 OD Base on Win Server 2003. Same issue as you; same logs too. I opened a case with support and waiting on follow up.

Abishk

Thanks shawn for replying, kindly update me as well if you are able to fix the problem,

Regards

Abishk

I was able to fix the problem successfully.

-->In 7.1 OD/DD will support only encoded or encrypted passwords for DB.
-->If you have not set the strictAuthentication attribute in element then you ENCODE the db password using od-home/bin/iwodpasscoder clt and then give the encoded password in element with the attribute password-encoded set to “yes”.
-->If you have set the strictAuthentication attribute to “yes” in element then you ENCRYPT the db password using od-home/bin/iwodpassencrypter clt and then give the encrypted password in element with the attribute password-encoded set to “yes”.

I hope this helps..

RonaldV

@IWOV: in which manual is this reflected? :mad:

dazzlad

Brilliant:

Database Deployment for OpenDeploy® Administration Guide 7.1 - Encoding/Encrypting Database Passwords

"DataDeploy configuration files store database passwords as clear text, by default."