Post reply

RS subscription problem

  • November 13, 2011 at 1:31 am

    #262657

    hello all

    we have a problem with our RS 2005, this server send the next error when we want configure subscription on step 3 with controler data, we need reports for email,

    only we moved server out of offices to another site, someone have any idea to what happen?

    thanks

    Is urgent fix this issue, I put sysadmin priviliges to the user that with use to connect with de server where the data are, I put the messege on Englis

    THANKS

    Step 3 - Create a data-driven subscription: Tubo de Ventas

    Specify a command or query that returns a list of recipients and optionally returns fields used to vary delivery settings and report parameter values for each recipient:

    exec [dbo].[EmailDistributionList]1,15,1

    The delivery extension settings and report parameter values can use field values returned by the command or query. If there are field values that map to these settings, include the fields in your command or query.

    The delivery extension has the following settings: TO, CC, BCC, ReplyTo, IncludeReport, RenderFormat, Priority, Subject, Comment, IncludeLink, SendEmailToUserAlias

    The report takes the following parameters: FechaIni, iRegion, sDistribuidor, sSucursal, Ayer, Antier, SemActIni, SemAntIni, SemAntFin, Period, MesActIni, MesActFin, MesAntIni, MesAntFin

    Specify a time-out for this command: seconds Please specify a valid timeout.

    Please specify a valid timeout.

    Verify that the command is correct for the selected data source:

    The dataset cannot be generated. An error occurred while connecting to a data source, or the query is not valid for the data source. (rsCannotPrepareQuery) Get Online Help Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

    Angel Miranda Nieto
    DBA Specialist, BI, MCSA SQL Server

  • December 5, 2011 at 9:39 am

    #1416798

    our problem was fix, the subscription was that the destination server has a problem with the user account, thanks to all.

    Angel Miranda Nieto
    DBA Specialist, BI, MCSA SQL Server

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply