on 03-13-2017 3:52 PM
Hi,
because during installation I didn't create Audit database, I'd like to create it right now.
I created database, ODBC 32-bit and 64-bit, change in CMC -> Auditing -> Configuration Connection Name and restart SIA, and in my opinion when SIA starting then create all tables in Audit database.
But every time I get error: see attached file
My SAP environment - SAP BO: 4.2 SP3
Does the account you're using to log in to the auditing database have access to create tables and indexes? Is the SIA running on the same account as you're using to log in to the database?
-Dell
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Rad,
It looks like you may NOT have SSO integrated for ALL BI4 servers and users ID. You will need create an actual MS SQL Server account that has full ownership permissions to the Audit Database. You can try using the SA id and password temporally to confirm this what required.
Try the SA account to confirm and then create a SQL Server ID that has ownership to the Audit DB.
Regards,
Ajay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
User which I use to log into Audit database has rights to create tables in Audit database.
But in Services -> SIA there is user: Local System.
Is this cause a problem?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Unless you have explicit created and allowed you local system account access to the Audit DB this will not work.
Try instead of using Windows Authentication to use a specific user you have created in your DB that have access to the Audit DB (And unless it is a sandbox don't use the SA account for this, and event so - please don't).
(Or if you insist on using the Windows Authentication for this, then create a dedicated Service Account for the Tomcat/SIA and then assign this Service Account in your Microsoft SQL Sever, and give that account proper rights to the Admin DB.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.