MSSQL Database credential authentication error

[nnaike]

I have been trying to test and authenticate this database server but I keep getting this error. Any help?

 

[mjamison]

Hi,

"The Adaptive Server connection" error indicates a network firewall blocking access from the RN150 to that address, a firewall running on that server blocking access, the MSSQL server running on a different port, or an incorrect IP address.

Please confirm that the IP address is correct and that the MSSQL server is listening on TCP port 1433. If so, then there is likely an access restriction preventing the RN150 from communicating with that server on that TCP port

[nnaike]

Thanks for the response. I know there is a CSV import for multiple database ip upload. my question is, are each of the ip addresses separated by a comma or space and how should the CSV file be named.

Thanks.

[mjamison]

Hi,

Please the following requirements when creating your csv import file.

Please upload a .csv file containing your database credentials. The file must be named 'database.csv'. Your file must be under 1MB and properly formatted or it will be rejected.

You may use a database.csv file to add and remove creds.
Row format is as follows (no header row):
action, ip, username, password, dbtype, port, sid (oracle only)
Valid dbtypes are MySQL, MSSQL, and Oracle.
Valid actions are add, remove.
Only exact matches will be removed.