Problem:
The following error message has been reported by a number of users running SilkTest Workbench 13.5 with SQL Server 2005 Database. The error tends to occur when launching or closing the Silk Test Workbench, or some individual Test Assets.
Resolution:
Internal investigation has confirmed that the error can occur if a SQL Server installation was relocated to a different Server, or if the Server name has been modified after deployment. The following SQL queries can be executed to confirm if this is the root cause; the output should be identical in all cases:
select @@servername
The servername should be not NULL
select * from sysservers
The “srvname” field must correspond to your server name
exec sp_helpserver
The "name" field must correspond to your server name
If the first SQL query returns "null" or if the output for all 3 queries is not identical; then the following Stored Procedures will need to be executed to resolve the problem, per the advice in the following article:
https://support.actividentity.com/LiveTime/WebObjects/LiveTime.woa/wa/ArticleView?kbaId=1622
exec sp_helpserver: To get the current name of the SQL Server
exec sp_dropserver '<servername>': To drop the old SQL Servername
exec sp_addserver '<servername>', local: To add the new name as the local server
exec sp_serveroption '<servername>', 'Data Access', 'True': Configures server for Data Access
Please note that you must stop and then restart the SQL Server server for the changes to take effect. After restarting the Service; please run "select @@servername" to verify that the changes have been applied. This should return the name of your local server with a server id of 0.
