Reporting Services Access Problem

I have one problem that must deal with security and I have tried everything to no avail. Reporting Services is running fine, I can deploy, I can see the link to the report in the browser. When I click the link I get Access Denied. All my IIS settings are as RS set them during the install. I am the administrator of the computer. I have given full control to all the folders that I think RS needs. If anyone has a suggestion please reply, thank you

GerryAre you connected to the Database??
|||In IIS, try unchecking the option to allow anonymous access and then click the link logged in as the local administrator (or add yourself to the local admins). If that works add the other credentials to RS security. Let me know if this helps.

Reporting Services 2005 - Security Extention

Hi,

I have compiled the security extension sample code that comes with the installation and I was able to successfully deploy it on the Reporting Server. Now my server asks me for username, password when browse to the http://servername/reports folder. I have configured one user as say "AdminUser".

When I login as AdminUser, I am to see all my reports and browse thru them.

I created one more user say "RegUser". I have logged in as AdminUser and I have give permissions to RegUser for some folders on report server.

Until this point every thing just worked fine and absolutly no problems.

The real problem shows up when the "RegUser" logs in to the system. He is able to login, but he cannot see any thing on the Home Page. Even though I have give permission to this RegUser, he is not able to see his folders.

If any body has solved this problem before or had any idea whats going on... please throw me an idea.

Thanks in advance.

Giri

What permission did you give him ? make sure that he is on the group of systeusers in Reporting Services, otherwise he won′t be able to see anything on the report server.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

I have given him the role "Browser" to a particular folder, but that is not helping me out.

Are you talking about giving setup in of the config files?

|||It sounds like issues with Authorization. make sure you have the function checkOperations properly overloaded and that your GetPermissions function is gathering the roles properly. It could also be that the roles defined in the Report Manager are not syncing up with the roles defined in your application/database.

Reporting services 2005

Hello,

I installed SQL Server 2005 into a Windows 2005 Pro machine, I have following question:

1. will I be able to use Reporting services to deploy the reports to the same machine as a report server?

2. Can I modify and deploy mo old reports written in RS2000

3. Is there any web site that show step by step how I can work with RS2005?

Thanks,

for the first question, of course, you can
for the third question, you can view the tutorial on reporting servicein sqlserver2005 help, first you should install both 'adventurework'database and 'adventureworkdw'database which are used in the tutorial.The install manual is also in sqlserver2005 help

Reporting Services 2000 sp1

hi,
I am using reporting services 2000 sp1 with vs.net 2003. I had it all set up ok (create, deploy reports etc). The problem i have is now for some reason i cant deploy and i get the message cannot connect to server. I have not changed anythink is this a know bug or somethink else. I have tried uninstalling and installing again same problem hope someone can help.

thanks in advance

kered

It is doubtful that this is a Reporting Services issue. Something else on your environment must have changed. Perhaps a new version of the Framework, a network configuration change, security changes? Can you connect to the server in a browser window? Can you upload reports through Report Manager?|||

hi, Brian

Thanks for the reply. No i can not connect to the server in a browser window, or upload reports through the report manager. I have uninstalled it again and installed again. I get the following setup message now (Set up could not initialize the report server. You must manually initialize the report server). Browseing the net i don,t seem to be able to resolve this i hope u can help me.

thanks in advance

kered

Reporting Services

I must install several reports on a production server and I dont have VS.NET
to deploy them.
Is there another way?
Thanks
RicardoIf you go to Report Manager on your RS server, there should be a button
to upload a report ("Upload Report"), which can be assigned to the
various report groups you have set up.
Ricardo Antunez wrote:
> I must install several reports on a production server and I dont have VS.NET
> to deploy them.
> Is there another way?
> Thanks
> Ricardo

Reporting Service Login dialog when trying to deploy a report

I am using SQGExpress, and can open the home page at
http://localhost/reports, but after previewing a report, when I try to deploy
the report I get a dialog asking for for a user name and password.
1. why do i get this dialog, and
2, what is it expecting; I have tried all that I could think of, but have
found to reponse that is accepted
Thanks
--
TomGHave you allowed Anonymous Access to the Report Server web application? Then
RS won't know which user you are trying to be, and probably bans any
deployment.
Kaisa M. Lindahl Lervik
"TomG" <TomG@.discussions.microsoft.com> wrote in message
news:7FC9358C-9678-45E6-8957-048A1E2F52F9@.microsoft.com...
>I am using SQGExpress, and can open the home page at
> http://localhost/reports, but after previewing a report, when I try to
> deploy
> the report I get a dialog asking for for a user name and password.
> 1. why do i get this dialog, and
> 2, what is it expecting; I have tried all that I could think of, but have
> found to reponse that is accepted
> Thanks
> --
> TomG|||thanks for your response.
I do not know. I will have to find how to determine and/or change if need be.
will do some digging and repost
--
TomG
"Kaisa M. Lindahl Lervik" wrote:
> Have you allowed Anonymous Access to the Report Server web application? Then
> RS won't know which user you are trying to be, and probably bans any
> deployment.
> Kaisa M. Lindahl Lervik
>
> "TomG" <TomG@.discussions.microsoft.com> wrote in message
> news:7FC9358C-9678-45E6-8957-048A1E2F52F9@.microsoft.com...
> >I am using SQGExpress, and can open the home page at
> > http://localhost/reports, but after previewing a report, when I try to
> > deploy
> > the report I get a dialog asking for for a user name and password.
> >
> > 1. why do i get this dialog, and
> > 2, what is it expecting; I have tried all that I could think of, but have
> > found to reponse that is accepted
> >
> > Thanks
> > --
> > TomG
>

Reporting service error

i use VS 2005 to develop.

And my DB is oracle

i use the SQL 2005 report service to crate the report .When i deploy to one server is ok .but when i deploy to another server (the server has install the sql 2005 & Oracle client is 10.1.0). when i try to view the report in this server : there will have some error message

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'CmtDataSoucre'. (rsErrorOpeningConnection)
System.Data.OracleClient requires Oracle client software version 8.1.7 or greater.

Hope some one can help.

Thanks

Lizzy

I have fixed the issue , by give give the permission to the folder of bin and admin .

But now new issue appear:

the issue is below :

An error has occurred during report processing. (rsProcessingAborted)
Cannot create a connection to data source 'CmtDataSoucre'. (rsErrorOpeningConnection)
OCIEnvCreate failed with return code -1 but error message text was not available.

Hope some one can help.

Thanks

Reporting Service 2000 and VS2005

Dear all:

Can I design report using VS2005 and deploy them on Reporting service 2000?

Thanks.

Reports designed with BI Development Studio (Report Designer integrated into VS 2005), can only be directly published to a RS 2005 report server because RS 2005 has additional features (e.g. interactive sort) which required incremental changes and an update in the Report Definition Language (RDL) schema namespace.

However, in many cases you can manually convert RS 2005 RDLs so that they can be published to the RS 2000 report server by editing the RDL and:

1. Change the overall RDL namespace
Replace <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" ... >
With <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition" ... >
2. Remove the following elements entirely if present in the RDL file:
<InteractiveWidth>21cm</InteractiveWidth>
<InteractiveHeight>29.7cm</InteractiveHeight>

3. Remove all occurences of interactive sort in the RDL file by removing all <UserSort> elements and its inner contents.

-- Robert

|||Thank you very much Robert! This is just what I needed.|||

I have several RS 2005 reports that I've converted as you suggested to use on SQL Server 2000. Everything was working fine, until now. I am having trouble printing reports. I don't know if this has to do with the conversion. I have the same report on my localhost but I'm running SQL 2005 and I have no problem printing this report. When I convert it and run it on SQL 2000 on another machine the empty reports print, but the ones with data get locked up and I can't even view the print preview. Any suggestions would be most appreciated.

Thanks, Janey

Reporting Service 2000 and VS2005

Dear all:

Can I design report using VS2005 and deploy them on Reporting service 2000?

Thanks.

Reports designed with BI Development Studio (Report Designer integrated into VS 2005), can only be directly published to a RS 2005 report server because RS 2005 has additional features (e.g. interactive sort) which required incremental changes and an update in the Report Definition Language (RDL) schema namespace.

However, in many cases you can manually convert RS 2005 RDLs so that they can be published to the RS 2000 report server by editing the RDL and:

1. Change the overall RDL namespace
Replace <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" ... >
With <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2003/10/reportdefinition" ... >
2. Remove the following elements entirely if present in the RDL file:
<InteractiveWidth>21cm</InteractiveWidth>
<InteractiveHeight>29.7cm</InteractiveHeight>

3. Remove all occurences of interactive sort in the RDL file by removing all <UserSort> elements and its inner contents.

-- Robert

|||Thank you very much Robert! This is just what I needed.|||

I have several RS 2005 reports that I've converted as you suggested to use on SQL Server 2000. Everything was working fine, until now. I am having trouble printing reports. I don't know if this has to do with the conversion. I have the same report on my localhost but I'm running SQL 2005 and I have no problem printing this report. When I convert it and run it on SQL 2000 on another machine the empty reports print, but the ones with data get locked up and I can't even view the print preview. Any suggestions would be most appreciated.

Thanks, Janey