Not sure if this is correct Forum, if not, tell me where to ask.
Server 1 is a Production server. used for Web Hosting, and SQL Report Server.
Server 2 is will be used to execute the logParser.exe and read the data files into SQL 2008 R2
Goal: To run a Stored Proc on Server 2 and read the IIS log files found on Server 1 in the IIS Log folders. Read the content, insert into the SQL on Server 2 and then Delete files from Server 1
I am able to do this when the IIS log files are on the same Server.
Issue: I get Denied Access when the LogParser tries to access the file on a the distant Server.
I am testing by Creating a Job and executing the stored Proc and Runs it as "Executed as user: NT AUTHORITY\NETWORK SERVICE" account.
Sample Code that works when running on the same server:
LogParser "SELECT * FROM C:\inetpub\logs\LogFiles\W3SVC1\RMW\ex120601.log TO GlobalIISLog_2"
Sample Code that is Denied
LogParser "SELECT * FROM \\Server1.internal.domainY.com\G$\data\logs\W3SVC1\ex120603.log TO GlobalIISLog_2"
Question: What privileges should I change on the Source folders so the Account from Server2 can open/read the IIS Log files?
In the debugging, I found had to grant access for the Network Service account to the folders on Server2 . That's how I got my 'local' test to work.
All help is appreciated
rwiethorn At Gmail dot com