ADMIN user

  2. Home
  4. Docs
  6. ADMIN user
  8. SetUp
  10. Report Server
  12. Internet Information Server (IIS)
  14. Internet Information Server (IIS) on Shared Hosting

Internet Information Server (IIS) on Shared Hosting

  • 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 XLReport by connecting to it.