 | Backup and restore the database from a command prompt |  |
 |
You can use the following command to backup the TSC2 Help Desk database from a command prompt. You must run this on the computer running the SQL Server Desktop Engine. OSQL /Q"BACKUP DATABASE TSC2 TO DISK='C:\TSC2 |
|
|
| Error 1005 when running date based reports | |
| ProblemThe following error occurs when running date based reports on workstations with a default language settings other than US (English)
Error Number : 1005 Description : Can't op |
|
|
| Cannot connect to SQL Server after installing Windows XP Service Pack 2 on the server | |
| Windows XP Service Pack 2 (SP2) includes a new component, Windows Firewall. The default settings of Windows Firewall prevents other computers from connecting to services on the Windows XP computer, including the SQL Server service.
|
|
|
| Login Failed - Not associated with a trusted SQL Server connection |  |
| This error will occur if the Microsoft SQL Server Desktop Engine (MSDE) is set to Windows only authentication mode.
The TSC2 Help Desk edition of the SQL Server Desktop Engine automatically sets the authentication mode to Mixed during the |
|
|
| SQL Server Desktop Engine Install Error: InstallSQLAgentSecurity failed | |
| If you try to install Microsoft SQL Server 2000 Desktop Engine (also known as MSDE 2000) on a computer that does not have the Server service running, MSDE 2000 may not successfully install. If you specify a verbose log file for the setup, the followi |
|
|
| Installing SQL Server SP3a | |
| To determine if you need to install SQL Server SP3a, run the Server Console and check the SQL Server version. If the version is 8.00.760 then SP3a is already installed, if it is lower than this version you should install SP3a.
Det |
|
|
| Server Console Run-time error | |
|
A run-time error can occur within the Server Console if the SQL Server component SQLDMO.DLL is not properly registered. The run-time error can occuring while performing tasks such as rebuilding the index, shrinking the database or pe |
|
|
| Moving the TSC2 Help Desk database to a different folder (or drive) on the same server | |
| These steps will move the TSC2 Help Desk database file to a different folder (or drive) on the same computer.
Please backup your TSC2 Help Desk database before performing these steps.
Make |
|
|
| Moving the TSC2 Help Desk database to new server | |
|
Moving the TSC2 Help Desk database to another server.
|
|
|
| SendMail Error: There is no Recipient. (verify the address list) | |
|
This error can occur after updating the TSC2 Help Desk database to version 5. To fix the error please upgrade to the latest version of the Web Interface.
You can download the latest Web Interface update from |
|
|
| How to uninstall the trial version of TSC2 Help Desk | |
| Uninstalling the TSC2 Help Desk client software:
Open the Control Panel (Start->Settings-Control Panel)
Double click the Add/Remove Programs icon.
|
|
|
| Troubleshooting SQL Server Desktop Engine installation errors | |
| If the setup fails, locate the MSDE_Setup.log file, and then search for any existence of "return value 3". A "return value 3" is the fatal error value that returns for an action. Based on the failed action, you can continue to determine the reason wh |
|
|
| SQL Server Desktop Engine fails - PerfmonLoad routine returned error code 6 | |
| ProblemThe installation of Microsoft SQL Server Desktop Engine failed. A search of C:\MSDE_Setup.log reveals the following error.
PerfmonLoad routine returned error code 6 |
|
|
| Error: Failed to send email notification | |
| Problem:
The following error occurs when TSC2 Help Desk attempts to send email notifications:
Failed to send email notification
Network connection aborted by local host
&n |
|
|
| ActiveX Error 429 when TSC2 Help Desk client starts | |
|
This error occurs as soon as the client software is launched it may be due to a corrupt MDAC (Microsoft Data Access Component) installation.
Repairing MDAC on Windows XP SP2
T |
|
|
| Login failed ... not associated with a trusted SQL server connection | |
| This error can occur if Mixed Mode Authentication was not enabled during the installation of SQL Server.
To enable Mix Mode authentication:
1. In the SQL Server Enterprise Manager right click |
|
|
| Login failed ... not associated with a trusted SQL server connection | |
| This error can occur if Mixed Mode Authentication was not enabled during the installation of SQL Server.
To enable Mix Mode authentication:
1. In the SQL Server Enterprise Manager right click |
|
|
| How to troubleshoot connectivity issues in SQL Server 2000 | |
| For assistance in troubleshooting SQL Server connectivity issues please visit the Microsoft Knowledge Base article How to troubleshoot connectivity issues in SQL Server 2000 at the link listed below.
|
|
|
| SQL Server is unavailable or access is denied | |
| If you receive this error and you are sure the SQL Server is running you should ensure that TCP/IP is enabled in the SQL Server Network Configuration.
1. In the SQL Server Enterprise Manager right click on the |
|
|
| Access Denied running SQL Server 2000 on Windows Server 2003 | |
| There is a known issue when connecting to SQL Server 2000 SP2 or earlier via TCP/IP on Windows Server 2003. The link below to the Microsoft Knowledgebase details the problem and resolution (installing SP3 for SQL Server).
|
|
|
| Upgrading TSC2 Help Desk | |
| TSC2 Help Desk Version Numbers
TSC2 Help Desk is comprised of a number of different components, each with it’s own version number based on the component’s latest release. When referring to the TSC2 Help Desk software p |
|
|
| This installation package could not be opened | |
| When installing the Microsoft SQL Server Desktop Engine (MSDE) you receive the following error:
This installation package could not be opened. Verify that the package exists and that you can access it or contact the application vendor to verify that thi |
|
|
| Failed to activate control ''. This control may be incompatible with your application. | |
| After upgrading or installing the TSC2 Help Desk client version 4.1.46 you may receive the following error when opening the schedule window.
Error Number : 374
Description : Failed to activate control ''. This control may be
incompatible with your applic |
|
|
| How to install a default instance of MSDE | |
| TSC2 Help Desk will connect to the default instance of MSDE, it cannot use a named instance. If you want to use an existing installation of MSDE that was installed with a named instance (no default) you will need to manually run the MSDE setup program to |
|
|
| aspSmartUpload Error CreateObject Failed | |
| The error specifically means that the IIS cannot create the aspSmartUpload object, this is usually due to a permissions issue and usually occurs with Windows Server 2003, though it can occur on other Windows version.
A few things to try...
* Uninstall a |
|
|
| SQL Server Instances | |
| Q. How many instances of SQL Server 2000 can be installed on a computer?
A: The maximum number of instances supported in SQL Server 2000 is 16. The number of instances that can run on a single computer depends on available resources.
Q. What are default |
|
|
| How to import Active Directory users | |
| Using the Microsoft export utility CSVDE you can export your Active Directory users to a comma delimited file. Once you have this file you can import it using our user import utility. Be sure to read the help file that accompanies the user import utili |
|
|
| SQL Server installation fails when SA password contains a space | |
| The TSC2 Help Desk setup program that installed the SQL Server Desktop Engine (MSDE) will fail if the password assigned to the SA account during the setup includes a space. This is due to the way in which the setup program hands the assigned password t |
|
|
| How to setup SQL Server 2005 Express for use with TSC2 Help Desk | |
|
To use Microsoft SQL Server 2005 Express with TSC2 Help Desk 4 you need to perform the following steps. These steps will only work when installing a new database.Configuring SQL Server 2005 Express |
|
|
| Access violation error on Windows Server 2008 | |
| ProblemWhen running the TSC2 Help Desk client on Windows Server 2008 an Access Violation Error occurs and the program shuts down.SolutionDisable DEP (D |
|
|
| STDOLE2.TLB error during install on Windows Vista | |
|
ProblemWhen installing TSC2 Help Desk on Windows Vista you receive the error "Unable to register the library type: RegisterTypeLib Failed; code 0x8002801C. Error accessing the OLE registry." for th |
|
|
