Permissioning Issue Using BCP - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Permissioning Issue Using BCP

Author

Topic

RegressionMan
Starting Member

3 Posts

Posted - 2011-01-16 : 11:23:21

I'm new to SQL. I'm running SQL Express 2008 on Windows 7. I'm able to successfully use BCP from the command line, however, when I try to use it inside SQL Server Management Studio Express 2008, I get the following error:

SQLState = S1000, NativeError = 0
Error = [Microsoft][SQL Native Client]Unable to open BCP host data-file

I'm using Windows Authentication. Additionally, I ran whoami.exe (Exec xp_cmdshell 'whoami.exe'). It returned nt authority\network service, not my login id.

I'm assuming my problem is some sort of security-related issue.

Help!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-01-16 : 12:51:29

Yes, you'll need to change the SQL Server service account to one that has permissions.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog