Home » Categories » Multiple Categories

I receive this error message: "Unknown file type (binary data)" when trying to deploy my SQL CE database. What did I do wrong?

If you receive this error message, please try adding the following line to your web.config file:

<identity impersonate="true" userName="XXXXXXXXX" password="XXXXXX" />

This line should be added inside the tag <system.web> </system.web>. Username and password can be your login credentials for the system.

Therefore, the following is the whole web.config-content with which everything works:

<?xml version="1.0" encoding="UTF-8"?>
     <configuration>
          <system.data>
                 <DbProviderFactories>
                          <remove invariant="System.Data.SqlServerCe.4.0" />
                          <add invariant="System.Data.SqlServerCe.4.0" name="Microsoft® SQL Server® Compact 4.0" description=".NET Framework Data Provider for Microsoft SQL Server Compact" type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=4.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91" />
                 </DbProviderFactories>
          </system.data>
       <system.web>
           <identity impersonate="true" userName="???" password="???" />
       </system.web>
</configuration>

Please note that our Control Panel does not really accept the .cshtml-files (webpages) and the .sdf-file (database) and you will always see the error message: "Unknown file type (binary data)". However, please just ignore the error message and by following the above guideline, everything will work as expected.



 

Attachments Attachments
There are no attachments for this article.
Related Articles RSS Feed
Can i login to my MySQL database via my own mySQL tool?
Viewed 2950 times since Mon, May 7, 2012
I forgot my Help Desk Account password. What should I do?
Viewed 7048 times since Mon, May 7, 2012
Do you support SQL 2014?
Viewed 3363 times since Tue, Feb 3, 2015
Do you support SQL Server Integration Service?
Viewed 2856 times since Tue, May 1, 2012
Common reasons why your application pool may unexpectedly recycle
Viewed 8386 times since Tue, May 15, 2012
Do you support SQL Reporting Service (SSRS)?
Viewed 4023 times since Tue, May 1, 2012
I cannot find any article on this Knowledge Base that can solve my issues. What should I do?
Viewed 4106 times since Mon, Apr 30, 2012