Unsolved
This post is more than 5 years old
5 Practitioner
•
274.2K Posts
0
1022
DPA migration of Datamine database
I am trying to migrate my DPA 5.5 server to DPA 6.1 using the DPA Migrator tool V 1.2.
Our DPA 5.5 datamine database in currently located on a diffferent server from the DPA 5.5 server
The dtatamin db is a MSSQL db , using connection port 8860
The migrator tool is trying to use the MSSQL default port of 1433.
How can I configure DPA migrator to use port 8860 instead of 1433?
Below is the output from the datamine database connection testing.
Testing database connection.
Database Connection Info
Type: MSSQLServer
Server: gedssql11p.saa.us\SAA2,8860
Database: DPA_Datamine
Port: 1433
Flags: 0
Unable to verify database connection.
The TCP/IP connection to the host gedssql11p.saa.us, port 1433 has failed. Error: "connect timed out. Verify the connection properties, check that an instance of SQL Server is running on the host and accepting TCP/IP connections at the port, and that no firewall is blocking TCP connections to the port.".
SherylG
6 Posts
1
March 14th, 2014 11:00
Just a suggestion: request the help of the SQL server administrator. He/she will be able to ensure that the proper port is used. Also, submit a service request for help with the migration. I struck gold when I did that; the support I received from the EMC technician was phenomenal.
Anonymous
5 Practitioner
5 Practitioner
•
274.2K Posts
0
March 19th, 2014 13:00
thank you - I did get help from our SQL admin and he let me know the correct port #.
Mary Beth
sks10241
2 Posts
0
July 18th, 2014 10:00
I am having the same issue. I got the correct port number from my sql admin, but where do I change it in the migration tool?
Thanks