MS SQL Server - Bulk Insert in 2005

Author

Bulk Insert in 2005

JL Morrison

2006-01-24, 8:23 pm

After upgrading our servers to 2005, I am getting a problem with Bulk Insert
where it will does not import a file that is located on another server. I
am using UNC paths.
I have looked into BOL and investgated the changes in security but Ive
turned up nothing. The sql server process runs with a domain account that
has full rights on the remote UNC path...in fact i made it a local admin on
that box!
Running in 2000 compatibility doesnt help. i get this message..

Cannot bulk load because the file "filename" could not be opened. Operating
system error code 5(Access is denied.).

Razvan Socol

2006-01-25, 3:25 am

Hello, JL

See the topic "Security Considerations for Using Transact-SQL to Bulk
Import Data" in Books Online 2005:
http://msdn2.microsoft.com/ms186286.aspx

Razvan

JL Morrison

2006-01-26, 4:53 pm

When I use sa account, it works...because it is using the service account.
But I still cannot get it to work using any domain account..even one which
is a domain admin. Somehow its not passing the security rights along.

I really want to stop using sql server authentication

JL

"Razvan Socol" <rsocol@gmail.com> wrote in message
news:1138175309.065558.27770@g49g2000cwa.googlegroups.com...
> Hello, JL
>
> See the topic "Security Considerations for Using Transact-SQL to Bulk
> Import Data" in Books Online 2005:
> http://msdn2.microsoft.com/ms186286.aspx
>
> Razvan
>

Sponsored Links