Products | Versions |
---|---|
TIBCO BusinessConnect | - |
Not Applicable | - |
Resolution:
Description:
============
My Microsoft SQL Server database uses a non-standard port ( i.e. 1456) rather than the default port of 1433. How can I specify the port 1456 in the Archiver script file?
Environment:
============
BusinessConnect 5.2.x, 5.3.x versions.
Symptoms:
=========
I am getting the following error when I don't specify the MS SQL server database non-default port number in the BusinessConnect Archiver script file against the FROMSVR variable.
SQLState = 08001, NativeError = 1326
Error = [Microsoft][SQL Server Native Client 10.0]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if
SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.
Cause:
======
As the MS SQL server database non-default port number is not specified against FROMSVR variable in BusinessConnect Archiver script file, you may notice the above error.
Resolution:
=========
By default, BusinessConnect Archiver script uses the default port of 1433 for the MS SQL server database. If you are using non-default for your MS SQL server database, then you have to specify the port number in the Archiver script. The syntax to specify the non-default port number for your MS SQL server database is as follows:
set FROMSVR="<db server name>,<port number>"
example,
set FROMSVR="sqlserver,1456"
Note: The Archiver Tool uses the default ports for Oracle, DB2 and Mysql databases. If your Oracle, DB2 and Mysql databases are using non-default ports then use port forwarding.