This is a very common error code, the actual cause can only be determined by checking the Windows Event viewer. The normal cause within Scores Manager is when the application is unable to communicate with the SQL Server storing the application data. This can be confirmed in the Event Viewer, the error message will be "SQL Server does not exist or access denied".
If the error message is "SQL Server does not exist or access denied", it
does not mean any of the following:
- That the logon process to SQL Server failed.
- That SQL Server does not have the correct permissions to process the query.
- That you cannot use SQL Server authentication because only Windows authentication is permitted.
The most likely causes are:
Cause: The SQL Server containing the application data is not running.
Remedy: Check the SQL Server is running, and restart start it if required.
Cause: The SQL Server cannot be contacted on the network.
Remedy: Test the connection by using the Windows command line utility to PING the SQL Server name and IP address. If the IP address can be ping'd, but the name cannot, check them name resolution service on the network. If neither can be ping'd, investigate the computer network for faults.
Cause: The Scores Manager database has not yet been installed. (New installations only.)
Remedy: Use the Scores Manager SQL Utility to install a new database.
Cause: The Scores Manager registry setting is incorrect.
Remedy: Scores Manager stores the address of the SQL Server in the Windows Registry. The address is stored in value, HKLM\Software\Little Fish Technologies\Scores Manager\Settings\SQLServer. The value should be either the NETBIOS name of the SQL Server instance, or the IP Address.
For other possible reasons for this error code please refer to the Microsoft Knowledge Base article http://support.microsoft.com/kb/328306.
Article ID: 6, Created On: 11/18/2009, Modified: 11/18/2009