BULK INSERT failing-Can't find the file

Question

I created some code that takes a CSV and BULK INSERTS it into an MS SQL database.

This is on Windows Server 2017. MS SQL 2017. CF 2016. SQL Server is separate from the CF server and connected with an internal 192.x.x.x. IP

The code works perfectly on my local development box, but when I run it on the server the CFQUERY BULK INSERT fails, 'the system can not find the path specified'

The file is there, I've also tried multiple locations. I can only presume this is a permissions issue. (CF is running on it's own user account with admin rights).

I'm somewhat stuck. I presume all of the permissions are made by CF?

Update:

Resolved. I was using the wrong password for the CF account

Solution: Create the same user account on the SQL box that is used for CF to run under, and then write to \\SQLServerIPS\c\ . I was using the wrong password, problem resolved.

ACS LLC · Accepted Answer

I was looking to mark it as correct but could find an option, I guess the initial post can't be the right answer which makes sense.

Reposted below

Resolved. I was using the wrong password for the CF account

Solution: Create the same user account on the SQL box that is used for CF to run under, and then write to \\SQLServerIPS\c\ . I was using the wrong password, problem resolved.

BKBK · Answer

Please copy the answer to a new post and mark the ticket as correctly answered. It will help someone else in future.

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded