N/APosted on - 10/07/2011
We are using LiteSpeed for our SQL Servers. While I was installing one, I got this error message (see below).
I have tried uninstalling and installing LiteSpeed but I still got the same error message. Is there something wrong with the SQL software?
Please help and advise on what to do. Thanks.
LiteSpeed @ for SQL Server
Error 2203. Database:
Database file. System error – 2147024629
LiteSpeed for SQL Server error 2147024629
This error is usually caused by or related to the temp environment variable being unusable, bad, or missing. Most likely, there is nothing wrong with the SQL software. This can be remedied by adjusting the “Temp” and “Tmp Environment” variables. Usually they need to be adjusted from their default values. The solution involves checking the environment variable “Temp” and, if it is missing, create “Temp.” Then, if the referenced to directory is missing or unusable, create it or change the value of the “Environment” variable.
Start and then stop the Windows Installer
Adjust the variables by going to My Computer (right click) then Properties, select the Advanced tab, then select Environment variables.
Under User Variables for Administrator change the Temp name and value to TEMP, %USERPROFILE%Local SettingsTemp
Under User Variables for Administrator change the Tmp name and value to TMP, %USERPROFILE%Local SettingsTemp
I hope this helps! Good luck!