Download SQL test Utility

Version: 1.02   4th February 2022 (KB last updated 9 June 2022)

How to implement and use this utility.

This utility is useful for administrators to determine if BNS's software will connect to MS SQL servers in your own cloud, Azure, AWS etc in advance of deploying BNS's software. 

Notes: 

1. Microsoft OLEDB for SQL Server 18.x (minimum) is required to provide TLS 1.2 support.   Customers who set a minimum TLS version 1.2 may need to install upgraded Microsoft software driver software.
2. One way of doing this is to install the Microsoft SQL Management studio 18.x minimum release. 
3. By installing the Microsoft SQL Management studio, the Microsoft installer installs a range of providers for SQL Server support such as the Microsoft OLE DB Driver for SQL Server version 18.5.0. 
4. Authentication to Azure SQL may require the use of a SQL user login if Windows Authentication does not work.  

Firewall port 1433 or other designated ports must be open from the Windows computer where this software will be installed and the MS SQL Server.  

STEP 1 - download the SETUP ZIP file  

Download SQL test utility

STEP 2 - Create a Database on your SQL server called BNSTEST

STEP 3 - Open the BNSTEST DDL and use it to create a simple table called BNSTEST

STEP 4 - Create a SQL local user or decide upon an existing Windows Account for permissions to read and write to the BNSTEST DB. 

STEP 5 - From a Windows computer in your network install the msXsqlTest_Setup.MSI on it. 

Click Finish when the installation is complete. 

STEP 6 - run the utility 

Select the configuration tab

The example below shows an Azure SQL server DNS address with the SQL DB called BNSTEST

Select the Auth type auServer (SQL Local user) or auWindows (Windows Authentication) 

Supply the password then press save

Select 'Test Connection' 

Press OK.  

If there are any connection or permissions issues the log file button may reveal what the issue could be. 

Select the SQL Test tab to write and read data 

enter some data then press the Write option.

Press OK 

Select the Read Table option

That completes the tests required to prove connectivity and permissions to the database