MS SQL Server :: SQL 2005 SP2 Subscriptions Error

Impersonation Error With File Share Subscriptions In RS 2005

Apr 9, 2008

When publishing to a file share using Reporting Services (no service pack 2 yet) the following error occurs:

Failure writing file NewFile.mhtml : An impersonation error occurred using the security context of the current user.

I have tried publishing to both Windows XP and Server 2000.
The Reporting Services box is Server 2003.
Publishing account is Local Administrator on both Reporting Services and target boxes.
Logon Locally has been granted on both Reporting Services and target boxes.

Any thoughts?

View 7 Replies View Related

One Or More Subscriptions Have Been Marked Inactive. Drop And Re-create All Subscriptions For This Node...

May 16, 2007

Greetings,

We periodically get the following message in our three server peer-to-peer transactional replication environment:

"One or more subscriptions have been marked inactive. Drop and re-create all subscriptions for this node that are failing with this error."

What causes a subscription to be marked inactive? What properties or settings can be adjusted to minimize or eliminate this occurrence?

Everthing seems to be running OK and then we get the message. It afflicts the higest change volume publication on our slowest overseas server.

Thanks,

BCB

View 9 Replies View Related

Email Subscriptions: Changing From Address For Different Subscriptions On Same Server

Jan 18, 2007

I doubt this is possible, but can someone think of a way to change the email address used for sending report subscriptions based on the report or subscription?

It's a need that I've heard from a number of different clients. Scenario: a company has one reporting services server with reports running from numerous departments. Report subscriptions are sent to internal and external email addresses and there's a business need to use different "from" addresses based on the report (or audience).

View 1 Replies View Related

SQL Server 2005 In Subscriptions

Jun 20, 2006

Does SQL Server 2005 come in any MSDN subscription packs? The content list isn't generally comprehensive and all the subscriptions seem to come with SQL Server 2000.

View 1 Replies View Related

SSRS 2005 And Email Subscriptions - HELP

Mar 24, 2006

Hi All -

Having a problem with email subscriptions in SSRS 2005 running on Win2003 server. The email subscription is attempting to email an excell attachment of the report. The report uses a shared data source with stored credentials. Configured email in Reporting Services config manager to use SMTP server OurServer.OurDomain.com Even wrote a test vb.net program to send email using that SMTP server and was successful - yet Reporting Services subscription fails with following error:

Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.

Combed the Reporting Services error logs but found nothing pertaing to email - SMTP - Subscriptions or anything close - I'm stuck but we really need this as I am emailing 3 reports daily by the manual process of running the reports - exporting to excell - and emailing - UHG!!

Any help appreciated - Thanks

View 8 Replies View Related

What Is The Maximum Number Of Sched Subscriptions In RS 2005?

May 5, 2008

hi,

is there a limit for number of Subscriptions per report? per folder? per RS 2005 service?

thanks

rafi

View 1 Replies View Related

Transactional Publication With Updatable Subscriptions In SQL Server 2005, SvPk 2

Jul 31, 2007

Subscription to "Transactional Publication with Updateable Subscriptions" works only one way. Changes take effect on subscriber, but the subcriber is unable to update data on publisher.

I have Sanpshot Agent process running under SQL Server Agent service account with login 'sa.' All agents are running at the Distributor (Publishing Server.)

The subscriber is unable to connect to the Distributor using the SQL Server login.

Following is the error message I get:

Creating Subscription(s)...

- Creating subscription for 'SQL3' (Warning)

Messages

Unable to set the Publisher login for the updatable subscription. You may have to set this up directly on the Subscriber machine using sp_link_publication. (New Subscription Wizard)

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

MSDTC on server 'SQL3' is unavailable.
Changed database context to 'DB_SQL1_to_SQL3_on_3'. (Microsoft SQL Server, Error: 8501)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3054&EvtSrc=MSSQLServer&EvtID=8501&LinkId=20476

Please suggest procedure to end this dilemma. The link has no info available.

View 2 Replies View Related

Data Driven Subscriptions - E-mail Distribution (SSRS 2005)

Jan 30, 2008

Hello folks,

Does anybody have experience with e-mail distribution using Data Driven Subscriptions?
I want to build the following:

I have a table with names and e-mail addresses of people in my data warehouse. This table changes over time, more people will be added and data (for example e-mail addresses) can change.
I made 1 report that I want to mail to all the people in the table. This report contains 1 parameter; the e-mail address of a person.
So basically it��s quite simple: I want to e-mail all the people in the table a personalized (by the parameter) report each month.

Can anybody tell me how I can achieve this with SSRS 2005(SSEE)? I know how to make a data driven subscription but how can I make one pending on the data in a table?

Any help would be appreciated. I will write a blog about this when I've done it so your input will not get lost.

Jorg

View 1 Replies View Related

SSRS 2005 - Migrating SSRS Subscriptions

Oct 25, 2007

Hi,
We are in need of migrating SSRS subscriptions along with the reports. Could you please let me know the process ?

I really appreciate your help on this.

Thanks,
Sam

View 6 Replies View Related

SQL Server 2005 Install Error (Error 29528. Unexpected Error While Installing Performance Counters. )

Jun 12, 2007

I'm currently receiving the following error message whilst attempting to install SQL Server 2005 Standard Edition on Windows Server 2003 (32 Bit):
Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.

This server already has an install of SQL Server 2000 as the default instance. I'm attempting to install a new named instance of SQL Server 2005.

Extract from log:

<Func Name='LaunchFunction'>
Function=Do_sqlPerfmon2
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlPerfmon2
PerfTime Start: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
<Func Name='Do_sqlPerfmon2'>
<EndFunc Name='Do_sqlPerfmon2' Return='0' GetLastError='2'>
PerfTime Stop: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
MSI (s) (4C:FC) [10:20:02:833]: Executing op: ActionStart(Name=Rollback_Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Removing performance counters,)
<EndFunc Name='LaunchFunction' Return='0' GetLastError='0'>
MSI (s) (4C:FC) [10:20:02:849]: Executing op: CustomActionSchedule(Action=Rollback_Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1281,Source=BinaryData,Target=Rollback_Do_sqlPerfmon2,CustomActionData=100Removing performance counters200000DTSPipelineC:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.INI)
MSI (s) (4C:FC) [10:20:02:849]: Executing op: ActionStart(Name=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,Description=Installing performance counters,)
MSI (s) (4C:FC) [10:20:02:849]: Executing op: CustomActionSchedule(Action=Do_sqlPerfmon2.D20239D7_E87C_40C9_9837_E70B8D4882C2,ActionType=1025,Source=BinaryData,Target=Do_sqlPerfmon2,CustomActionData=100Installing performance counters200000C:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.INIC:Program FilesMicrosoft SQL Server90DTSBinnDTSPERF.HC:Program FilesMicrosoft SQL Server90DTSBinnDTSPipelinePerf.dllDTSPipeline0DTSPipelinePrfData_OpenPrfData_CollectPrfData_Close)
MSI (s) (4C:94) [10:20:02:864]: Invoking remote custom action. DLL: C:WINDOWSInstallerMSI1683.tmp, Entrypoint: Do_sqlPerfmon2
<Func Name='LaunchFunction'>
Function=Do_sqlPerfmon2
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlPerfmon2
PerfTime Start: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
<Func Name='Do_sqlPerfmon2'>
<EndFunc Name='Do_sqlPerfmon2' Return='2' GetLastError='2'>
PerfTime Stop: Do_sqlPerfmon2 : Tue Jun 12 10:20:02 2007
Gathering darwin properties for failure handling.
Error Code: 2
MSI (s) (4C!F0) [10:23:46:381]: Product: Microsoft SQL Server 2005 Integration Services -- Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.

You can ignore this and it will complete the installation, but subsequently trying to patch with SP2 will fail on the same sections - Hotfix.exe crashes whilst attempting to patch Database Services, Integration Services and Client Components (3 separate crashes).

I've removed SQL Server 2005 elements and tried to re-install, but it's not improved the situation.

Any ideas?

View 3 Replies View Related

Subscriptions

May 15, 2006

We are running Reporting Services on an Application server, side by side with a web application. The server exists outside our corporate domain due to the fact that our external vendors need access to the application (not the reports). Our web app uses a third party mail system to funnel the application email thru our corporate exchange server. Since Reporting Services is not connected to our domain, it can not authenticate to send reports via e-mail subscriptions. I am looking for alternatives to make this work from outside the domain.

View 7 Replies View Related

Subscriptions

Mar 13, 2007

Hi all,

I have created data drvien subscriptions in Report Manager (rs 2005). When the reports are run in Report Manager they give a status ie 5 processed of 5 Total-2 errors. Is it possible to find out what these errors are as no indication is given?

Thanks in advance

View 3 Replies View Related

Need Help With Subscriptions

Feb 1, 2008

We've got a lot of user subscriptions that need to be re-run (data was bad on the initial run). Is there anyway to do this programatically or behind the scenes? We're looking for a way to avoid going into each subscrption and re-running.

Thanks.

View 2 Replies View Related

Need To Reinitialize Subscriptions

Jun 7, 2015

I am getting continuous errors in publisher/distributor server

Background: Transactional replication (Push) with one publication (above 30 articles (tables)) and 1 subscriber. Publisher/Distributor is 2008r2 SP2 & Subscriber is 2008r2 sp1

Current Problem:

