How to Connect to SQL From VB6. If your business does any programming in Windows, then a basic knowledge of VB6 programming concepts is essential.

Figure 2. Successful Azure PowerShell Connection Output. Although this next step might have been set for other reasons, you must have a server firewall rule setup to allow incoming SQL connections ...

When creating automation scripts to discover, add, update or remove records from a remote SQL database, you need to make sure your script can successfully connect to the database.