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
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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview