Question Locked

IAS + SQL Logging rights

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I setup IAS to log to SQL and created a database with the necesary fields and the report_event stored procedure.

IAS is authenticating as a SQL user I created just for this purpose, it's only permissions on the database are Connect, Insert and has Execute on the Stored Procedures. This works ok.

I tested the connection and it passed.

What permissions should this user have on the DB and stored procedure?

I figured maybe:
Insert, Execute, and maybe Authenticate on the DB and only Execute on the SP?

Also what is the max concurrent connections setting? It defaults to 2 is this ok?

Cheers,

1 reply

This discussion is closed to new replies.