The
Data - SQL Server VBO uses SQL Server Authentication unless the Username value is left blank. If it is left blank, then the VBO will default to Windows Authentication using the credentials of the currently logged in user.
Were you trying the connection string with the SQL Server VBO or with the OLEDB VBO?
Cheers,
Eric