can't call method CreateReport under asp.net

CreateReport throws an error saying that user IUSR_XXXXX doesn't have
permisssions
to run this method.
So,
1) I went to ReportServices roles and anded a new group for IUSR_XXXXX user
2) Assigned ReportserverSysadmin role for the new group.
3) Also set db_owner permissions for the IUSR_XXXXX user in ReportService
related databases on
my local instance of MS SQL.
No results. Still can't call method CreateReport().
Any ideas ?
Thanks
Paul
PS. BTW this method works fine from *.rss script that is running under
local Admin account.You need to give this user permission in the specific folder that they are
trying to create the report in. The SysAdmin role is just for system level
operations, not item specific operations.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"pTsy" <ptsygura@.bna.com> wrote in message
news:e79HvvadEHA.3944@.tk2msftngp13.phx.gbl...
> CreateReport throws an error saying that user IUSR_XXXXX doesn't have
> permisssions
> to run this method.
> So,
> 1) I went to ReportServices roles and anded a new group for IUSR_XXXXX
user
> 2) Assigned ReportserverSysadmin role for the new group.
> 3) Also set db_owner permissions for the IUSR_XXXXX user in
ReportService
> related databases on
> my local instance of MS SQL.
> No results. Still can't call method CreateReport().
> Any ideas ?
> Thanks
> Paul
> PS. BTW this method works fine from *.rss script that is running under
> local Admin account.
>
>|||Also, try enabling impersonation for your ASP.NET app. See:
http://blogs.msdn.com/bryanke/archive/2004/03/03/83345.aspx
--
Bryan Keller
Developer Documentation
SQL Server Reporting Services
A friendly reminder that this posting is provided "AS IS" with no
warranties, and confers no rights.
"pTsy" <ptsygura@.bna.com> wrote in message
news:e79HvvadEHA.3944@.tk2msftngp13.phx.gbl...
> CreateReport throws an error saying that user IUSR_XXXXX doesn't have
> permisssions
> to run this method.
> So,
> 1) I went to ReportServices roles and anded a new group for IUSR_XXXXX
user
> 2) Assigned ReportserverSysadmin role for the new group.
> 3) Also set db_owner permissions for the IUSR_XXXXX user in
ReportService
> related databases on
> my local instance of MS SQL.
> No results. Still can't call method CreateReport().
> Any ideas ?
> Thanks
> Paul
> PS. BTW this method works fine from *.rss script that is running under
> local Admin account.
>
>|||Hi Daniel
Thanks for answering
But how to do it through report server UI ?
or should I use some API function call ?
Thanks
Paul
"Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
news:ugZW9KcdEHA.3792@.TK2MSFTNGP09.phx.gbl...
> You need to give this user permission in the specific folder that they are
> trying to create the report in. The SysAdmin role is just for system
level
> operations, not item specific operations.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "pTsy" <ptsygura@.bna.com> wrote in message
> news:e79HvvadEHA.3944@.tk2msftngp13.phx.gbl...
> > CreateReport throws an error saying that user IUSR_XXXXX doesn't have
> > permisssions
> > to run this method.
> >
> > So,
> > 1) I went to ReportServices roles and anded a new group for IUSR_XXXXX
> user
> > 2) Assigned ReportserverSysadmin role for the new group.
> > 3) Also set db_owner permissions for the IUSR_XXXXX user in
> ReportService
> > related databases on
> > my local instance of MS SQL.
> >
> > No results. Still can't call method CreateReport().
> > Any ideas ?
> > Thanks
> > Paul
> >
> > PS. BTW this method works fine from *.rss script that is running under
> > local Admin account.
> >
> >
> >
> >
>|||Go to report manager as a local admin, click on the property tab, click on
the security sub-tab and there you can set permissions. You can do this
for any item in the catalog.
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"pTsy" <ptsygura@.bna.com> wrote in message
news:uW47l1veEHA.1724@.TK2MSFTNGP10.phx.gbl...
> Hi Daniel
> Thanks for answering
> But how to do it through report server UI ?
> or should I use some API function call ?
> Thanks
> Paul
> "Daniel Reib [MSFT]" <danreib@.online.microsoft.com> wrote in message
> news:ugZW9KcdEHA.3792@.TK2MSFTNGP09.phx.gbl...
> > You need to give this user permission in the specific folder that they
are
> > trying to create the report in. The SysAdmin role is just for system
> level
> > operations, not item specific operations.
> >
> > --
> > -Daniel
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "pTsy" <ptsygura@.bna.com> wrote in message
> > news:e79HvvadEHA.3944@.tk2msftngp13.phx.gbl...
> > > CreateReport throws an error saying that user IUSR_XXXXX doesn't have
> > > permisssions
> > > to run this method.
> > >
> > > So,
> > > 1) I went to ReportServices roles and anded a new group for IUSR_XXXXX
> > user
> > > 2) Assigned ReportserverSysadmin role for the new group.
> > > 3) Also set db_owner permissions for the IUSR_XXXXX user in
> > ReportService
> > > related databases on
> > > my local instance of MS SQL.
> > >
> > > No results. Still can't call method CreateReport().
> > > Any ideas ?
> > > Thanks
> > > Paul
> > >
> > > PS. BTW this method works fine from *.rss script that is running
under
> > > local Admin account.
> > >
> > >
> > >
> > >
> >
> >
>