Repl-Distribution
Message
Replication-Replication Distribution Subsystem: agent PubServername-Production-ProductionReplication-Subscriberservername scheduled for retry (One of the replication job). Query timeout expired.

When I open the replication monitor..In the first tab it is showing performance excellent but when I double click on the publiscation, it is showing errors under distributor to subscriber tab and there are some undistributed commands 5873507, estimated time to apply these commands, based on last performance is 1:06:05:05

Question 1: Do I need to reinitialize the subscriptions? How to find out the problem what went wrong with replication

Question 2: If I want to do any schema changes @publisher do I need to stop the log reader agent and start after the deployment? In my case both publisher/distributor are on the same server (Transactional Replication)

View 0 Replies View Related

My Subscriptions Do Not Work

Jan 28, 2008

I subscribed to many topics in this site and I though I didn't receive any email when a topic I wrote was updated.

Shimi

View 1 Replies View Related

Subscriptions Not Working

Jul 23, 2005

HiWe are having major problems getting reporting services subscriptionsto work. We have the following setup:Windows 2K Server with Service Pack 4 InstalledSQL Server 2000 with Service Pack 3 InstalledSQL Server Reporting Services with Service Pack 1 Installed.Everytime the system tries to deliver a report via file share or email,we get the following error in Windows Events:The procedure entry point I_RPCExceptionFilter could not be located inthe dynamic link library RPCRT4.dll.We have tried re-installing Service Pack 4 and also re-installingreporting services on a new server to try and resolve the problem butencounter exactly the same issue.Any help on this would be hugely appreciated as we are coming to theend of our ideas!!Thanks very muchDave

View 1 Replies View Related

Subscriptions Feature Not Available

Aug 23, 2007

I just installed SQLExpress, with reporting services on my own laptop

However, when I go to http://localhost/Reports/, I can see my reports uploaded, but the subscription links are not available. In Properties, I cannot see "Execution" either.

Can someone help me to get the Subscriptions feature enable again?

Thanks,

John W

View 1 Replies View Related

No New Subscriptions Are Working

Sep 18, 2007

Attempting to run any kind of subscription, we are receiving no error message, but not reports either

I think this maybe relatd to a system account used in setup being removed? does this sounds reasonable even though old subscriptions are stil working?

i have looked in the rsreportconfig file but the account is encrypted, how can i change this?

View 1 Replies View Related

Subscriptions Not Running

May 7, 2008

Hi,

I have generated a report and uploaded that report to reporting services. It works fine. I have created a subscription for the same report and scheduled the job to run the report. The report is not running.

I have tried the same report in different server and it works there.

I have sql server 2000 and sql server 2005 installed in the same server. I am using sql server 2000 reporting services but 2005 database. Will that creates a problem?

Can anyone please help me in this.

Thanks,
Priya

View 4 Replies View Related

Seeing ALL Subscriptions - INFO

Jan 24, 2008

Per BOL, I can assign the following task to a role, and if I give role to SSRS user, they can see ALL SUBSCRIPTIONS. If so, WHERE do they see the ALL SUBSCRIPTIONS? Will they show when selecting MY SUBSCRIPTIONS, or some other way?

{{Manage all subscriptions: View, modify, and delete any subscription regardless of who owns the subscription. }}

I am full rights admin on the box, and yet to find way to see ALL SUBSCRIPTIONS as well.

View 3 Replies View Related

Problem With Subscriptions

Feb 11, 2008

Hi,

I have a problem on Report Manager none of my subscriptions are triggered. They were working fine until Friday but none of them are fired today. I tested
writing to file share also but the subscription I created to write to file share was not fired. I checked with log files but could not find any errors regarding the subscriptions. Can you please help me on this?
Thanks in Advance.

View 2 Replies View Related

Testing Subscriptions

Nov 23, 2007

At the moment, the only way (that I know of) to test a subscription seems to be to schedule it a few minutes ahead in time and wait for it to happen. Dies nayone know if there are plans for and "Execute" or "tTst" button? It would be nice to have one.

View 1 Replies View Related

Subscriptions Tab Missing

May 14, 2008

Help! After searching through the forums and the web in general, I cannot find a reference to this problem. On a new SBS 2003 R2 server, with a clean install of SQL Server and reporting services, I have reporting working fine except that the reports have no Subscriptions tab visible. Also when I go to "Site Settings" and "Manage Shared Schedules", I get an error:

"The feature: "Scheduled report execution" is not supported in this edition of Reporting Services. (rsOperationNotSupported)

Interrogating the SQL Server, I find that the edition is reporting as Workgroup, which should have scheduled report execution.

Please help as this is a big problem for this server deployment.

Thanks

Shane Michelon

View 3 Replies View Related

CreateReportHistorySnapshot And Subscriptions

Jan 4, 2008

