The port number 1433?database=DemoDB is not valid.

This DD had been working. Now I am getting this error when I try to run:

DBD: Area VPath:/default/main/DotCom/WORKAREA/Content
DBD: Setting up TDbSchemaAgent.
DBD: Loading com.microsoft.sqlserver.jdbc.SQLServerDriver
DBD: url : jdbc:sqlserver://DBSERVER:1433?database=DemoDB
DBD: login : sa
DBD: login timeout=3
DBD: Connecting to the database...
DBD: Try connecting using jdbc:sqlserver://DBSERVER:1433?database=DemoDB...
DBD: SQL failure
DBD: ERROR:ERROR: Could not connect to [jdbc:sqlserver://DBSERVER:1433?database=DemoDB]
DBD:
DBD: *******************************************************
DBD: SQLException occured in JdbcCheckup:MakeConnection()
DBD: Exception Message: The port number 1433?database=DemoDB is not valid.
DBD: Vendor Error Code: 0
DBD: SQL state: null
DBD: *******************************************************

My database.cfg has not changed.

I have run SQL manager on DBSERVER and DemoDB is a valid DB and is running.

I have checked the event subssytem logs and no errors are apparent, so I suspect the drivers are correct. How do I check the port ? I cannot see that changing but I am not certain what else to look at. On Unix I had ODBC test, what can I use here to check the port/db/etc ?

I am running Win2003 OD/DD 6.2 SQLSVR 2005

Tips/Pointers/RTFMs appreciated.

Andy

Find more posts tagged with

Comments

ISCBorisB

This DD had been working. Now I am getting this error when I try to run:

DBD: Area VPath:/default/main/DotCom/WORKAREA/Content
DBD: Setting up TDbSchemaAgent.
DBD: Loading com.microsoft.sqlserver.jdbc.SQLServerDriver
DBD: url : jdbc:sqlserver://DBSERVER:1433?database=DemoDB
DBD: login : sa
DBD: login timeout=3
DBD: Connecting to the database...
DBD: Try connecting using jdbc:sqlserver://DBSERVER:1433?database=DemoDB...
DBD: SQL failure
DBD: ERROR:ERROR: Could not connect to [jdbc:sqlserver://DBSERVER:1433?database=DemoDB]
DBD:
DBD: *******************************************************
DBD: SQLException occured in JdbcCheckup:MakeConnection()
DBD: Exception Message: The port number 1433?database=DemoDB is not valid.
DBD: Vendor Error Code: 0
DBD: SQL state: null
DBD: *******************************************************

My database.cfg has not changed.

I have run SQL manager on DBSERVER and DemoDB is a valid DB and is running.

I have checked the event subssytem logs and no errors are apparent, so I suspect the drivers are correct. How do I check the port ? I cannot see that changing but I am not certain what else to look at. On Unix I had ODBC test, what can I use here to check the port/db/etc ?

I am running Win2003 OD/DD 6.2 SQLSVR 2005

Tips/Pointers/RTFMs appreciated.

Andy

Sounds like Firewall modifications. Can you "telnet" to it from the OD Server (telnet <IP or DNS Entry> 1433)?
With a successful connection, you'll get a blank screen but no message. If unable to connect, it'll throw some Error

nipper

Sounds like Firewall modifications. Can you "telnet" to it from the OD Server (telnet 1433)?
With a successful connection, you'll get a blank screen but no message. If unable to connect, it'll throw some Error

Same server, so it should not be a firewall issue, but will try the telnet.

Migrateduser

are you connecting by machine name? if so, what about trying via IP instead.. maybe there is another machine on the network with the same name or some other odd reason it cant resolve what your trying to connect to.. if its the same machine, what about trying localhost also?