none
Reporting

    Întrebare

  • I have Azure sql database and a SSRS configured on Vm i want my Azure db source to connect to my SSRS,but i am getting error
    luni, 11 iunie 2018 10:25

Toate mesajele

  • System.Data.SqlClient.SqlException: Keyword or statement option 'RECOVERY' is not supported in this version of SQL Server. at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async) at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe) at System.Data.SqlClient.SqlCommand.ExecuteNonQuery() at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(SqlConnection conn, String script, ICommandWrapperFactory commandWrapper) at Microsoft.ReportingServices.Common.DBUtils.ApplyScript(String connectionString, String script) at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script)
    luni, 11 iunie 2018 10:42
  • I am getting this error
    luni, 11 iunie 2018 10:42
  • Hello,

    Azure SQL Database always use recovery model full and that cannot be changed to Simple recovery model.


    Hope this helps.


    Regards,

    Alberto Morillo
    SQLCoffee.com


    luni, 11 iunie 2018 12:49
  • Hi,

        But what can be alternative to configure my datasource as azure paas db to my SSRS (native) installed on a VM.

    Please provide a step by step documentation if available

    miercuri, 13 iunie 2018 06:39
  • Hi Sonalgaik,

    I am providing the following Stack Overflow thread that discusses this topic:

    How to setup SSRS with an Azure SQL Server Database

    Regards,

    Mike

    joi, 14 iunie 2018 17:50
    Moderator