cancel
Showing results for 
Search instead for 
Did you mean: 

Audit database - create database

Former Member
0 Kudos

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

capture.jpg

My SAP environment - SAP BO: 4.2 SP3

Accepted Solutions (0)

Answers (3)

Answers (3)

DellSC
Active Contributor

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

CdnConnection
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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?

former_member185603
Active Contributor
0 Kudos

Can you check if you can access the Audit DB user you created from the server?

What is your Audit DB? Oracle, SQL server or something else

Verakso
Participant
0 Kudos

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.