Configure your device and the Connect action from the Database package to automate connecting to a Microsoft SQL Server with Windows NT authentication.
This task is applicable only for releases prior to Build 9664. Starting from Build 9664, you no longer have to add DLL files manually to connect to the Microsoft SQL Server.
To use Windows NT authentication for connecting to the Microsoft SQL Server, perform the following steps:
Next steps
Choose from the following:- Use the Read from action to retrieve records from the database.
- If you are automating a task that involves making changes to the database, insert the Begin database transaction action.
This action ensures that all records are updated or deleted in their entirety, and prevents accidental updates or deletions of incomplete data if the bot encounters an error during run time.
