sysattributes table entry

Issue

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.

User action

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.