LiteSpeed for SQL Server error 2147024629

Asked By Robby V 0 points N/A Posted on - 10/07/2011

Hi,

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:

                   C:WINDOWSInstaller3256c2a3.ipi.Cannot open

                   Database file. System error – 2147024629

 

• Status: Open
• Question Views: 1272
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Server Software

Answered By jmarcatch 0 points N/A #88565

LiteSpeed for SQL Server error 2147024629

Robby V,

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.

Solution recommended:

1. Start and then stop the Windows Installer
2. Adjust the variables by going to My Computer (right click) then Properties, select the Advanced tab, then select Environment variables.
3. Under User Variables for Administrator change the Temp name and value to TEMP, %USERPROFILE%Local SettingsTemp
4. Under User Variables for Administrator change the Tmp name and value to TMP, %USERPROFILE%Local SettingsTemp

I hope this helps! Good luck!

About jmarcatch

Questions
0

Answers
6

Best Answers
2

• Vote Up 0 Vote Down

• Posted on - 10/11/2011
• Question Category: Server Software