Default DD Deployemnt not working

maverick83

Hi


I have just done a fresh installtion of OD 6.1.1.0.0 with DD module enablaed ,i have done few test deployments like "xml_to_ddxml,test" ,they are working correctly ,we have SQL server 2005 installed with only default user sa enabled

but when i try to run default deployment "ddconfig"(supplied with OD) ,it gives the below error msg

[php]
DBD: Loading com.inet.tds.TdsDriver
DBD: url : jdbc:inetdae:localhost:1433?database=Dev&sql7=true
DBD: login : sa
DBD: login timeout=3
DBD: Connecting to the database...
DBD: Try connecting using jdbc:inetdae:localhost:1433?database=Dev&sql7=true...
DBD: SQL failure
DBD: ERROR:ERROR: Could not connect to [jdbc:inetdae:localhost:1433?database=Dev&sql7=true]
DBD:
DBD: *******************************************************
DBD: SQLException occured in JdbcCheckup:MakeConnection()
DBD: Exception Message: [TDS Driver]Connection was closed from the SQL Server site or network at header (0)
DBD: Vendor Error Code: 0
DBD: SQL state: null
DBD: *******************************************************
DBD:
DBD: *******STACK TRACE*************
DBD: ERROR:
java.sql.SQLException: [TDS Driver]Connection was closed from the SQL Server site or network at header (0)
at com.inet.tds.e.a(Unknown Source)
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:512)
at java.sql.DriverManager.getConnection(DriverManager.java:140)
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:549)
at com.interwoven.dd100.dd.TDbAgent.(TDbAgent.java:271)
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:547)
at com.interwoven.dd100.dd.TDASThread.ProcessItem(TDASThread.java:203)
at com.interwoven.dd100.dd.TDASThread.run(TDASThread.java:128)



[/php]


the sql server is on the local machine only so i tried both the following ways(with and without port) :-

[php]

(a)
(b)
[/php]


i have copied the 4 jar file(msbase,mssqlserver,msutil,sqljdbc) in drivers directory also ,

any pointers regarding this issue from experts


regards,
mav

Migrateduser

Hi Mav,

This could be a port issue, check if 1433 is running fine and being used by MSSQL 2005

Thanks
Paul