Errors 297 and 229 with db transactions

[Former Member]

Hello.

SAP 4.7 with SQLSERVER 2005, when running ST04, DB12, DB13 etc. the following error messages appear in sm21, and transactions dump:

Database error 297 at FET

> The user does not have permission to perform this action.

Errore run time "DBIF_DSQL2_SQL_ERROR"

> Dump breve "071002 224539 srvsap1 SAPSYS " creato

Interruzione transazione 00 (DBIF_DSQL2_SQL_ERROR 20071002224539srvsap1 SAPSYS 0001 )

Database error 297 at FET

> The user does not have permission to perform this action.

Errore run time "DBIF_DSQL2_SQL_ERROR"

> Dump breve "071002 225034 srvsap1 SAPSYS " creato

Interruzione transazione 00 (DBIF_DSQL2_SQL_ERROR 20071002225034srvsap1 SAPSYS 0001 )

Database error 297 at FET

> The user does not have permission to perform this action.

Errore run time "DBIF_DSQL2_SQL_ERROR"

> Dump breve "071002 225535 srvsap1 SAPSYS " creato

Interruzione transazione 00 (DBIF_DSQL2_SQL_ERROR 20071002225535srvsap1 SAPSYS 0001 )

Database error 229 at FET

> The EXECUTE permission was denied on the object

> 'xp_enumerrorlogs', database 'mssqlsystemresource', schema

> 'sys'.

Database error 229

Database error 229 at FET

> The SELECT permission was denied on the object 'sysaltfiles'

> database 'mssqlsystemresource', schema 'sys'.

Errore run time "DBIF_DSQL2_SQL_ERROR"

> Dump breve "071002 230049 srvsap1 SAPSYS " creato

Interruzione transazione 00 (DBIF_DSQL2_SQL_ERROR 20071002230049srvsap1 SAPSYS 0001 )

Database error 297 at FET

> The user does not have permission to perform this action.

Does anybody know what needs to be checked and how to fix these authorization errors?

Thanks a lot in advance.

Kind regards,

Dino

[Former Member · Accepted solution]

Hi Dino,

for these errors I recommend to check the following SAP Notes :

<b>592514 </b>: MSSQL: internal database users, permissions and security

<b>610640</b> : sp_check_sap_login

The script in note <b>610640</b> can even be run with the repair option in case it found some login-problems in check mode that you do not want to adjust manually.

Kind Regards,

Beate