I am calling the CreateReportHistorySnapshot command to create my snapshot report of a linked report.

What is not happening is the subscriptions that I have made for the linked report is not firing off.

View 1 Replies View Related

How Do I Find All Subscriptions

Feb 12, 2007

Hi There

I need to get rid of all subscriptions (including cleaning up all associated sql jobs) for RS 2000 and 2005.

We have hundreds of reports , going through them 1 by 1 is not an option.

When i look at the system tables, i join Subscription to Catalog, but i find reports with subscriptions in the system tables but when i go to Report Manger there is no subscription for the report.

In a nutshell , how can i see all valid subscription for all reports in RS, how can i delete all of them and make sur eall sql jobs associated etc are deleted.???

Thanx

View 12 Replies View Related

Subscriptions To, CC, Bcc Fields

Apr 9, 2008

Where in the backend database can I find who a subscription was sent to? I know in the report server database the subscripitons table has a description and last status field, but these fields are cutting names off when the list is large. Is there any other place where this information is stored?

Nancy

View 3 Replies View Related

Can't Creat Subscriptions

May 11, 2006

We're new to SQL Reporting Services and have a new SQL 2005 server.

I'm having a problem activating scubscriptions.

- "New Subscription" is greyed out in Server Management Studio.

- Subscribing via the browser, even as the Content Manager, allows you to fill in the form for the subscription but then reports the following error;

"The current action cannot be completed because the user data source credentials that are required to execute this report are not stored in the report server database. (rsInvalidDataSourceCredentialSetting)"

Any suggestions?

Found the problem.

When configuring the Data Source the "Impersonate the authenticated user after a connection has been made to the data source" button should be off.

View 3 Replies View Related

Database Subscriptions

Sep 6, 2006

I'm working with SQL Server 2005 Developer Edition and am trying to set up a new subscription to a database I created using Management Studio. In the step where you are prompted to choose the Subscriber Type I only have two options: SQL Server 2000 and SQL Server CE.

Why don't I have the options to choose SQL Server 2005 and SQL Mobile 2005?

View 1 Replies View Related

Report Subscriptions

Apr 4, 2007

Hello,

I have a dril lthrough report which takes a long time (5-7 minutes) to fetch the results. The reason is that the data it returns is huge as it fetches sales data till the lowest level.

when the users later on trz to export it to excel it takes again a lot of time and eventuallz the szstem freezes. I think the volume of export might be in the range of 14/15 MB.

Is there a way to reduce first the execution speed of the report and then secondly reduce the time to export the report?

Or a way where the report is executed once a day and everyone shares the already published report?

regards

Josh

View 3 Replies View Related

Report Subscriptions Problem

Feb 12, 2008

Hi,

I'm trying to setup a subscription on a SSRS report and get the following error message:

An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help EXECUTE permission denied on object 'xp_sqlagent_notify', database 'mssqlsystemresource', schema 'sys'.

I've followed the advice given in this post but still get the same result.

The SQLAgent service is running under a domain account and the Reporting Services service running under a local account. Both these accounts are assigned to the RSExec Role in the master, msdb, ReportServer and ReportServerTempDB databases. This role has execute permissions set as per the above link.

I'm now at a loss as to what else the problem could be?

All ideas welcomed!

Steve.

View 1 Replies View Related

Dedicating CPU (Threads) For Subscriptions

Oct 10, 2007

We've invested ourselves heavily in subscription-based reporting where the SSRS service is responsible for rendering and delivering reports (to email, file shares, printers, document repositories, etc). We figured that this would be a model that would allow for easier scaling. Users submit their reports and allow SSRS to deliver them in due time. The biggest part of our reporting is now done via subscriptions.

However, adding long-running reports and short-running (but very critical) reports together to the same SSRS database has proven problematic. The long-running reports eventually make make the short reports starve for CPU time.

Does anyone know if there is a way to implement a CPU resource allocation strategy so that short running (but critical) reports will always have the ability to run? For example, it would be nice if certain user accounts or even report paths (RDL's) could have dedicated CPU resources (eg SSRS threads on which to run).

In other words, without creating additional ReportServer databases, I'd like a "pool" of threads for "severity 1" report subscriptions, a separate "pool" of threads for "severity 2" and so on. Then we'd be able to make sure that our critical subscriptions would get a chance to run. Sounds pretty straight-forward, right? Can't figure out how to go about this...

View 4 Replies View Related

Problem With Updatable Subscriptions

Nov 1, 2006

Hi all,

I have a problem with "Updatable Subscriptions" under concurrent transactions on both pub and sub effecting same data. At high level of concurrency it Subscriber starts giving error msg "Rows do not match between Publisher and Subscriber. Run the Distribution Agent to refresh rows at the Subscriber.".Please tell me any way arround for this.

View 4 Replies View Related