can't backup DB after detach/attach

I moved a database to a new cluster using detach/attach. Now I am unable to
back it up.
When I do it manually it flashes very quickly saying that it has finished,
but the backup file is only 0 KB. When I run it as part of a maintenance plan
I am getting the following error in the logs:
[2] Database myDB: Verifying Backup...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft][ODBC SQL
Server Driver][SQL Server]Cannot open backup device
'F:\sqlBackups\myDB\myDB_db_200512131435.BAK'. Device error or device
off-line. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE is
terminating abnormally.
I am able to backup other databases on this instance so I am not sure why
this one is being so persnickity. Please let me know if you have any ideas.
Thanks.
well , have you read error log file ?
"Robert Kinesta" <RobertKinesta@.discussions.microsoft.com> wrote in message
news:9D5E94FC-5BAC-424E-8FAE-72B4908248BF@.microsoft.com...
>I moved a database to a new cluster using detach/attach. Now I am unable to
> back it up.
> When I do it manually it flashes very quickly saying that it has finished,
> but the backup file is only 0 KB. When I run it as part of a maintenance
> plan
> I am getting the following error in the logs:
> [2] Database myDB: Verifying Backup...
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft][ODBC
> SQL
> Server Driver][SQL Server]Cannot open backup device
> 'F:\sqlBackups\myDB\myDB_db_200512131435.BAK'. Device error or device
> off-line. See the SQL Server error log for more details.
> [Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE is
> terminating abnormally.
>
> I am able to backup other databases on this instance so I am not sure why
> this one is being so persnickity. Please let me know if you have any
> ideas.
> Thanks.
sql

can't backup DB after detach/attach

I moved a database to a new cluster using detach/attach. Now I am unable to
back it up.
When I do it manually it flashes very quickly saying that it has finished,
but the backup file is only 0 KB. When I run it as part of a maintenance pla
n
I am getting the following error in the logs:
[2] Database myDB: Verifying Backup...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft]&#
91;ODBC SQL
Server Driver][SQL Server]Cannot open backup device
'F:\sqlBackups\myDB\myDB_db_200512131435
.BAK'. Device error or device
off-line. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE i
s
terminating abnormally.
I am able to backup other databases on this instance so I am not sure why
this one is being so persnickity. Please let me know if you have any ideas.
Thanks.well , have you read error log file ?
"Robert Kinesta" <RobertKinesta@.discussions.microsoft.com> wrote in message
news:9D5E94FC-5BAC-424E-8FAE-72B4908248BF@.microsoft.com...
>I moved a database to a new cluster using detach/attach. Now I am unable to
> back it up.
> When I do it manually it flashes very quickly saying that it has finished,
> but the backup file is only 0 KB. When I run it as part of a maintenance
> plan
> I am getting the following error in the logs:
> [2] Database myDB: Verifying Backup...
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft]
[ODBC
> SQL
> Server Driver][SQL Server]Cannot open backup device
> 'F:\sqlBackups\myDB\myDB_db_200512131435
.BAK'. Device error or device
> off-line. See the SQL Server error log for more details.
> [Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE
is
> terminating abnormally.
>
> I am able to backup other databases on this instance so I am not sure why
> this one is being so persnickity. Please let me know if you have any
> ideas.
> Thanks.

can't backup DB after detach/attach

I moved a database to a new cluster using detach/attach. Now I am unable to
back it up.
When I do it manually it flashes very quickly saying that it has finished,
but the backup file is only 0 KB. When I run it as part of a maintenance plan
I am getting the following error in the logs:
[2] Database myDB: Verifying Backup...
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft][ODBC SQL
Server Driver][SQL Server]Cannot open backup device
'F:\sqlBackups\myDB\myDB_db_200512131435.BAK'. Device error or device
off-line. See the SQL Server error log for more details.
[Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE is
terminating abnormally.
I am able to backup other databases on this instance so I am not sure why
this one is being so persnickity. Please let me know if you have any ideas.
Thanks.well , have you read error log file ?
"Robert Kinesta" <RobertKinesta@.discussions.microsoft.com> wrote in message
news:9D5E94FC-5BAC-424E-8FAE-72B4908248BF@.microsoft.com...
>I moved a database to a new cluster using detach/attach. Now I am unable to
> back it up.
> When I do it manually it flashes very quickly saying that it has finished,
> but the backup file is only 0 KB. When I run it as part of a maintenance
> plan
> I am getting the following error in the logs:
> [2] Database myDB: Verifying Backup...
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3201: [Microsoft][ODBC
> SQL
> Server Driver][SQL Server]Cannot open backup device
> 'F:\sqlBackups\myDB\myDB_db_200512131435.BAK'. Device error or device
> off-line. See the SQL Server error log for more details.
> [Microsoft][ODBC SQL Server Driver][SQL Server]VERIFY DATABASE is
> terminating abnormally.
>
> I am able to backup other databases on this instance so I am not sure why
> this one is being so persnickity. Please let me know if you have any
> ideas.
> Thanks.

Cannot restore db

I'm trying to restore a Db from my web site back to my local machine.

Whichever way try, I get an error message saying

RESTORE detected an error on page (0:0)in database "new databasename"

> as read from the backup

Can anyone tell me what the error might be?

Many thanks

post back the restore database statement you used... also check the backup set .... if it is sql server 2005 use verify only option to verify the backup set... i doubt its corrupted.

Madhu

|||

Madhu,

I'm a newbie to SQL...

The backup was created by my web host - I have no control over how it is was created.

My database is SQL 2005 Express and I am trying to restore using SQL Server Management Studio Express - I do not see how to use "verfiy" using this tool.

Please can you give me some more guidance?

Many thanks for your help so far.

Cannot restore db

I'm trying to restore a Db from my web site back to my local machine.

Whichever way try, I get an error message saying

RESTORE detected an error on page (0:0)in database "new databasename"

> as read from the backup

Can anyone tell me what the error might be?

Many thanks

post back the restore database statement you used... also check the backup set .... if it is sql server 2005 use verify only option to verify the backup set... i doubt its corrupted.

Madhu

|||

Madhu,

I'm a newbie to SQL...

The backup was created by my web host - I have no control over how it is was created.

My database is SQL 2005 Express and I am trying to restore using SQL Server Management Studio Express - I do not see how to use "verfiy" using this tool.

Please can you give me some more guidance?

Many thanks for your help so far.

cannot rename instance of analysis server.missing reg key

when i use the rename instance tool i get this error saying it cannot find the regestry key

hkey_local_Machine\wow6432Node\Microsoft\Microsoft Sql Server\90

When i look for this key, it doesnt exist. My installation went perfectly. what is going wrong

There are 2 versions of ASInstanceRename utility. Make sure you use one that is installed with 64bit version of Analysis Server.

Edward Melomed.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

|||but i am using the 32 bit version of sql server 2005, and its on a 32 bit pc. theres no way i can install the 64 bit version as my machine wont even run the setup file|||

You should use 64 bit version of asinstancerename utility on 64 bit machine to rename 32bit instances. It is intended to be able to handle 32bit instances.

To get 64bit version of asinstancerename, uninstall 32bit version SQL Tools from your machine and install them back using 64ibt CD.

That should get you going.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.