NOTICE: Our Community is moving. Get more information. Updated information on a New Login Process
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.
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 @@servernameThe servername should be not NULL select * from sysserversThe “srvname” field must correspond to your server name exec sp_helpserverThe "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 Serverexec sp_dropserver '<servername>': To drop the old SQL Servernameexec sp_addserver '<servername>', local: To add the new name as the local serverexec 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.