Internet Information Server (IIS) on Shared Hosting

DBxtra can be used in a shared hosting environment.

The shared Server requires support for “ASP.NET 4.5” or newer.

Configure your Report Server:

• Create a new Application Pool giving it a meaningful name, be sure that it uses the .NET Framework v4.0 and that it uses a Classic pipeline.
• Create a new Application or Virtual Directory and give it a meaningful alias, then assign it the application pool you created previously.
• Upload the Report Web Service files to your web site’s root or the directory of the Application or Virtual Directory you created. These are in the Report Web Service folder in DBxtra’s installation directory (C:\Program Files\DBxtra .NET by default), you can use FTP for that.
• Upload your Report Repository and the schedule history files (DBxtraDB.sdf and DBxtraScheduleHistoryDB.sdf) to your web site’s root or the directory of the Application or Virtual Directory you created. These are in the repository folder.
• Locate the folder where the SQL Server Compact private deployment libraries is located (C:\Program Files\Microsoft SQL Server Compact Edition\v4.0\Private) by default).
• Copy the contents of this folder into the bin folder of your Report Web Service in your web site; you should replace one file.
• Modify your web.config file and add the following lines anywhere inside the <configuration></configuration> tags to register SQL Server Compact:

<system.data>
<DbProviderFactories>
<remove invariant="System.Data.SqlServerCe.4.0"/>
<add name="Microsoft SQL Server Compact Data Provider 4.0" invariant="System.Data.SqlServerCe.4.0" description=".NET Framework Data Provider for Microsoft SQL Server Compact" Type="System.Data.SqlServerCe.SqlCeProviderFactory, System.Data.SqlServerCe, Version=4.0.0.1, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/>
</DbProviderFactories>
</system.data>
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name="System.Data.SqlServerCe" publicKeyToken="89845dcd8080cc91" culture="neutral"/>
<bindingRedirect oldVersion="0.0.0.0-65535.65535.65535.65535" newVersion="4.0.0.1"/>
</dependentAssembly>
</assemblyBinding>
</runtime>

• Once you have done so, you can test your configuration by going to the address of the Web site you used in the configuration. For example, if the web site is configured to use port 800, and you use the Alias “Reports”, then the address of the Report Server and the Report Web Service will be http://MySharedServer.com:800/Reports.
• If the configuration is correct and you can see the Report Web Service interface and be able to log in using your credentials, then you can use this Report Server in DBxtra by connecting to it.