Configuring loopback proxy server for 15.0.1 ESD #2 and earlier

Adaptive Server version 15.0.1 ESD #2 and earlier requires that a server named “loopback” be included in sysservers before you run the installmontables script. To create this server, enter:

declare @servernetname varchar(30)
select @servernetname=srvnetname
from master..sysservers
where srvname=@@servername
exec sp_addserver loopback, NULL, @servernetname

@@servername cannot be NULL. If it currently is NULL, use sp_addserver to define a “local” server name. Restart the server for the change to @@servername to take effect.