To record data to a Microsoft SQL Server database, create the database, and configure an ODBC definition to it. Configure your integration node so that it can connect to the database.
You can use Integrated Windows Authentication to specify a Windows user account to be used for authentication when using Microsoft SQL Server to record and replay data. For more information, see Using Integrated Windows Authentication when recording data with a Microsoft SQL Server database.