February 17, 2009 at 1:32 am
Hi I will try to be as clear as possible
We have one SQL 2008 Server (SQL01) in domain 1 , when my account Domain1\dancewav runs the bulk insert command from my client in SQL 2008 Management Studio I can the follow error , the file to be Bulk inserted is on fileserver01
file could not be opened. Operating system error code 5(Access is denied.).
I know what you are thinking I dont have permissions to the file on fileserver01 , or dont have bulk insert permissions.
my account is sysadmin plus the permissions on the fileserver are full control to all.
What is strange is that if I log on to the SQL01 using my account and run the same command in managment studio on the server it works (i repeat the same account that fails from the client , works on the server)
also if I create a SQL Server Login and run from my client it works as well... Not really ideal as are security model is windows only..
any help or advice would be lovely.
note the file server and SQL Server are in the same domains.
many thanks
February 17, 2009 at 5:15 am
Found the solution in a SQL2005 thread, for those who get this error the solution was Try adding "Trust for delegation" to your Windows user account if you got this error in SQL 2005. :w00t:
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply