Creating an ODBC Data Source from SQL Server

1. Open the ODBC Data Source Administrator tool. To do that, navigate to Start > Programs > Windows Administrative Tools, and choose ODBC Data Sources (64-bit) or ODBC Data Sources (32-bit). Optionally, you can search for ODBC Data Source in the Windows Start menu and locate the tool. For Vulcan 2020 and onwards, 32-bit is not supported.
2. Go to the System DSN tab and then click Add.
   
3. Choose SQL Server and click Finish.
   
4. Enter the name for your datasource (eg. ODBC-Vulcan here), some description (optional) and, then the SQL Server name that you want to connect to and click Next.
   
5. Use Windows authentication if that is what you are using, or choose SQL Server Authentication and enter the user name/password.
   
6. Check to change the default database to the database you want to connect to in the server and then click Next.Example, we are choosing a drillhole database here.
   
7. Leave the settings as it is (unless you want to change something) and click Finish.
   
8. The datasource is created. Click Test Data Source to test whether the connection has been established or not.
   
9. Test Data Source should report back that the tests are completed successfully. If there are errors, please review the steps above as it may be security or network related.