sanjays
Posts: 13
Joined: Mon Dec 10, 2018 2:09 pm

"{SQL_ERROR}: {SQL_STATE: 42000} Cannot create file

Hi team,

Following issue we are facing when uninstalling the application and sql server from machine and again installing the application to the system.

Its shows pop up "{SQL_ERROR}: {SQL_STATE: 42000} Cannot create file 'C:\Program Files\Microsoft SQL Server\MSSQL11.INTELLISYS\MSSQL\DATA\ConsoleDB.mdf' because it already exists. Change the file path or the file name, and retry the operation.".

Regards.
Sanjay
Attachments
SQL Error.png
SQL Error.png (32.39 KiB) Viewed 1945 times
IntellisysLite_A.7z
(116.06 KiB) Downloaded 216 times
Daniel
Posts: 8238
Joined: Mon Apr 02, 2012 1:11 pm
Contact: Website

Re: "{SQL_ERROR}: {SQL_STATE: 42000} Cannot create file

Hello,

This could happen if you create the related "ConsoleDB.mdf" database file during setup installation or within your application after the installation is finished, but you do not remove it on your setup uninstall operation.

To do so you could use our "File Removal" support to configure a "ConsoleDB.mdf" file removal on uninstall.

If this is still of no help, maybe you can try to isolate the behavior in a buildable sample (.aip + its referenced files) which we can build and test on our side.

All the best,
Daniel
Daniel Radu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube

Return to “Common Problems”