Credentials problem or deployment puzzle or permission problem?

Hi,All:

I had development a reporting service home page for our intranet . And I deployed this home page at "domain.server1" (for example) and my sql server database and reporting service is at another server "domain.server2"(for example). on the "domain.server1" , the Authentication methods is Integrated windows authentication. and on the "domain.server2" , with the reportingservice server properites and home folder, in the "permissions" tab, I had add the "domain.server1$" as system user role. so I can view my report via my home page and it works fine. If I remove the "domain.server1$" from the reporting service, there could be encountered an error "The permissions granted to user 'domain.server1$' are insufficient for performing this operation".

I used

rService.Credentials = System.Net.CredentialCache.DefaultCredentials;

in my home page to list the reports. I think this must be a problem, so I change this code as

System.Net.NetworkCredential myCreds = new System.Net.NetworkCredential();
myCreds.Domain = "domain";
myCreds.UserName = "UserName";
myCreds.Password = "Password";
rService.Credentials = myCreds;

and add this "UserName" to a local group "group1" on "domain.server2" , and grant this group "group1" to access the reporting service server. It works fine.

but now , I'm confused how to get the user's information (especially the password infomation , even though encrypted )?

Does any one can give me some feedbacks?

T.I.A

henry

http://blogs.msdn.com/bimusings/archive/2005/11/18/494436.aspx?CommentPosted=true#commentmessage

I got the this scenarios a few days ago, after a few day's research.

I found that we must configurate the webServer as a trusted server so it can pass the credentials to the SSRS.

Allow a computer to be trusted for delegation

http://technet2.microsoft.com/WindowsServer/en/library/b207ee9c-a055-43f7-b9be-20599b694a311033.mspx?mfr=true

in the web applcation , we just set the Report viewer control credential like this:

rService.Credentials = System.Net.CredentialCache.DefaultCredentials;

we must configurate the webServer to support the Kerberos Authentication and Delegation

How to configure IIS to support both the Kerberos protocol and the NTLM protocol for network authentication

http://support.microsoft.com/kb/215383

and It works.

Good luck!

Henry

Credentials problem or deployment puzzle or permission problem?

Hi,All:

I had development a reporting service home page for our intranet . And I deployed this home page at "domain.server1" (for example) and my sql server database and reporting service is at another server "domain.server2"(for example). on the "domain.server1" , the Authentication methods is Integrated windows authentication. and on the "domain.server2" , with the reportingservice server properites and home folder, in the "permissions" tab, I had add the "domain.server1$" as system user role. so I can view my report via my home page and it works fine. If I remove the "domain.server1$" from the reporting service, there could be encountered an error "The permissions granted to user 'domain.server1$' are insufficient for performing this operation".

I used

rService.Credentials = System.Net.CredentialCache.DefaultCredentials;

in my home page to list the reports. I think this must be a problem, so I change this code as

System.Net.NetworkCredential myCreds = new System.Net.NetworkCredential();
myCreds.Domain = "domain";
myCreds.UserName = "UserName";
myCreds.Password = "Password";
rService.Credentials = myCreds;

and add this "UserName" to a local group "group1" on "domain.server2" , and grant this group "group1" to access the reporting service server. It works fine.

but now , I'm confused how to get the user's information (especially the password infomation , even though encrypted )?

Does any one can give me some feedbacks?

T.I.A

henry

http://blogs.msdn.com/bimusings/archive/2005/11/18/494436.aspx?CommentPosted=true#commentmessage

I got the this scenarios a few days ago, after a few day's research.

I found that we must configurate the webServer as a trusted server so it can pass the credentials to the SSRS.

Allow a computer to be trusted for delegation

http://technet2.microsoft.com/WindowsServer/en/library/b207ee9c-a055-43f7-b9be-20599b694a311033.mspx?mfr=true

in the web applcation , we just set the Report viewer control credential like this:

rService.Credentials = System.Net.CredentialCache.DefaultCredentials;

we must configurate the webServer to support the Kerberos Authentication and Delegation

How to configure IIS to support both the Kerberos protocol and the NTLM protocol for network authentication

http://support.microsoft.com/kb/215383

and It works.

Good luck!

Henry

credentials

I am using RS2000. I have created some reports and publish to the server. A
folder has been created at /home/test1 in report manger and granted the
access right to user A.
I created a .net application with impersonation = false, how can I call the
reports under test1 inside this application by using the RS2000 control? what
I mean is how to pass the A's credential to reporting services so that I can
access the report.
Can anyone give me some suggestion? Thanks a lot!Hi, Ry
When you say "using the RS2000 control" do you mean the sample report
viewer control for ASP.NET?
If so, then the control should be using the URL access method to create
HTTP GET requests (it creates URL querystrings) that fetch the report
and display them in an IFRAME.
So when the control points the IFRAME to the ReportServer and folder
where the report is located, it's the same as if the current user
opened a browser and tried to view the ReportServer directly
(http://servername/ReportServer?/home/test1/testReport¶m1=SomeValue).
The Report Server uses windows authentication, so your application is
not actually performing the authentication for the reports and folders,
it's all done by the Report Server.
If you were using the RS web service to make proxy calls to render the
report, then you would need to provide user context information to the
Web Service, so it would authenticate. You would use
DefaultCredentials to pass your current application's user to the
Report Server via the web service Credentials property.
Hope that points you in the right direction.
Regards,
Thiago Silva
MCAD.NET
Ry wrote:
> I am using RS2000. I have created some reports and publish to the server. A
> folder has been created at /home/test1 in report manger and granted the
> access right to user A.
> I created a .net application with impersonation = false, how can I call the
> reports under test1 inside this application by using the RS2000 control? what
> I mean is how to pass the A's credential to reporting services so that I can
> access the report.
> Can anyone give me some suggestion? Thanks a lot!

Creating SSRS folders?

New ssrs istall.
When I attempt to open report manager, i just get
SQL Server Reporting Services
Home
with no option for creating a folder etc, like i have on development
When I attempt to deploy to ther server I get :
Deploying to http://amsqlclusterxx/reportserver/
Error rsItemAlreadyExists : The item '/Retailer' already exists.
How do I create an ssrs reports folder?
Also, and this is strange, but in vs.net I had to create a new shared
datasource after removing the old one on the report with the same
name. The report renders fine when I do an f5 pointing to a new
datasource, but I no longer have the RUN "!" icon available while in
the data tag to run my query. Why is this?
Thanks for any help or information.Hello,
I suppose that user which you use to connect to Report Manager has
insufficient permissions.
Check if this situation takes place also if you use user account which is a
member of the server's Administrators group (BUILTIN\Administrators).
Or maybe you have in IIS configured anonymouse access to Report Manager
Site.
Does RS ask for login credentials when you open Report Manager?
Best Regards,
Radoslaw Lebkowski
Uzytkownik "jobs" <jobs@.webdos.com> napisal w wiadomosci
news:1193850825.364868.47100@.19g2000hsx.googlegroups.com...
> New ssrs istall.
> When I attempt to open report manager, i just get
> SQL Server Reporting Services
> Home
> with no option for creating a folder etc, like i have on development
> When I attempt to deploy to ther server I get :
> Deploying to http://amsqlclusterxx/reportserver/
> Error rsItemAlreadyExists : The item '/Retailer' already exists.
> How do I create an ssrs reports folder?
> Also, and this is strange, but in vs.net I had to create a new shared
> datasource after removing the old one on the report with the same
> name. The report renders fine when I do an f5 pointing to a new
> datasource, but I no longer have the RUN "!" icon available while in
> the data tag to run my query. Why is this?
> Thanks for any help or information.
>