Issue SafeGuard LAN Crypt Administration returns the error:
Could not find server 'Servername' in sysservers. Execute spaddlinkedserver to add the server to sysservers.
SafeGuard LAN Crypt Administration version 3.51
Windows XP SP2 Professional Edition
What to do
Run the following SQL statements:
select @@servername in this case "servername" is not a variable and the command should be typed as shown.
- When the incorrect entry is found, i.e. wrong/former server name, run the following commands:
sp_dropserver 'incorrect Servername' in this case 'incorrect servername' means the name of the server which was displayed after typing the above command
sp_addserver 'valid Servername\SQLServer', local in this case 'valid Servername\SQLServer' means the name of the server which is shown in the initial error message
- Restart the SQL Server.