Showing posts with label receive. Show all posts
Showing posts with label receive. Show all posts

Monday, March 26, 2012

rsAccessDenied for authorised user.

Hi, as many people in this group, I have the problem that some users
cannot access the report we designed. They receive the message:
The permissions granted to user '{domain}\{userID}' are insufficient
for performing
this operation. (rsAccessDenied)
The strange thing here is that I granted access to a group (Domain
Users) which holds all the users of this domain. I tested with 3 users
who all could access the report. Of course I thought that if these
users could access the report, other users should be able to access the
report too. But, when I tested with a fourth user I got the error as
stated above. I checked the rights for the group on the folders and
reports, but they are ok. So what am I misssing here?
I also tried to sign individual rights to the userId, but no luck
either. Then I tried to use an other userId too (fith userid for the
test) , same result, no access. So in my group "Domain Users" , which
holds all the users of the domain. Three users can access the report
and so far two can not. I didn't test with other accounts except for
these 5, that should be enough, don't you think?
We do not use "Anonymous Access" anywhere.
The server is Standard 2003
MS SQL 2000
Reporting Services 2000
Any help would be appriciatedOk, found out what the problem was. I didn't set the right permissions
on the top-level. So, first I had to set de security permissions in RS
on te "root"-folder, then on the subfolders and so on to the reports.
This solved my problemsql

Wednesday, March 21, 2012

RS2005 Access Error Using Report Manager Via DNS

PROBLEM:
Created a DNS entry (reportsdev) to access reporting services.
I can NOT ACCESS the report manager and receive an error
http://reportsdev/Reports$SQLServer2005/Pages/Folder.aspx
I CAN ACCESS the report server with out a problem via IE and VS2005.
http://reportsdev/ReportServer$SQLServer2005
ERROR:
â'The attempt to connect to the report server failed. Check your connection
information and that the report server is a compatible version.â'
This is a reporting services error with the reporting services UI wrapped
around the error and the link to Home. Clicking the link to Home generates
the same error.
NOTES & Tentative Solution:
I CAN ACCESS the report manager by configuring the report site with a port
rather then host header.
http://dc13:900/Reports$SQLServer2005/Pages/Folder.aspx
If I restart IIS and then access the report manager using the DNS an error
is logged in the Application Log â'Report Manager cannot connect to the
ReportServer service.â'
Configuration:
Windows 2000, Side by side install of SQL 2000 and SQL 2005 (New clean
install of 2005). RS2000 was on the machine until a restore but after the
restore was not reinstalled the RS2000 databases have been removed from
SQL2000 after the restore.
Any help is appreciated,
TedTed,
Did you update the entry in RSWebApplication.config to match your
report server DNS entry?
Andy Potter|||the same problem persists to me although i have modified the entry in
RSWebApplication.config
when I first installed the reporting services 2005, I wanted to use as
server the older one (sql + reporting 2000). I couldn't figure out what's the
problem and I thought that may be an incompatibility beteen sql 200 and
RS2005 and RS 2000 all toghther on the same server. After this I have
installed a new instance of SQL 2005 and the RS 2005...but I had the same
error (The attempt to connect to the report server failed. Check your
connection
information and that the report server is a compatible version)
...until I droped the ideea of using host header (right now I use a simple
asp page to redirect...but this is not the final solution that I want).
still, I want to use a host header...anyone figure it out how to?
"Potter" wrote:
> Ted,
> Did you update the entry in RSWebApplication.config to match your
> report server DNS entry?
> Andy Potter
>|||I am havin the same problem!
I am having problems trying to deploy a report from VS2005 to SSRS 2005. We
are using Windows Server 2003 SP1. I get the following error:
Microsoft Report Designer
A connection could not be made to the report server
Check your connection information and that the report server is a compatible
version.
nickpup
"tbarton" wrote:
> PROBLEM:
> Created a DNS entry (reportsdev) to access reporting services.
> I can NOT ACCESS the report manager and receive an error
> http://reportsdev/Reports$SQLServer2005/Pages/Folder.aspx
> I CAN ACCESS the report server with out a problem via IE and VS2005.
> http://reportsdev/ReportServer$SQLServer2005
>
> ERROR:
> â'The attempt to connect to the report server failed. Check your connection
> information and that the report server is a compatible version.â'
> This is a reporting services error with the reporting services UI wrapped
> around the error and the link to Home. Clicking the link to Home generates
> the same error.
>
> NOTES & Tentative Solution:
> I CAN ACCESS the report manager by configuring the report site with a port
> rather then host header.
> http://dc13:900/Reports$SQLServer2005/Pages/Folder.aspx
> If I restart IIS and then access the report manager using the DNS an error
> is logged in the Application Log â'Report Manager cannot connect to the
> ReportServer service.â'
>
> Configuration:
> Windows 2000, Side by side install of SQL 2000 and SQL 2005 (New clean
> install of 2005). RS2000 was on the machine until a restore but after the
> restore was not reinstalled the RS2000 databases have been removed from
> SQL2000 after the restore.
> Any help is appreciated,
> Ted
>|||I finally managed to solve this problem
open SQl Books Online at this page:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/a0134ef0-086c-443e-93b9-7213a3d76393.htm
and check the explanations about ReportServerVirtualDirectory and
ReportServerUrl
"ReportServerUrl and ReportServerVirtualDirectory are mutually exclusive. If
you specify ReportServerUrl, you must delete the entry for
ReportServerVirtualDirectory"
"nickpup" wrote:
> I am havin the same problem!
> I am having problems trying to deploy a report from VS2005 to SSRS 2005. We
> are using Windows Server 2003 SP1. I get the following error:
> Microsoft Report Designer
> A connection could not be made to the report server
> Check your connection information and that the report server is a compatible
> version.
> nickpup
>
> "tbarton" wrote:
> > PROBLEM:
> > Created a DNS entry (reportsdev) to access reporting services.
> > I can NOT ACCESS the report manager and receive an error
> > http://reportsdev/Reports$SQLServer2005/Pages/Folder.aspx
> >
> > I CAN ACCESS the report server with out a problem via IE and VS2005.
> > http://reportsdev/ReportServer$SQLServer2005
> >
> >
> > ERROR:
> > â'The attempt to connect to the report server failed. Check your connection
> > information and that the report server is a compatible version.â'
> >
> > This is a reporting services error with the reporting services UI wrapped
> > around the error and the link to Home. Clicking the link to Home generates
> > the same error.
> >
> >
> > NOTES & Tentative Solution:
> > I CAN ACCESS the report manager by configuring the report site with a port
> > rather then host header.
> > http://dc13:900/Reports$SQLServer2005/Pages/Folder.aspx
> >
> > If I restart IIS and then access the report manager using the DNS an error
> > is logged in the Application Log â'Report Manager cannot connect to the
> > ReportServer service.â'
> >
> >
> > Configuration:
> > Windows 2000, Side by side install of SQL 2000 and SQL 2005 (New clean
> > install of 2005). RS2000 was on the machine until a restore but after the
> > restore was not reinstalled the RS2000 databases have been removed from
> > SQL2000 after the restore.
> >
> > Any help is appreciated,
> >
> > Ted
> >|||also check this page:
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/1571c3fb-53a1-4bdd-bde6-0b8d490bf823.htm
"dragoon" wrote:
> I finally managed to solve this problem
> open SQl Books Online at this page:
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/rptsrvr9/html/a0134ef0-086c-443e-93b9-7213a3d76393.htm
> and check the explanations about ReportServerVirtualDirectory and
> ReportServerUrl
> "ReportServerUrl and ReportServerVirtualDirectory are mutually exclusive. If
> you specify ReportServerUrl, you must delete the entry for
> ReportServerVirtualDirectory"
> "nickpup" wrote:
> > I am havin the same problem!
> >
> > I am having problems trying to deploy a report from VS2005 to SSRS 2005. We
> > are using Windows Server 2003 SP1. I get the following error:
> >
> > Microsoft Report Designer
> >
> > A connection could not be made to the report server
> >
> > Check your connection information and that the report server is a compatible
> > version.
> >
> > nickpup
> >
> >
> > "tbarton" wrote:
> >
> > > PROBLEM:
> > > Created a DNS entry (reportsdev) to access reporting services.
> > > I can NOT ACCESS the report manager and receive an error
> > > http://reportsdev/Reports$SQLServer2005/Pages/Folder.aspx
> > >
> > > I CAN ACCESS the report server with out a problem via IE and VS2005.
> > > http://reportsdev/ReportServer$SQLServer2005
> > >
> > >
> > > ERROR:
> > > â'The attempt to connect to the report server failed. Check your connection
> > > information and that the report server is a compatible version.â'
> > >
> > > This is a reporting services error with the reporting services UI wrapped
> > > around the error and the link to Home. Clicking the link to Home generates
> > > the same error.
> > >
> > >
> > > NOTES & Tentative Solution:
> > > I CAN ACCESS the report manager by configuring the report site with a port
> > > rather then host header.
> > > http://dc13:900/Reports$SQLServer2005/Pages/Folder.aspx
> > >
> > > If I restart IIS and then access the report manager using the DNS an error
> > > is logged in the Application Log â'Report Manager cannot connect to the
> > > ReportServer service.â'
> > >
> > >
> > > Configuration:
> > > Windows 2000, Side by side install of SQL 2000 and SQL 2005 (New clean
> > > install of 2005). RS2000 was on the machine until a restore but after the
> > > restore was not reinstalled the RS2000 databases have been removed from
> > > SQL2000 after the restore.
> > >
> > > Any help is appreciated,
> > >
> > > Ted
> > >

Tuesday, March 20, 2012

RS: An unexpected error

I receive the message when I usehttp://mytest/reports (ReportManager):

The underlying connection was closed: An unexpected error occurred on a
receive.

Contents of log:

<Header>
<Product>Microsoft SQL Server Reporting Services Version
8.00.1038.00</Product>
<Locale>en-US</Locale>
<TimeZone>Eastern Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServer__06_16_2005_09_35_28.log</Path>
<SystemName>mytest</SystemName>
<OSName>Microsoft Windows NT 5.2.3790.0</OSName>
<OSVersion>5.2.3790.0</OSVersion>
</Header>
w3wp!webserver!1e70!6/16/2005-09:35:28:: i INFO: Reporting Web Server started
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing ConnectionType
to '0' as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing
IsSchedulingService to 'True' as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing
IsNotificationService to 'True' as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing IsEventService
to 'True' as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing PollingInterval
to '10' second(s) as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing MemoryLimit to
'60' percent as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing RecycleTime to
'720' minute(s) as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing
MaximumMemoryLimit to '80' percent as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing
MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing MaxQueueThreads
to '0' thread(s) as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing
MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing MaxScheduleWait
to '5' second(s) as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing
DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing InstanceName to
'MSSQLSERVER' as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing
ProcessRecycleOptions to '0' as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing
RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration
file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing
RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing
RunningRequestsAge to '30' second(s) as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing
CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing
SecureConnectionLevel to '0' as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing DisplayErrorLink
to 'True' as specified in Configuration file.
w3wp!library!1e70!6/16/2005-09:35:28:: i INFO: Initializing
WebServiceUseFileShareStorage to default value of 'False' because it was not
specified in Configuration file.
w3wp!resourceutilities!1e70!6/16/2005-09:35:28:: i INFO: Running on 2
physical processors, 4 logical processors
w3wp!resourceutilities!1e70!6/16/2005-09:35:28:: i INFO: Reporting Services
starting SKU: Enterprise
w3wp!runningjobs!1e70!6/16/2005-09:35:28:: i INFO: Database Cleanup (Web
Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
w3wp!runningjobs!1e70!6/16/2005-09:35:28:: i INFO: Running Requests
Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1e70!6/16/2005-09:35:28:: i INFO: Running Requests DB timer
enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!runningjobs!1e70!6/16/2005-09:35:28:: i INFO: Memory stats update timer
enabled: Next Event: 60 seconds. Cycle: 60 seconds
w3wp!library!1e70!06/16/2005-09:35:34:: i INFO: Call to GetSystemPermissions
w3wp!crypto!1e70!06/16/2005-09:35:35:: i INFO: Initializing crypto as user:
NT AUTHORITY\NETWORK SERVICE
w3wp!crypto!1e70!06/16/2005-09:35:35:: i INFO: Exporting public key
w3wp!crypto!1e70!06/16/2005-09:35:35:: i INFO: Performing sku validation
w3wp!crypto!1e70!06/16/2005-09:35:35:: i INFO: Importing existing encryption
key
w3wp!webserver!16a4!6/16/2005-09:35:48:: i INFO: Reporting Web Server stopped

In what a problem?

P.S. Windows 2003 Standart, MS SQL 2000 SP4, RS SP 2

I am getting the same exact error. Why is there no response to this?

Saturday, February 25, 2012

RS doesn't works under ASP.NET 2.0?

Hi,
when I switch my reportserver virtual folder to the ASp.net2.0 I receive
this error:
"Failed to load expression host assembly"
this error appears only when I try to render a report, I can list reports or
I can access the webservice without any error.
any solution?
thanks.
Jerome.RS 2000 is not a ASP.Net 2.0 app. It uses the 1.1 framework. RS 2005 is a
ASP.Net 2.0 app.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
news:%23ndrIwI9FHA.1332@.tk2msftngp13.phx.gbl...
> Hi,
> when I switch my reportserver virtual folder to the ASp.net2.0 I receive
> this error:
> "Failed to load expression host assembly"
> this error appears only when I try to render a report, I can list reports
> or I can access the webservice without any error.
> any solution?
> thanks.
> Jerome.
>|||I know, but, for example Sharepoint works fine under ASP.NET 2.0 and its a
1.1 software.
but if I switch the reportserver virtual directory from v1.1 to v2.0,
rendering a report stop working.
"Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%232wwe4P9FHA.1248@.TK2MSFTNGP14.phx.gbl...
> RS 2000 is not a ASP.Net 2.0 app. It uses the 1.1 framework. RS 2005 is a
> ASP.Net 2.0 app.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
> news:%23ndrIwI9FHA.1332@.tk2msftngp13.phx.gbl...
>> Hi,
>> when I switch my reportserver virtual folder to the ASp.net2.0 I receive
>> this error:
>> "Failed to load expression host assembly"
>> this error appears only when I try to render a report, I can list reports
>> or I can access the webservice without any error.
>> any solution?
>> thanks.
>> Jerome.
>>
>|||If you want RS to work, leave it alone at 1.1 or upgrade to RS 2005. Note
that you can leave SQL Server as 2000 and still upgrade RS to 2005. You do
need a 2005 license though. Beside additional features I noticed significant
performance improvements with RS 2005.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
news:OrI6xeR9FHA.500@.TK2MSFTNGP15.phx.gbl...
>I know, but, for example Sharepoint works fine under ASP.NET 2.0 and its a
>1.1 software.
> but if I switch the reportserver virtual directory from v1.1 to v2.0,
> rendering a report stop working.
> "Bruce L-C [MVP]" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:%232wwe4P9FHA.1248@.TK2MSFTNGP14.phx.gbl...
>> RS 2000 is not a ASP.Net 2.0 app. It uses the 1.1 framework. RS 2005 is a
>> ASP.Net 2.0 app.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Jéjé" <willgart@.BBBhotmailAAA.com> wrote in message
>> news:%23ndrIwI9FHA.1332@.tk2msftngp13.phx.gbl...
>> Hi,
>> when I switch my reportserver virtual folder to the ASp.net2.0 I receive
>> this error:
>> "Failed to load expression host assembly"
>> this error appears only when I try to render a report, I can list
>> reports or I can access the webservice without any error.
>> any solution?
>> thanks.
>> Jerome.
>>
>>
>