Skip to Content
avatar image
Former Member

Errors 297 and 229 with db transactions

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Nov 04, 2007 at 07:49 AM

    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

    Add comment
    10|10000 characters needed characters exceeded