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 set up additional logins for my MS SQL database?
Viewed 3343 times since Mon, Apr 30, 2012
How can I change my SQL Server collation name?
Viewed 3814 times since Mon, May 21, 2012
Do you support MS SQL WebAdmin access?
Viewed 5920 times since Tue, May 1, 2012
About Azure Key Vault
Viewed 2150 times since Mon, Nov 2, 2020
Do you support MySQL WebAdmin Access?
Viewed 3579 times since Tue, May 1, 2012
Have you supported Crystal Report for VS 2010 (v13)?
Viewed 3212 times since Tue, May 1, 2012
I cannot login to my MS SQL database remotely. What did I do wrong?
Viewed 6890 times since Mon, May 7, 2012