Pages

Showing posts with label Kerberos. Show all posts
Showing posts with label Kerberos. Show all posts

Friday, March 10, 2017

SPN's deleted during cluster failover

This article is describing SPN’s disappearing while failing over a clustered instance. But this behavior can be applicable also to other services.

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>"