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
Do you support SQL 2012?
Viewed 3134 times since Fri, May 4, 2012
Do I need a static IP?
Viewed 4587 times since Mon, May 7, 2012
Monitoring Tools For Windows
Viewed 518 times since Wed, Jul 13, 2022
Do you support SQL Server Integration Service?
Viewed 2618 times since Tue, May 1, 2012
I cannot login to my MS SQL database remotely. What did I do wrong?
Viewed 6166 times since Mon, May 7, 2012
I forgot my Help Desk Account password. What should I do?
Viewed 6808 times since Mon, May 7, 2012
Will my Crystal Report XI (Crystal Report 11) work on your server?
Viewed 2409 times since Tue, May 1, 2012
Do you support MS SQL WebAdmin access?
Viewed 5287 times since Tue, May 1, 2012