SafeGuard LAN Crypt Administration: Error 'Could not find server 'Servername' in sys.server.....'

  • Article ID: 108224
  • Updated: 02 Sep 2015

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

Client OS
All supported operating systems

What to do

Run the following SQL statements:

  1. select @@servername in this case "servername" is not a variable and the command should be typed as shown.
  2. When the incorrect entry is found, i.e.  wrong/former server name, run the following commands:
    1. sp_dropserver 'incorrect Servername' in this case 'incorrect servername' means the name of the server which was displayed after typing the above command
    2. go
    3. 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
    4. Restart the SQL Server.

    If you need more information or guidance, then please contact technical support.

    Rate this article

    Very poor Excellent