Skip to Content
0

Audit database - create database

Mar 13, 2017 at 03:52 PM

91

avatar image

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

capture.jpg (58.5 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Dell Stinnett-Christy Mar 13, 2017 at 03:59 PM
1

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

Share
10 |10000 characters needed characters left characters exceeded
Rad Nap Mar 14, 2017 at 10:07 AM
0

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?

Show 2 Share
10 |10000 characters needed characters left characters exceeded

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

0

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.

0
Ajay Gupta Mar 14, 2017 at 08:22 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded