Hello, SQL 2008 R2
Created a new instance of SQL and migrated from the old 2000 instance (new system also).
My bulk insert gives the error
Cannot bulk load because the file "\\MyFileServer\myfile.txt" could not be opened. Operating system error code 5(Access is denied.).
The instance is running as a domain administrator and I went so far as to add the domain/account to the SQL security logins and give the bulkadmin permission. I then used xp_cmdshell to copy the files to the SQL server and the bulk insert works.
The instance is running as a domain admin
The use has domain admin rights
The domain admin has permissions to folder involved
The use has bulkadmin server role (also sysadmin)
Getting access is denied.
What have I missed?
Thanks
djj
The Lord is My Shepard (Psalm 23) - I need someone to lead me!
Created a new instance of SQL and migrated from the old 2000 instance (new system also).
My bulk insert gives the error
Cannot bulk load because the file "\\MyFileServer\myfile.txt" could not be opened. Operating system error code 5(Access is denied.).
The instance is running as a domain administrator and I went so far as to add the domain/account to the SQL security logins and give the bulkadmin permission. I then used xp_cmdshell to copy the files to the SQL server and the bulk insert works.
The instance is running as a domain admin
The use has domain admin rights
The domain admin has permissions to folder involved
The use has bulkadmin server role (also sysadmin)
Getting access is denied.
What have I missed?
Thanks
djj
The Lord is My Shepard (Psalm 23) - I need someone to lead me!