Can someone give me a couple of pointers on how to interact with the web
service (?) to automatically add policies for a user to view folders and
reports rather than adding them manually through Report Manager?
thanksThis is a multi-part message in MIME format.
--=_NextPart_000_00C1_01C4BA63.9F970620
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
Rather than authorizing each user in Reporting Services it is
recommended that you create a Windows Group (e.g. Reporting Users),
associate the Group with a Reporting Services Role (e.g. Browser), and
then when you create a new Windows User you make the user a member of
the [Reporting Users] Group.
Garry
--=_NextPart_000_00C1_01C4BA63.9F970620
Content-Type: text/html;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
&
Re: Automatically add permissions on items for users?
Rather than authorizing each user in Reporting =Services it is recommended that you create a Windows Group (e.g. =Reporting Users), associate the Group with a Reporting Services Role =(e.g. Browser), and then when you create a new Windows User you make the =user a member of the [Reporting Users] Group.
Garry
--=_NextPart_000_00C1_01C4BA63.9F970620--|||the reason that I need to add each user is that I am using forms
authentication.
how can I call the web service to add policies for each user?
"Garry Lenz" wrote:
> Rather than authorizing each user in Reporting Services it is
> recommended that you create a Windows Group (e.g. Reporting Users),
> associate the Group with a Reporting Services Role (e.g. Browser), and
> then when you create a new Windows User you make the user a member of
> the [Reporting Users] Group.
> Garry
>
Showing posts with label couple. Show all posts
Showing posts with label couple. Show all posts
Thursday, March 22, 2012
Friday, February 24, 2012
Autogrow
I got this error a couple of times in the log this AM:
Error: 823, Severity: 24, State: 2
- and -
I/O error 38(Reached the end of the file.) detected during read at offset
0x00080009a3c000 in file 'D:\Data\Ramac_Data.MDF'..
BOL suggested a problem with the disk or disk full or file full. The disk
diags are fine; it is a 36GB disk with 30GB free space. I then look at the
properties of the database in question and see:
Size: 4018.94 MB
Space available: 0.00 MB
Ran DBCC CHECKDB, no errors found. Rebooted the server - still no change in
the above figures. I have Autogrow checked for both the DB file and the log
file, with unrestricted file growth for both and grow by set to 10 percent.
Why isn't it autogrow-ing?
Have you tried to manually grow it? Never rely on AutoGrow to do the work
for you.
Andrew J. Kelly SQL MVP
"Ron Hinds" <__NoSpam__ron@.__ramac__.com> wrote in message
news:ubB8Aw1TFHA.2940@.TK2MSFTNGP10.phx.gbl...
>I got this error a couple of times in the log this AM:
> Error: 823, Severity: 24, State: 2
> - and -
> I/O error 38(Reached the end of the file.) detected during read at offset
> 0x00080009a3c000 in file 'D:\Data\Ramac_Data.MDF'..
> BOL suggested a problem with the disk or disk full or file full. The disk
> diags are fine; it is a 36GB disk with 30GB free space. I then look at the
> properties of the database in question and see:
> Size: 4018.94 MB
> Space available: 0.00 MB
> Ran DBCC CHECKDB, no errors found. Rebooted the server - still no change
> in
> the above figures. I have Autogrow checked for both the DB file and the
> log
> file, with unrestricted file growth for both and grow by set to 10
> percent.
> Why isn't it autogrow-ing?
>
>
|||"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:Oxtmp35TFHA.3184@.TK2MSFTNGP15.phx.gbl...
> Have you tried to manually grow it? Never rely on AutoGrow to do the work
> for you.
OK... Can I at least rely on using Enterprise Manager to manually grow it?
Or should I stick to T-SQL exclusively?
[vbcol=seagreen]
> --
> Andrew J. Kelly SQL MVP
>
> "Ron Hinds" <__NoSpam__ron@.__ramac__.com> wrote in message
> news:ubB8Aw1TFHA.2940@.TK2MSFTNGP10.phx.gbl...
offset[vbcol=seagreen]
disk[vbcol=seagreen]
the
>
Error: 823, Severity: 24, State: 2
- and -
I/O error 38(Reached the end of the file.) detected during read at offset
0x00080009a3c000 in file 'D:\Data\Ramac_Data.MDF'..
BOL suggested a problem with the disk or disk full or file full. The disk
diags are fine; it is a 36GB disk with 30GB free space. I then look at the
properties of the database in question and see:
Size: 4018.94 MB
Space available: 0.00 MB
Ran DBCC CHECKDB, no errors found. Rebooted the server - still no change in
the above figures. I have Autogrow checked for both the DB file and the log
file, with unrestricted file growth for both and grow by set to 10 percent.
Why isn't it autogrow-ing?
Have you tried to manually grow it? Never rely on AutoGrow to do the work
for you.
Andrew J. Kelly SQL MVP
"Ron Hinds" <__NoSpam__ron@.__ramac__.com> wrote in message
news:ubB8Aw1TFHA.2940@.TK2MSFTNGP10.phx.gbl...
>I got this error a couple of times in the log this AM:
> Error: 823, Severity: 24, State: 2
> - and -
> I/O error 38(Reached the end of the file.) detected during read at offset
> 0x00080009a3c000 in file 'D:\Data\Ramac_Data.MDF'..
> BOL suggested a problem with the disk or disk full or file full. The disk
> diags are fine; it is a 36GB disk with 30GB free space. I then look at the
> properties of the database in question and see:
> Size: 4018.94 MB
> Space available: 0.00 MB
> Ran DBCC CHECKDB, no errors found. Rebooted the server - still no change
> in
> the above figures. I have Autogrow checked for both the DB file and the
> log
> file, with unrestricted file growth for both and grow by set to 10
> percent.
> Why isn't it autogrow-ing?
>
>
|||"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:Oxtmp35TFHA.3184@.TK2MSFTNGP15.phx.gbl...
> Have you tried to manually grow it? Never rely on AutoGrow to do the work
> for you.
OK... Can I at least rely on using Enterprise Manager to manually grow it?
Or should I stick to T-SQL exclusively?
[vbcol=seagreen]
> --
> Andrew J. Kelly SQL MVP
>
> "Ron Hinds" <__NoSpam__ron@.__ramac__.com> wrote in message
> news:ubB8Aw1TFHA.2940@.TK2MSFTNGP10.phx.gbl...
offset[vbcol=seagreen]
disk[vbcol=seagreen]
the
>
Autogrow
I got this error a couple of times in the log this AM:
Error: 823, Severity: 24, State: 2
- and -
I/O error 38(Reached the end of the file.) detected during read at offset
0x00080009a3c000 in file 'D:\Data\Ramac_Data.MDF'..
BOL suggested a problem with the disk or disk full or file full. The disk
diags are fine; it is a 36GB disk with 30GB free space. I then look at the
properties of the database in question and see:
Size: 4018.94 MB
Space available: 0.00 MB
Ran DBCC CHECKDB, no errors found. Rebooted the server - still no change in
the above figures. I have Autogrow checked for both the DB file and the log
file, with unrestricted file growth for both and grow by set to 10 percent.
Why isn't it autogrow-ing?Have you tried to manually grow it? Never rely on AutoGrow to do the work
for you.
Andrew J. Kelly SQL MVP
"Ron Hinds" <__NoSpam__ron@.__ramac__.com> wrote in message
news:ubB8Aw1TFHA.2940@.TK2MSFTNGP10.phx.gbl...
>I got this error a couple of times in the log this AM:
> Error: 823, Severity: 24, State: 2
> - and -
> I/O error 38(Reached the end of the file.) detected during read at offset
> 0x00080009a3c000 in file 'D:\Data\Ramac_Data.MDF'..
> BOL suggested a problem with the disk or disk full or file full. The disk
> diags are fine; it is a 36GB disk with 30GB free space. I then look at the
> properties of the database in question and see:
> Size: 4018.94 MB
> Space available: 0.00 MB
> Ran DBCC CHECKDB, no errors found. Rebooted the server - still no change
> in
> the above figures. I have Autogrow checked for both the DB file and the
> log
> file, with unrestricted file growth for both and grow by set to 10
> percent.
> Why isn't it autogrow-ing?
>
>|||"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:Oxtmp35TFHA.3184@.TK2MSFTNGP15.phx.gbl...
> Have you tried to manually grow it? Never rely on AutoGrow to do the work
> for you.
OK... Can I at least rely on using Enterprise Manager to manually grow it?
Or should I stick to T-SQL exclusively?
> --
> Andrew J. Kelly SQL MVP
>
> "Ron Hinds" <__NoSpam__ron@.__ramac__.com> wrote in message
> news:ubB8Aw1TFHA.2940@.TK2MSFTNGP10.phx.gbl...
offset[vbcol=seagreen]
disk[vbcol=seagreen]
the[vbcol=seagreen]
>
Error: 823, Severity: 24, State: 2
- and -
I/O error 38(Reached the end of the file.) detected during read at offset
0x00080009a3c000 in file 'D:\Data\Ramac_Data.MDF'..
BOL suggested a problem with the disk or disk full or file full. The disk
diags are fine; it is a 36GB disk with 30GB free space. I then look at the
properties of the database in question and see:
Size: 4018.94 MB
Space available: 0.00 MB
Ran DBCC CHECKDB, no errors found. Rebooted the server - still no change in
the above figures. I have Autogrow checked for both the DB file and the log
file, with unrestricted file growth for both and grow by set to 10 percent.
Why isn't it autogrow-ing?Have you tried to manually grow it? Never rely on AutoGrow to do the work
for you.
Andrew J. Kelly SQL MVP
"Ron Hinds" <__NoSpam__ron@.__ramac__.com> wrote in message
news:ubB8Aw1TFHA.2940@.TK2MSFTNGP10.phx.gbl...
>I got this error a couple of times in the log this AM:
> Error: 823, Severity: 24, State: 2
> - and -
> I/O error 38(Reached the end of the file.) detected during read at offset
> 0x00080009a3c000 in file 'D:\Data\Ramac_Data.MDF'..
> BOL suggested a problem with the disk or disk full or file full. The disk
> diags are fine; it is a 36GB disk with 30GB free space. I then look at the
> properties of the database in question and see:
> Size: 4018.94 MB
> Space available: 0.00 MB
> Ran DBCC CHECKDB, no errors found. Rebooted the server - still no change
> in
> the above figures. I have Autogrow checked for both the DB file and the
> log
> file, with unrestricted file growth for both and grow by set to 10
> percent.
> Why isn't it autogrow-ing?
>
>|||"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:Oxtmp35TFHA.3184@.TK2MSFTNGP15.phx.gbl...
> Have you tried to manually grow it? Never rely on AutoGrow to do the work
> for you.
OK... Can I at least rely on using Enterprise Manager to manually grow it?
Or should I stick to T-SQL exclusively?
> --
> Andrew J. Kelly SQL MVP
>
> "Ron Hinds" <__NoSpam__ron@.__ramac__.com> wrote in message
> news:ubB8Aw1TFHA.2940@.TK2MSFTNGP10.phx.gbl...
offset[vbcol=seagreen]
disk[vbcol=seagreen]
the[vbcol=seagreen]
>
Autogrow
I got this error a couple of times in the log this AM:
Error: 823, Severity: 24, State: 2
- and -
I/O error 38(Reached the end of the file.) detected during read at offset
0x00080009a3c000 in file 'D:\Data\Ramac_Data.MDF'..
BOL suggested a problem with the disk or disk full or file full. The disk
diags are fine; it is a 36GB disk with 30GB free space. I then look at the
properties of the database in question and see:
Size: 4018.94 MB
Space available: 0.00 MB
Ran DBCC CHECKDB, no errors found. Rebooted the server - still no change in
the above figures. I have Autogrow checked for both the DB file and the log
file, with unrestricted file growth for both and grow by set to 10 percent.
Why isn't it autogrow-ing?Have you tried to manually grow it? Never rely on AutoGrow to do the work
for you.
--
Andrew J. Kelly SQL MVP
"Ron Hinds" <__NoSpam__ron@.__ramac__.com> wrote in message
news:ubB8Aw1TFHA.2940@.TK2MSFTNGP10.phx.gbl...
>I got this error a couple of times in the log this AM:
> Error: 823, Severity: 24, State: 2
> - and -
> I/O error 38(Reached the end of the file.) detected during read at offset
> 0x00080009a3c000 in file 'D:\Data\Ramac_Data.MDF'..
> BOL suggested a problem with the disk or disk full or file full. The disk
> diags are fine; it is a 36GB disk with 30GB free space. I then look at the
> properties of the database in question and see:
> Size: 4018.94 MB
> Space available: 0.00 MB
> Ran DBCC CHECKDB, no errors found. Rebooted the server - still no change
> in
> the above figures. I have Autogrow checked for both the DB file and the
> log
> file, with unrestricted file growth for both and grow by set to 10
> percent.
> Why isn't it autogrow-ing?
>
>|||"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:Oxtmp35TFHA.3184@.TK2MSFTNGP15.phx.gbl...
> Have you tried to manually grow it? Never rely on AutoGrow to do the work
> for you.
OK... Can I at least rely on using Enterprise Manager to manually grow it?
Or should I stick to T-SQL exclusively?
> --
> Andrew J. Kelly SQL MVP
>
> "Ron Hinds" <__NoSpam__ron@.__ramac__.com> wrote in message
> news:ubB8Aw1TFHA.2940@.TK2MSFTNGP10.phx.gbl...
> >I got this error a couple of times in the log this AM:
> >
> > Error: 823, Severity: 24, State: 2
> >
> > - and -
> >
> > I/O error 38(Reached the end of the file.) detected during read at
offset
> > 0x00080009a3c000 in file 'D:\Data\Ramac_Data.MDF'..
> >
> > BOL suggested a problem with the disk or disk full or file full. The
disk
> > diags are fine; it is a 36GB disk with 30GB free space. I then look at
the
> > properties of the database in question and see:
> >
> > Size: 4018.94 MB
> > Space available: 0.00 MB
> >
> > Ran DBCC CHECKDB, no errors found. Rebooted the server - still no change
> > in
> > the above figures. I have Autogrow checked for both the DB file and the
> > log
> > file, with unrestricted file growth for both and grow by set to 10
> > percent.
> > Why isn't it autogrow-ing?
> >
> >
> >
>
Error: 823, Severity: 24, State: 2
- and -
I/O error 38(Reached the end of the file.) detected during read at offset
0x00080009a3c000 in file 'D:\Data\Ramac_Data.MDF'..
BOL suggested a problem with the disk or disk full or file full. The disk
diags are fine; it is a 36GB disk with 30GB free space. I then look at the
properties of the database in question and see:
Size: 4018.94 MB
Space available: 0.00 MB
Ran DBCC CHECKDB, no errors found. Rebooted the server - still no change in
the above figures. I have Autogrow checked for both the DB file and the log
file, with unrestricted file growth for both and grow by set to 10 percent.
Why isn't it autogrow-ing?Have you tried to manually grow it? Never rely on AutoGrow to do the work
for you.
--
Andrew J. Kelly SQL MVP
"Ron Hinds" <__NoSpam__ron@.__ramac__.com> wrote in message
news:ubB8Aw1TFHA.2940@.TK2MSFTNGP10.phx.gbl...
>I got this error a couple of times in the log this AM:
> Error: 823, Severity: 24, State: 2
> - and -
> I/O error 38(Reached the end of the file.) detected during read at offset
> 0x00080009a3c000 in file 'D:\Data\Ramac_Data.MDF'..
> BOL suggested a problem with the disk or disk full or file full. The disk
> diags are fine; it is a 36GB disk with 30GB free space. I then look at the
> properties of the database in question and see:
> Size: 4018.94 MB
> Space available: 0.00 MB
> Ran DBCC CHECKDB, no errors found. Rebooted the server - still no change
> in
> the above figures. I have Autogrow checked for both the DB file and the
> log
> file, with unrestricted file growth for both and grow by set to 10
> percent.
> Why isn't it autogrow-ing?
>
>|||"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:Oxtmp35TFHA.3184@.TK2MSFTNGP15.phx.gbl...
> Have you tried to manually grow it? Never rely on AutoGrow to do the work
> for you.
OK... Can I at least rely on using Enterprise Manager to manually grow it?
Or should I stick to T-SQL exclusively?
> --
> Andrew J. Kelly SQL MVP
>
> "Ron Hinds" <__NoSpam__ron@.__ramac__.com> wrote in message
> news:ubB8Aw1TFHA.2940@.TK2MSFTNGP10.phx.gbl...
> >I got this error a couple of times in the log this AM:
> >
> > Error: 823, Severity: 24, State: 2
> >
> > - and -
> >
> > I/O error 38(Reached the end of the file.) detected during read at
offset
> > 0x00080009a3c000 in file 'D:\Data\Ramac_Data.MDF'..
> >
> > BOL suggested a problem with the disk or disk full or file full. The
disk
> > diags are fine; it is a 36GB disk with 30GB free space. I then look at
the
> > properties of the database in question and see:
> >
> > Size: 4018.94 MB
> > Space available: 0.00 MB
> >
> > Ran DBCC CHECKDB, no errors found. Rebooted the server - still no change
> > in
> > the above figures. I have Autogrow checked for both the DB file and the
> > log
> > file, with unrestricted file growth for both and grow by set to 10
> > percent.
> > Why isn't it autogrow-ing?
> >
> >
> >
>
Subscribe to:
Posts (Atom)