Microsoft SQL Server ODBC Driver Configuration

Please follow the next steps to specify the ODBC connection: Open ODBC Data Source Administrator (64 bit), tab 'System DSN'

Press on button 'Add' and select SQL Server Native Client driver:

Point the name of test connect and server name and press on button 'Next':

Select radiobutton for SQL Server authentication and set login ID and password for connect. Press on button 'Next':

Switch on the checkpoint for default database, select corresponding database name and press on button 'Next':

On the next page press on button 'Finish' and test Data Source connection:

If it is successful - the connect is ready.

Now your ODBC Data Source is ready.

After that please restart the SQLWays Wizard tool and you will see the ODBC connection in the “User\System DSN” drop down option.

If you have any questions or face with some difficulties, please contact us: support@ispirer.com
Tags: #2