SAP Knowledge Base Article - Preview

1957014 - DUMP TRANSACTION fails with error 7227: "Can't open a connection ... because ASE is not configured for remote access" - SAP ASE

Symptom

  • Any attempt to execute DUMP DATABASE or DUMP TRANSACTION, even solely on the local server, fails with ASE errors 7227 and 3220

1> dump database model to '/tmp/model.dmp'
2> go

Msg 7227, Level 17, State 4:
Server 'SYBASE', Line 1:
Can't open a connection to site 'SYB_BACKUP' because ASE is not configured for remote access. Ask a user with System Administrator (SA) role to reconfigure ASE to allow remote access.
Msg 3220, Level 17, State 5:
Server 'SYBASE', Line 1:
Could not establish communication with Backup Server 'SYB_BACKUP'. Please make sure that there is an entry in Sysservers for this server, and that the correct server is running.

  • Execution of sp_configure "allow remote access"  shows the following:

1> sp_configure 'allow remote access'
2> go
 Parameter Name                 Default     Memory Used
         Config Value                                                                                                                                                                                                                          
         Run Value                                                                                                                                                                                                                             
         Unit                 Type
 ------------------------------ ----------- -----------
         ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
         ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
         -------------------- --------------------
 allow remote access                      1           0
                    0                                                                                                                                                                                                                          
                    0                                                                                                                                                                                                                          
         switch               dynamic


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) all versions

Product

SAP Adaptive Server Enterprise all versions ; Sybase Adaptive Server Enterprise all versions

Keywords

database, remote, tran , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.