The following error occurs when sp_webservices ‘add’ is executed:
Msg 5629, Level 16, State 1: Line 1: Cannot start a remote distributed transaction participant as the local server is not named. Please contact a user with System Administrator role.
You must have an entry for your Adaptive Server Enterprise in the sysattributes table. To provide an entry, use the sp_addserver stored procedure:
sp_addserver ase_entry, local, ase_entry
where ase_entry is the local name for your Adaptive Server Enterprise from your interfaces or sql.ini file. Then, restart Adaptive Server Enterprise.
