IIS Log To database table

Question

Post reply

IIS Log To database table

DBA_1276

SSC Eights!

Points: 878
More actions
May 25, 2010 at 10:47 pm

#235545

Hi all,
In sql server 2008,I want to move IIS LogFile into DATABASE Table.
pls help me.

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

VastSQL SSC-Dedicated Points: 36097 More actions · Answer 1

create a table having similar strucutre as that of the file and then using bcp insert the data??

MWise SSCarpal Tunnel Points: 4074 More actions · Answer 2

We use LogParser http://www.microsoft.com/downloads/details.aspx?familyid=890cd06b-abf8-4c25-91b2-f8d975cf8c07&displaylang=en. Basic setup is LogParser in a batch script run by a scheduled job. There are a lot of examples for LogParser out there to load up the IIS log.

rwiethorn SSC Veteran Points: 279 More actions · Answer 3

Hello Old Hand,

Regarding your LogParser Jobs,

Are You running and importing on the same server?

I'm trying to run on Server1, and read on Server2.

I get denied access when the LogParser, on Server 1 tries to read the files on Server 2. Those files are the IIS log files on Server 2.

Server 2 is my high availability Web Hosting and Data Server.

If I Have Server 1 process a file locally to itself, it works.

I got it to work by Granting access on the folder to the Network Service account.

Doing that on the Server2 doesn't help.

Any ideas on what I should try?

Thanks,

rwiethorn

MVDBA (Mike Vessey) SSC-Insane Points: 21797 More actions · Answer 4

rwiethorn (6/8/2012)
Hello Old Hand,
Regarding your LogParser Jobs,
Are You running and importing on the same server?
I'm trying to run on Server1, and read on Server2.
I get denied access when the LogParser, on Server 1 tries to read the files on Server 2. Those files are the IIS log files on Server 2.
Server 2 is my high availability Web Hosting and Data Server.
If I Have Server 1 process a file locally to itself, it works.
I got it to work by Granting access on the folder to the Network Service account.
Doing that on the Server2 doesn't help.
Any ideas on what I should try?
Thanks,
rwiethorn

rwiethorn, this question has already been posted by you on 2 other forums - please be patient and wait for someone to answer one of your queries rather than posting multiple times and hijacking other posts

MVDBA

MWise SSCarpal Tunnel Points: 4074 More actions · Answer 5

We run the process on the server that logs are located on and write them into our db server which is a different server. Check the documentation on how to connect to SQL via either SQL login or Windows authentication. I believe you just need to get your security settings correct on the database server and the connection info fed into the LogParser command.

MWise