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

  • ID dell'articolo: 108224
  • Aggiornato: 01 ago 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.

     
    Per maggiori informazioni o per assistenza, vi preghiamo di contattare il supporto tecnico.

    Valutate l'articolo

    Molto scadente Eccellente

    Commenti