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


ADVERTISEMENT

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

How To Creat A First DB?

Dec 3, 2006

Hello all,

I've Installed VS2005 and MSSQL express with it. I used to work with mssql 2003 enterprise edition where it had "Enterprise Manager" from which I could create and modify my Databases.

How do I creat a new database with MSSQL express?

I've tried to do this via visual studio 2005 "server explorer". I"m entering the "Create new SQL Server Database" dialog, I select my server's name and my new database name and I recive an error message which says "An error has occurred while estabilishing a connection to the server" and it also says that

"When connecting to SQL server 2005, this failure may be caused by the fact that under the defult settings SQL sever does not allow remote connections".

How do configure my MSSQL express to allow the remote connection?



Thanks in advance!

View 5 Replies View Related

How To Creat A DataBase?

Dec 1, 2007

I have a DataBase name Customer
Customer have 30 Tables name table1 �table2�table 3...
I want to have a DataBase name Customer_Offile with same Table same column like Customer ( the Customer_Offlike will used to a backup  DataBase)
How to wirte a script for copy Customer?
 thank you very much

View 3 Replies View Related

Creat A Table.

Jun 3, 2006

Kindly provide me the creat table querry for MS sql
its urgent.

Thank you!

View 1 Replies View Related

What If I Attempt To Creat A Publication While...

Apr 29, 2007

What if I attempt to creat a (merge) publication while the production sql server is online and active?



From another point of view, is there any drawback if I try to create (merge) publication while the tables are being used by users?





Thanks

Ekrem Önsoy

View 5 Replies View Related

Customising Creat User Wizard

Feb 23, 2008

Hello
This code was translated from c# but I keep getting this error.
 The variable name '@UserId' has already been declared. Variable names must be unique within a query batch or stored procedure
Any ideas I have tried changing the user id name but no luck. thanks
 
 Partial Class userInherits System.Web.UI.Page
 Protected Sub CreateUserWizard1_CreatedUser(ByVal sender As Object, ByVal e As System.EventArgs) Handles CreateUserWizard1.CreatedUser
Dim UserNameTextBox As TextBox
UserNameTextBox = CreateUserWizardStep2.ContentTemplateContainer.FindControl("UserName")Dim DataSource As SqlDataSource = CreateUserWizardStep2.ContentTemplateContainer.FindControl("InsertExtraInfo")
Dim user As MembershipUser = Membership.GetUser(UserNameTextBox.Text)Dim UserGUID As Object = user.ProviderUserKeyDataSource.InsertParameters.Add("UserId", UserGUID.ToString())
DataSource.Insert()
End Sub
End Class

View 4 Replies View Related

Any Available Solution Do Creat 3 Databases Correspondence?

Feb 19, 2007

Hi,

we have three dabases:

1. Two localDatabases in two offices, Main Office & Branch Office, each office in a diffrent city!!

2. One remoteDatabes exist in on the internet server.

all of it are with the same exact architecture, we are planning to upload and download to & from remoteDatabase to get the same data in all of them.

any available solution to do this with SQL Server 2005 ?

View 3 Replies View Related

Creat Indexed View Error

May 1, 2008

I am tryung to create a indexed view..

CREATE VIEW vwLookAdmissionRecord

WITH SCHEMABINDING

AS

select episode_key as episode_key, ee.object_key, ee.encounter_begin_dt , cp.procedure from dbo.encounters e

join (

select episode_key as minepisode, min(isnull(e.object_key,e.Object_key_History) ) as object_key, min(e.encounter_begin_dt)as encounter_begin_dt

from dbo.encounters e

join dbo.CD_Procedure CP on CP.Procedure_CD = e.procedure_cd
where cp.procedure > 0

group by e.episode_key

)ee on e.object_key = ee.object_key

join dbo.cd_procedure cp on cp.procedure_cd = e.procedure_cd





CREATE UNIQUE CLUSTERED INDEX IDX_V1

ON vwLookAdmissionRecord (episode_key)


but i keep getting an error:


annot create index on view "dbo.vwLookAdmissionRecord" because it references derived table "ee" (defined by SELECT statement in FROM clause). Consider removing the reference to the derived table or not indexing the view.



How can I fix this?

View 11 Replies View Related

How To Creat A Database Via SQL Querry Analyzer To A Web Server

Nov 20, 2003

I am new to ASP.NET and met a problem about access a database on a Web Server (www.myserver.com). My meaning here that I created a .sql from my localhost to test, but when to upload to my web server on the internet, an error occured: "System.Data.SqlClient.SqlException: SQL Server does not exist or access denied".
Anyone here can help me to solve my problem. Waiting for your reply soon. Thanks

View 2 Replies View Related

Cannot Creat Stored Procedure On Existing Database

May 15, 2008

Hi, I already got a database and I need to add another stored procedure on it in order to call it from the SSIS package.
But when I execute the sql file to create the procedure, there is a error message popping out like:

"Cannot add rows to sys.sql_dependencies for the stored procedure because it depends on the missing table 'logit'. The stored procedure will still be created; however, it cannot be successfully executed until the table exists."

And I have tried it on another computer, there is the same error. Could you please tell me how to solve the problem. Thanks very very much.

View 4 Replies View Related

How To Create Trigger Which CREAT TABLE From A Variable String?

Feb 23, 2006



I have a Table Name "Forums". I want to ceate an AFTER-Trigger on it. It will execute when ever a new row is inserted to "Froums" Table.

Here is what I did but It needs to be corrected:

::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

ALTER TRIGGER CreateTopicsTableTrigger

ON dbo.Forums

AFTER INSERT

AS

SET NOCOUNT OFF

DECLARE @myNewForum varchar

CAST(@@ROWCOUNT as varchar) /*Is it OK???*/

SET @myNewForum=@myNewForum+@@ROWCOUNT /*Here I dont know how assigments work in SQL*/

GO

CREATE Table @myNewForum /*Will this work some how???*/

( TopicID int IDENTITY NOT NULL, TopicTitle varchar(50) , CreatedBy varchar(50) ,

DateCreated DateTime , DateLastUpdate DateTime , LastUpdateBy varchar(50) )



::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::

View 5 Replies View Related

Creat Server Using Sql Server 2005

Jun 5, 2006

hi
i want to creat server using sql server 2005
and connect the server with clients (computers)
my question is :
1-must be the server computer using OS Windows Server
2-which book you advice me to read for creat server using SQL Server 2005 database
thank you

View 2 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

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







Copyrights 2005-15 www.BigResource.com, All rights reserved