Differences

This shows you the differences between two versions of the page.

--- dynamiczip:install:mods:release:build72:sql_optimized_import [2015/12/14 23:05] – chuck
+++ dynamiczip:install:mods:release:build72:sql_optimized_import [2021/10/27 16:29] (current) – [Access Denied] chuck
@@ Line 11: / Line 11: @@
 **IMPORTANT:** If BULK INSERT fails, the [[dynamiczip:glossary:rate_and_boundary_database|Rate & Boundary Database]] files will be read in the traditional (and slower) way. Failure of the BULK INSERT process will __not__ slow down the other import process that have been optimized.
-Although maintaining two versions will be extra work, we believe it will be a great way for us to catch errors in the import process. The Non-Optimized Import also provides our users with an alternative way to perform the  [[dynamiczip:features:import:rate_and_boundary_import|Rate & Boundary Import]] should the SQL Optimized Import fail for any reason.
+The Non-Optimized Import provides our users with an alternative way to perform the  [[dynamiczip:features:import:rate_and_boundary_import|Rate & Boundary Import]] should the SQL Optimized Import fail for any reason.
+===== Access Denied =====
+The error message indicating that the import file cannot be opened such as:
+<code/>
+Cannot bulk load because the file FipsCodes.txt could not be opened. Operating system error code 5(Access is denied.)
+</code>
+seems to typically be related to the security context under which the SQL Server service is running. Switching the SQL Server login to Local System Account may eliminate the error.
 ----
 [[dynamiczip:install:mods:modifications|Modifications]]