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
 General SQL Server Forums
 New to SQL Server Programming
 Import log files to sql server

Author  Topic 

davebatt
Starting Member

17 Posts

Posted - 2012-08-06 : 09:26:13
Hi

A client wants some reporting done on their log files, as well as some other data. I decided to import everything into sql server so I can report off it.

After researching Ive decided to use log parser, ran through sql server agent as an activex step.

The problem is I get this error "Error creating security descriptor for shred objects error 1332.

A bit more reading tells me i need to setup a proxy to give the step the correct permission.

I have no idea what to do so played with creating a credential and then assigning to a new proxy, but then get error "Could not get proxy data for proxy id = 1"

Basically I know nothing about sql server users or permissions and need some help.

Thanks Dave
   

- Advertisement -