Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Netweaver 7.52 SP04 Trial / Documentation 1.0

penzoletti
Newcomer
0 Kudos
333

After overcoming a few hurdles, I was able to install the trial system sucessfully (although due some ambigous parts in the documentation).

Finally I tried to follow the guide (btw on https://blogs.sap.com/2019/10/01/as-abap-7.52-sp04-developer-edition-concise-installation-guide/ there are some dead links) on https://assets.cdn.sap.com/sapcom/docs/2019/09/32638f18-687d-0010-87a3-c30de2ffd8ff.pdf - on page 26 for turning off auditing:

sp_configure, 'auditing', 0
results in an error:

Msg 10331, Level 14, State 2: Server NPL, Procedure sp_configure, Line 1310: Permission denied, database master,

owner dbo. You need the following permission(s) to run this command: MANAGE SECURITY CONFIGURATION (return status = 1). ASE Version is 16.0 SP03 PL06

As in the guide recommended, I switched to sybnpl and executed isql - Usapsa -X SNPL.

How can I fix this or are there other ways to improve performance?

Thanks a lot,
KR. Martin

2 REPLIES 2

eric_martorana
Explorer
153

Hello,

I juste encountered the exact same problem. And found a part of the solution on another blog.

This command (to deactivate ASE audit) has to be launched with sapsso, not with sapsa. But when you launch it with sapsso, you may get an error message related to the memory. So to extend memory there is another command to execute with sapsa (this time).

Synthesis:

1) with sapsa, extend memory:

isql -Usapsa -X -SNPL

sp_configure 'max memory',740621

go

quit

2) and then with sapsso deactivate ASE Audit:

isql -Usapsso -X -SNPL

sp_configure 'auditing', 0

go

quit

I hope it helps.

Kr

Eric.

153

Worked perfectly - thanks Eric!