ReportingService2005 API / CreateSubscription Permission
Oct 16, 2007
I have successfully used the ReportService2005 services to create a subscription. The problem I am running into is I need to create subscriptions on behalf of other people. This would mean that they would be owners of these subscriptions. The CreateSubscription web service does not take the owner as a paramter. This leads to a problem where someone would not be able to unsubscribe if I programmatically subscribed them. I need the subscription to show up in the "My Subscriptions" section.
Any help is greatly appreciated.
Thanks,
Lee
View 4 Replies
ADVERTISEMENT
Jul 19, 2007
Hi All,
In my app, whenever ReportingService2005.FireEvent method gets called, app threw me an exception said
"Insufficient permission for performing this operation". No idea how to fix it.
Thanks in advance.
Alex
View 6 Replies
View Related
Apr 18, 2008
Hi,
If somebody have worked on providing the code for the selection of delivery method and delivery schedule page in aspx . Then please share it with me. I am working on creating a Subscription page using aspx rather then reporting services page.
Please let me know if there are any controls provided by reporting services or some 3rd party for this.
Thanks & Regards,
Sam
View 3 Replies
View Related
Feb 15, 2007
Hi folks,
I am trying to create a SSRS subscription from an asp.net app. I collect the parameter values from the client and make the arrangements to send them to the CreateSubscription method. When the report has single value parameters, my code works perfectly. But if there is a report param with multiple values, I get the error
System.Web.Services.Protocols.SoapException: Default value or value provided for the report parameter '<paramName>' is not a valid value
My parameter is string type and supports multiple values. I am passing the following string as its Value:
AVA,BEL,CAL,CAP,CCA,CEL,COC,COM,ECE,EDT,EMC,EMT,EPB,EPC,EPM,EPO,EPS,ETB,MET
where each element separated by comma is a valid param value. Here´s the code I use to set the params values before the call to CreateSubscription:
Dim ReportParams As New NameValueCollection
ReportParams = Session("ReportParams")
NumeroParametros = ReportParams.Count
Dim parametrosRpt(NumeroParametros - 1) As ReportService2005.ParameterValue
For i = 0 To NumeroParametros - 1
Dim parameter As New ReportService2005.ParameterValue()
parameter.Name = ReportParams.GetKey(i)
parameter.Value = ReportParams(i)
parameter.Label = Nothing
parametrosRpt(i) = parameter
Next
RS.CreateNewSubscription(Session("Reporte"), "Some description", scheduleXml, txtPara.Text, _
txtCopia.Text, txtCopiaOculta.Text, txtAsunto.Text, comboFormato.SelectedValue, memoCuerpo.Text, _
parametrosRpt)
Getting nuts on this one. Any help/code samples will be greatly appreciated.
Cato
View 9 Replies
View Related
Nov 14, 2007
Hi, I'm having trouble with the ReportingService2005 object
I'm trying to use the Get and SetPolicies methods and have used ideas from other snippets in order to get this:
...
Microsoft.SqlServer.ReportingServices2005.ReportingService2005 RS = new Microsoft.SqlServer.ReportingServices2005.ReportingService2005();
RS.Credentials = System.Net.CredentialCache.DefaultCredentials;
RS.Url = http://www.MyServer.co.uk/ReportServer/ReportService2005.asmx;
bool ip;
Policies = RS.GetPolicies("/", out ip);
RS.SetPolicies("/", Policies);
...
Does anyone have any experience with this object, or any working examples, I suspect I'm still missing some permissions thing but at the moment all I get is this annoyingly unhelpful message:
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: --
BODY
{font-family:Verdana;font-weight:normal;font-size:8pt;color:black;}
H1
{font-family:Verdana;font-weight:700;font-size:15pt;}
LI
{font-family:Verdana;font-weight:normal;font-size:8pt;display:inline;}
.ProductInfo
{font-family:Verdana;font-weight:bold;font-size:8pt;color:gray;}
A:link
{font-size:8pt;font-family:Verdana;color:#3366CC;text-decoration:none;}
A:hover
{font-size:8pt;font-family:Verdana;color:#FF3300;text-decoration:underline;}
A:visited
{font-size:8pt;font-family:Verdana;color:#3366CC;text-decoration:none;}
Reporting Services Error
An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help
For more information about this error navigate to the report server on the local server machine, or enable remote errors
SQL Server Reporting Services
--.
Thanks for your help,
Sean.
View 2 Replies
View Related
May 19, 2006
I am using Reporting Services 2005 on SQL Express with Advanced Services...
I am dipping into the SOAP API and trying to add DataSources and Reports dynamically, as is how I would like to be able to deploy them...
My problem is this:
I have a shared datasource and a report that were deployed to the server via the 'Deploy' method in VSTS...I can access that report just fine, and it obviously uses the shared datasource...
Next, I copy the .rdl file of the report I already deployed and give it another name ("NewReport.rdl"). What I want to do is add this report to the server (it's an exact copy of the functioning report with a different report name). This report should use the same shared datasource as the other report.
Here is my code:
ReportingService2005 rs = new ReportingService2005();
rs.Credentials = System.Net.CredentialCache.DefaultCredentials;
Byte [] reportDefinition = /* read in the rdl file and create byte array out of it (didn't want to paste this code, cuz you don't care...trust me, it's correct */
ReportingTest.localhost.Warning [] warnings = rs.CreateReport("NewReport", "/ReportServerTest", true, reportDefinition, null);
foreach (ReportingTest.localhost.Warning warning in warnings)
{
Console.WriteLine(warning.Message);
}
The report is added to the server just fine, but I receive this 1 warning:
Code: "rsDataSourceReferenceNotPublished"
Message: "The data set €˜AdventureWorksTestDataSource€™ refers to the shared data source €˜AdventureWorksTestDataSource€™, which is not published on the report server."
And then when I try to view the report, I get this exception:
"The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)"
I know that the datasource is there, because the other report still works just fine...and I am adding an exact COPY of that report's RDL to the server, so it SHOULD work, IMO...
Any word on this?...I haven't been able to find much on this error...they say that an 'rsInvalidDataSourceReference' is usually caused when the datasource doesn't exist on the server when the report is deployed...or the datasource is deleted after the report has been deployed, but this is not true in my case...
Thanks for any feedback!!
Russ
View 9 Replies
View Related
Jul 21, 2006
I have programmatically deploy SQL server Reporting Services 2005 reports via msi file. The installation was success, I was able to run the reports on localhostReports at the target machine. But I get error "The request failed with HTTP status 401: Unauthorized." when I try to access it from the ASP.NET app report menu in the target machine.
It is Windows Server 2003 standard edition, it uses Windows Authentication. I have tried setting any combination below and still doesn't work. Anybody has any other ideas?
ReportingService2005 rs = new ReportingService2005();
rs.UseDefaultCredentials = true;
rs.PreAuthenticate = true;
rs.Credentials = System.Net.CredentialCache.DefaultCredentials; or
rs.Credentials = new System.Net.NetworkCredential("Admin", "psw");
View 5 Replies
View Related
Apr 14, 2008
I'd like to cancel my long running Reports via ReportingService2005.CancelJob(). It seems, while I'm able to start a job I don't have the permission to cancel it. I always get the error message:
The permissions granted to user '<my-account>' are insufficient for performing this operation.
Do I have the be a member of a special group on the server running the Reporting Services?
werner
View 3 Replies
View Related
Dec 11, 2007
Hello, I am trying to schedule a report using the ReportingService2005 web service. It works in my local machine, but as soon as I deploy my web app to a server I get this exception:
System.Net.WebException: The request failed with HTTP status 401: Unauthorized.
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at ReportService.ReportingService2005.GetSubscriptionProperties(String SubscriptionID, ExtensionSettings& ExtensionSettings, String& Description, ActiveState& Active, String& Status, String& EventType, String& MatchData, ParameterValue[]& Parameters)
at ReportScheduling.SaveSubscription(String SubscriptionID, String ReportName, Int32 ReportID)
at ReportScheduling.ScheduleReport()
I see that a lot of people are having the same problem but no solutions are given, Answers like "use the default credentials" . Or "pass a user name and a password" are not doing anything. This has got to be a machine setting. Can anyone share the specific fix? Sad that this is not in Microsoft's standard documentation or MSDN. Very frustating.
View 4 Replies
View Related
Oct 5, 2007
Hi,
Can I use the ReportingService2005.SetPolicies method to set the user of the form authentication to the role?
I mean the user name doesn't exist in the reporting service own table, only store in the our web system.
Thanks a lot
koukai
View 1 Replies
View Related
Dec 13, 2005
I have an application that uses Integrated Windows authentication. My Web.config looks like below
<add key="dbconnection" value=" server=XXX;Initial Catalog=XXX;persist security info=False;Integrated Security=SSPI;Pooling=true" />
When users try to access my application, they get the below error:
Execute permission denied on object 'SprocName', database 'DBNAME',Owner,'dbo'
The Only way I could get rid off the error is if I set DBO permissions for the user group on the databse.
Can someone suggest how to set up a security group with the ‘necessary’ permissions on SQL SERVER (ie read,write execute Sproc etc) and not too many extra ones, like DBO.
Thanks,
View 2 Replies
View Related
Sep 19, 2007
SQL Server 2005 anomoly?
In SQL Server Management Studio I granted specific permissions to user "A" to do Select, Insert, Update, Delete on Table "B" -
When I logged on as User "A" and attempted the Insert imto table "B" I got the following error:
"Insert Permission Denied on Table B, Database C, Schema dbo"
Is this a problem with the dbo schema?
Then I went back and created a stored proccedure "D" with the exact same Insert statement inside the procedure. I granted User "A" execute permission on the stored procedure "D".
I then logged on as User A and executed Stored Procedure "D". No Problem - stored procedure executed fine with the Insert.
I attempted the Insert statement again - straight SQL - as User "A" and got the same error as above ("Insert Permission Denied.....")
Strange behavior - cannot do a SQL. Insert even though user has permissions but can execute a store procedure with the same Insert statement.
What gives?
View 2 Replies
View Related
Sep 13, 2007
http://www.abvalve.com/careers/form/
can someone please tell me whats the problem with this?
I actually gave that user permission and and still did not work, the DB is in the appdb folder and the network services user is granted full permisions on that folder!
Any ideas
View 1 Replies
View Related
Jan 18, 2008
every things at sql2005 have to permission
table , create , select , stored procedure
every things have to make permission to NT AUTHORITYSYSTEM
at last i do every thing without permission how can i make it without it
View 4 Replies
View Related
Jan 27, 2008
I tru to add connection to my db in Visual Web Developer 2008 express.
Data source: - I use Microsoft SQL Server Database File (SqlClient).
Under Data File Name: I browse and choose the database and I get this error message
"ECommerceDbYou don't have permission to open this file. Contact the file owner or an administrator to obtain permission." WHat should I do? I already give full control to all users.
My environment is ms sql 2005 express and window vista business version. Thanks for any help.
View 1 Replies
View Related
Mar 8, 2001
I have created a DTS package that get a information form a text file and insert the data into a table and package is save as Structured Storage File. Now I am calling this DTS package thru VB application. The pacakge is save under folder that is shared to everyone.
When I run the VB application it runs fine using my login. but when I login as other user(webapp) it does not work. Webapp has DBO rights to the database that importing the data.
I am not sure if this is a permission issue or not.
Thank You,
john
View 1 Replies
View Related
Aug 20, 1999
Hi, is there a smarter way to grant permissions on a lot of tables to a user rather than accessing the "Permissions" button on the Database User's Properties?
In SQL 6.5 there is "Object Permissions" that lets me "Grant All". Isn't there a similar way to do it in SQL 7?
View 2 Replies
View Related
Nov 12, 2004
I have a database with over 100 tables. I need to add a user with deny permission on all tables except one. Is there a way of doing this without having to enter the names of all the tables and not using EM and ticking over 100 boxes? I tried to write the script using a select from sysobjects where xtype = 'U' but it didn't like it very much!!
Any help would be greatfully appreciated.
Many thanks
View 4 Replies
View Related
Jan 15, 2008
Hello, Can anybody explain why a new loggin with Master Database as the Default Dafault Database without any clear permission to a particular database would allow me selection in a pubs or northwind database for an example. Thanks
View 5 Replies
View Related
Mar 4, 2004
I created a DTS package to extract data to a text file.
I want to create a login for a user who should be able ONLY to run this DTS. I don't want to give him/her any access to any database .
Is that possible?
Thanks in advance
Giorgio
View 3 Replies
View Related
May 12, 2008
Hi
I have a user that I need to grant access to a database, he should be able to ...
* create/edit/delete tables, views and stored procedures
So I created a user and then set his default database to the one he should access, then in user_mapping for that database I have checked.
db_Datareader
db_datawriter
db_ddladmin
db_denydatareader
db_securityadmin
public
But when this user try to access the tables with Sql server management studio he get this error "The select permission was denied on the object 'extended propoerties', database 'mssqlsystemresource', schema 'sys'. Microsoft SQL Server, Error: 229)"
What do I need to change in order to get this to work?
View 2 Replies
View Related
Jan 28, 2007
What's Defference between Control Server And SysAdmin Role
View 6 Replies
View Related
Feb 5, 2008
hi all,
we have so many logins in sql server 2005 . i want to reduce the permissions of the users.
changing permissions to each and user is little bit difficulty .
database level : - db_writer and db_reader, and execute permissions .
i have to grant these permissions only .is there any chance to give for all users
can any one suggest the issue..
thanks
manoj
View 1 Replies
View Related
Feb 20, 2008
Hi,
How can set select, add, delete & update permission for objects in a database for a particular user/role in SQL 2005.
In SQL 2000 I could see all the tables listed under permission so that I could give a tik for permission
regards
priw
View 4 Replies
View Related
Aug 7, 2006
i have my sql server database set up but when i try to run my app i get this error:http://img308.imageshack.us/img308/2862/untitledep4.pngany help you be grateful :)
View 4 Replies
View Related
Dec 16, 2006
In sql server 2005, what is minimum right a user need to view the content of stored-procedures? That is, in SSMS the user will be able to right click a stored-procedure and then select "Modify" to view the content, but the user has no permission to promote it? Thanks!
View 4 Replies
View Related
Apr 10, 2007
iam working with http location and using sql server 2005
its getting an error as "SELECT permission denied on object UserDetails' database 'elearning', schema 'dbo'."
"UserDetails" is my table name
"elearning" is database name
i worked same project with filesystem location ,there it is working
View 2 Replies
View Related
Apr 26, 2007
iam working with http location and using sql server 2005 its getting an error as "INSERT permission denied on object CourseDetails, database 'mydb', schema 'dbo'." "CourseDetails" is my table name "mydb" is database name i worked same project with filesystem location ,there it is working
View 1 Replies
View Related
Aug 29, 2007
I read a few articles on best SQL practices and they kept coming back to using a Least Privileged Account. So I did so and gave that account read only permissions. The articles also said to do updates use Stored Procedures - so I created stored procedures for updating/deleting data.So here's my problem - I connect to the database using the Least Privileged Account, I use the Stored Procedures, but .NET keeps saying I lack permissions. If I GRANT the Least Privileged Account UPDATE/DELETE permission on the table, the Stored Procedures run perfectly. But isn't that EXACTLY what I'm trying to avoid?My greatest concern is someone hacks my website and using the Least Privileged Account, they delete all my data using that account. So I don't want to give the Least Privileged Account the Update/Delete privileges.Thanks a MILLION in advance!
View 3 Replies
View Related
Jan 28, 2004
Windows 2000 server, service pack 4, RAID 5 array, 2Gb RAM, SQL server 2000.
.Net framework 1.1 installed and runs happily UNTIL you try to access anything to do with data.
I've got a c# page, imported all relevent namespaces etc. This runs fine on other servers and my XP Pro machine. However, when put on this server, all I get is
Exception Details: System.UnauthorizedAccessException: Access is denied.
I've tried explictly setting permissions on the file, directory etc, but nothing I've found can get the file to work, yet other c# pages which don't use SQL connections work fine !
The offending line:
Line 31: SqlCommand sqlCmd = new SqlCommand(sql,sqlCon);
Line 32: sqlCon.Open();
Line 33: SqlDataReader datareader = sqlCmd.ExecuteReader();
Line 34: while (datareader.Read()
is line 32.
STACK TRACE:
[UnauthorizedAccessException: Access is denied.]
System.EnterpriseServices.Platform.Initialize() +497
System.EnterpriseServices.ResourcePool..ctor(TransactionEndDelegate cb) +11
System.Data.SqlClient.ConnectionPool..ctor(DefaultPoolControl ctrl) +797
System.Data.SqlClient.PoolManager.FindOrCreatePool(DefaultPoolControl ctrl) +170
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +356
System.Data.SqlClient.SqlConnection.Open() +384
ASP.test_aspx.Page_Load(Object sender, EventArgs e) in C:Inetpubwwwrootfishfood est.aspx:32
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
I've copied this directory and set up another application on another server and it works fine!
Anyone got any ideas?
View 6 Replies
View Related
Mar 19, 2005
I have downloaded and installed the forum on my website but I am having a problem with permsissions on one of the SQL tables. The default.aspx page comes up but when I try to view one of the forums I get the following error message.
SELECT permission denied on object forums_Threads database ower dbo
I have used enterprise manager and checked to make sure that the account I log in with listed in the Web.config file has the correct permissions to access this table and all fields within it. Everything looks ok but I still get the error.
Any help would be appreciated
Thanks,
Glenn
View 1 Replies
View Related
Mar 27, 2001
I have developer who is working With VB using COM objects for creating a webpage, and he is making a connection to SQL server using NT account. the NT account has datareader,datawriter and exec SP on the database that the COM objects is calling. But he get the following error 'Login failed for user 'NT AUTHORITYANONYMOUS LOGON''when click on the webpage that was creted using VB.
Does anyone know why would this happend.
Thank You,
john
View 1 Replies
View Related
May 18, 2001
Whne I try to create a procedure in a database , it throws an error saying
"CREATE PROCEDURE permission denied, database 'PUBS', owner 'dbo'"
Though I am a part of db_owner and ddl_admin fixed database role.
What could be the reason behind it?
View 3 Replies
View Related
