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.
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).
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?
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
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
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.
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
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.
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
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.
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?
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.
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)
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
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?
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?
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.
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.
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.
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.
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.???
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?
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?
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?
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?
