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.