July 26, 2005 at 7:48 am
This is how I am trying to output the text file to another server that is on the other side of a firewall and DNS is not passing the name. But the IP address and sharepoint work fine from Windows Explorer. However BCP does not seem to like spitting out to the IP addr. Can it do this?
BCP Database..Table OUT '\\192.100.100.10\Sharename\Folder\FileName.txt'
July 26, 2005 at 8:22 am
hmmm.... I may have just found my own help in this other post from J.Kozloski:
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=24&messageid=204045
which says:
"You generally need to have the SQL Server running under a domain user account for it to be able to access network resources, such as file shares. So, although you can access the path, the SQL Server can't because it's running as the local system account (NT AUTHORITY\SYSTEM)
Check the account the working server is running as, I'll bet it's not the system account.
In Enterprise Manager: Right-click the server, select properties. Then select the Security tab, and check the Startup service account near the bottom of the dialog.
You'll also probably want to check the same on the SQL Server Agent, since it runs as a separate service. Right-click the SQL Server Agent, select properties, and it's the first thing you see on the General tab.
Hope this helps!
-- J.Kozloski, MCDBA"
I had already checked the SQL Agent Login which (unfortunately) uses the Admin account. But had not yet checked the SQL Server service.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply