Data Services 3.2 Management Console connectivity

dataservices administration
1

We’re upgrading to Data Services 3.2 from DI 11.7.
Also we’re moving from Oracle Local Repositories to Local Repositories in SQL Server 2005 cluster (on an instance).

Management Console gives the error:

There’s nothing wrong with TCP/IP.
However, Management Console can’t connect on port 1434 (the SQL Server service port for the ‘sql2005’ instance). This port is dynamic, so will change if we restart our SQL Server cluster. We can connect on another port number (3419), which seems very odd. I don’t really want to have to reconfigure Mgmt Console every time we restart the SQL Server cluster.

Any idea why DS3.2 Mgmt Console won’t connect to that 1434 port number? Anyone point me towards places to look? Or am I not giving enough detail?

Thanks, Neil

Neil Phillips :uk: (BOB member since 2002-08-22)

2

Isn’t SQL Server port 1433 (not 1434) by default?

My guess is that few people (here on these forums) have changed the port, nor are people using Named Instances of SQL Server, so you may be forging new ground here.

dnewton :us: (BOB member since 2004-01-30)

3

Yes, that’s right. For each instance the port number then gets incremented.

Forging new ground is never a good position to be in :wink:
I’d have hoped SAP would have covered scenarios like this though.

We’ll keep looking at it and post any progress.

Neil Phillips :uk: (BOB member since 2002-08-22)

4

Maybe try creating a formal ODBC connection in control panel (on the job server) to the repo database, and then use that connection instead in the DS admin configuration… it might insulate DS from that complexity?

dnewton :us: (BOB member since 2004-01-30)