Symptom
One or both of the following errors may occur in System Administration when modifying or deleting system data.
"Cannot find server 'servername' in sysservers."
"Server 'servername' is not configured for DATA ACCESS."
Resolution
1) In SQL Server Management Studio, expand Databases.
2) Right-click on AccessControl and select New Query.
3) In the query window, type select @@servername and press <F5> to execute. Executing this query returns the name of the local server that is running SQL Server.
4) Type sp_dropserver 'servername' and press <F5> to execute. This will remove the existing name of the local server that is running SQL Server.
5) Type sp_addserver 'newservername', 'local' and press <F5> to execute. This will add the new, correct name of the local server that is running SQL Server.
6) Restart the SQL Server services.
7) Repeat steps 1-3. The new server name entered in step 5 should be returned.
