The DataServer for MS SQL Server will allow you to use either the Windows or MS SQL Server authentication model for your connection to the MS SQL Server data source. For more information on database security, see Microsoft's SQL Server documentation.