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

  • Article ID: 108224
  • Updated: 01 Aug 2011

Issue SafeGuard LAN Crypt Administration returns the error:

Could not find server 'Servername' in sysservers. Execute spaddlinkedserver to add the server to sysservers.

Product
SafeGuard LAN Crypt Administration version 3.51

Client OS
Windows XP SP2 Professional Edition


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

    Comments