May 25, 2010 at 10:47 pm
Hi all,
In sql server 2008,I want to move IIS LogFile into DATABASE Table.
pls help me.
May 28, 2010 at 1:10 am
create a table having similar strucutre as that of the file and then using bcp insert the data??
June 9, 2010 at 2:27 pm
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.
June 8, 2012 at 8:14 am
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
June 8, 2012 at 8:25 am
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
June 8, 2012 at 5:53 pm
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
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy