Showing posts with label permission. Show all posts
Showing posts with label permission. Show all posts

Sunday, March 25, 2012

Cannot read the next data row for the data set

Hello all -
Our users are getting the above error when trying to execute a report.
Permission has been granted to the security group that they belong to, for
the report folder and report (browser permissions), as well as the Analytical
Services database and the associated data warehouse database (db_datareader).
The report uses two parameters, which have default values set (year and
month).
Any ideas as to what may be the problem?
Thanks!
Pam RichardsonIn case anyone else runs into this problem, here's the answer. In the
analysis services database, the Reader role/Cell Data had the "Enable read
permissions" checkbox checked, but nothing was in the "Allow reading of cube
content" textbox. Unchecking this checkbox solved the problem.
Thanks,
Pam Richardson
"Pam Richardson" wrote:
> Hello all -
> Our users are getting the above error when trying to execute a report.
> Permission has been granted to the security group that they belong to, for
> the report folder and report (browser permissions), as well as the Analytical
> Services database and the associated data warehouse database (db_datareader).
> The report uses two parameters, which have default values set (year and
> month).
> Any ideas as to what may be the problem?
> Thanks!
> Pam Richardson

Tuesday, March 20, 2012

Cannot open database requested in login fail for 'Computer\NetSDK'

Hello;
I tried almost everything I can, give permission to ASPNET to the folder
application, start and restart ASPNET, SQL$Server, checked my sqlstring
connections in the global.axp.vb and still cannot connect to the database.
I am using MSDE (Free engine from microsoft), Can someone please help me?
thank you.
JoeHi
Give Computer\NetSDK permission to login to SQL Server, Grant permissions in
the DB for tables and other objects in the DB.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"jaz2003" <jaz2003@.discussions.microsoft.com> wrote in message
news:98FC9CC8-DBB6-46F5-BAB4-BEA89D40600A@.microsoft.com...
> Hello;
> I tried almost everything I can, give permission to ASPNET to the folder
> application, start and restart ASPNET, SQL$Server, checked my sqlstring
> connections in the global.axp.vb and still cannot connect to the database.
> I am using MSDE (Free engine from microsoft), Can someone please help me?
> thank you.
> Joe

Cannot open database requested in login fail for 'Computer\NetSDK'

Hello;
I tried almost everything I can, give permission to ASPNET to the folder
application, start and restart ASPNET, SQL$Server, checked my sqlstring
connections in the global.axp.vb and still cannot connect to the database.
I am using MSDE (Free engine from microsoft), Can someone please help me?
thank you.
Joe
Hi
Give Computer\NetSDK permission to login to SQL Server, Grant permissions in
the DB for tables and other objects in the DB.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"jaz2003" <jaz2003@.discussions.microsoft.com> wrote in message
news:98FC9CC8-DBB6-46F5-BAB4-BEA89D40600A@.microsoft.com...
> Hello;
> I tried almost everything I can, give permission to ASPNET to the folder
> application, start and restart ASPNET, SQL$Server, checked my sqlstring
> connections in the global.axp.vb and still cannot connect to the database.
> I am using MSDE (Free engine from microsoft), Can someone please help me?
> thank you.
> Joe