Pages

Thursday, August 4, 2016

Transfer Logins Task fails with the error message: "Set Database failed. "

Description:

While migrating the logins with the "Transfer Logins Task" from SQL Server Integration Services (SSIS) you might receive the following error message:

Error: Execution failed with the following error: "Set Database failed. ".
Error: Execution failed with the following error: "Value cannot be null. Parameter name: database".


Thursday, June 2, 2016

SQL Ser 2016 Setup - The service did not respond to the start or control request in a timely fashion.

Symptoms:
When installing SQL Server 2016 on a domain joined computer and you have selected the "R Services (In-Database)" option, during the setup you will receive the following error message:
"The service did not respond to the start or control request in a timely fashion."


Error message box





Wednesday, February 25, 2015

Flat File Destination failed the pre-execute phase and returned error code 0xC020200E.

On SQL Server 2012 (or newer), when you are running a SSIS package (which accesses a network share), you can retrieve the following error message:

Flat File Destination failed the pre-execute phase and returned error code 0xC020200E.
and
Cannot open the datafile "\\<remoteserver>\<remotefile>"