How to remove domain admins from SRS

Hi
In our IT dept all IT users are members of the domain admin group (not my
idea). Is there a way to prevent them from seeing reports/folders? We only
want admins to see reports if they are given explicit permissions.
thanksThe reason this is happening is not because they are in the domain admin
group, it is because the domain admin group is in the local Adminstrators
group. This is the group that RS uses. So, on the server that is running RS
remove the domain admin group from the local group. Create new groups that
you put in the appropriate users and then assign the appropriate roles. Only
put true RS admins in the local admin group.
--
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"darwin" <darwin@.discussions.microsoft.com> wrote in message
news:6722153F-A8A5-4B77-8DFA-772ADCFB7145@.microsoft.com...
> Hi
> In our IT dept all IT users are members of the domain admin group (not my
> idea). Is there a way to prevent them from seeing reports/folders? We
> only
> want admins to see reports if they are given explicit permissions.
> thanks|||Thanks Bruce ;)
"Bruce L-C [MVP]" wrote:
> The reason this is happening is not because they are in the domain admin
> group, it is because the domain admin group is in the local Adminstrators
> group. This is the group that RS uses. So, on the server that is running RS
> remove the domain admin group from the local group. Create new groups that
> you put in the appropriate users and then assign the appropriate roles. Only
> put true RS admins in the local admin group.
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "darwin" <darwin@.discussions.microsoft.com> wrote in message
> news:6722153F-A8A5-4B77-8DFA-772ADCFB7145@.microsoft.com...
> > Hi
> > In our IT dept all IT users are members of the domain admin group (not my
> > idea). Is there a way to prevent them from seeing reports/folders? We
> > only
> > want admins to see reports if they are given explicit permissions.
> >
> > thanks
>
>

How to Remove Blank Pages CrystalReport9 problem

Hi,
I have designed report which do not have any group. It shows last page blank although it does not contain any record.I have tried with these

In SectionExpert=>NewPageAfter
IF OnLastRecord then
if isNull({Command.SNPSHT_ID}) then
formula = False
end if
end if

Please help to solve theseplease help me with removal of blank pages in crystalreport9|||if onlastrecord then
false
else
true

Try this formula on SectionExpert=>Page Footer->New Page After...
Don't forget to uncheck this option after writing formula.|||hi,
in PageFooter =>sectionexpert=>NewPageAfter is blocked|||oops sorry.
Try it in details section since u don't have group footer|||if onlastrecord then
false
else
true

Try this formula on SectionExpert=>Page Footer->New Page After...
Don't forget to uncheck this option after writing formula.

hi,
in PageFooter =>sectionexpert=>"NewPageAfter is blocked"

i have tried it in detail section which gives me one record on each page.
Please help me to resolve these problem|||remove else part from ur detail section formula.sql

How to recover a corrupted backup file?

(Posting to the right group)
I backed up a database (SQL 2000) from EM but because some disk problems the
file became corrupted. Aparently part of the problem was the transaction log
did was not truncated before (it is twice the size of the data)
Is there any tool (freebie) that allows me to recover data from the
corrupted dump file? I can open it with notepad and tested it with demo
MSSQLRecovery 2.2 and there is data there. I do need to recover the db as
there is a lot of work in there.
Thank you for any input
The fact that the transaction log is twice the size of the data doesn't
necessary mean that it is corrupted. This is normal if you are using the
Full Recovery Mode and that you never backuped the log file. For shrinking
the log file, you must first back-it up (and not just only backup the data
file).
SQL Log Rescue from Red-Gate is a good tool to recover data from the log
file.
For the data file, I don't know.
It's not a good idea to make a backup only on the hard drive, without any
external copy.
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF
"Julio" <Julio@.discussions.microsoft.com> wrote in message
news:BD52AE00-E4F2-496A-BE41-855994DFBBA5@.microsoft.com...
> (Posting to the right group)
> I backed up a database (SQL 2000) from EM but because some disk problems
> the
> file became corrupted. Aparently part of the problem was the transaction
> log
> did was not truncated before (it is twice the size of the data)
> Is there any tool (freebie) that allows me to recover data from the
> corrupted dump file? I can open it with notepad and tested it with demo
> MSSQLRecovery 2.2 and there is data there. I do need to recover the db as
> there is a lot of work in there.
> Thank you for any input
>
|||Thank you for the info.
The issue is that database became corrupted upon restore (I know, all was
done wrong), but I see data is still there on the dump file. I was looking
for a tool able to check the dump file and try to fix it (I'm working on a
copy of it) or some trick to force it to restore and repair it.
"Julio" wrote:

> (Posting to the right group)
> I backed up a database (SQL 2000) from EM but because some disk problems the
> file became corrupted. Aparently part of the problem was the transaction log
> did was not truncated before (it is twice the size of the data)
> Is there any tool (freebie) that allows me to recover data from the
> corrupted dump file? I can open it with notepad and tested it with demo
> MSSQLRecovery 2.2 and there is data there. I do need to recover the db as
> there is a lot of work in there.
> Thank you for any input
>

How to recover a corrupted backup file?

(Posting to the right group)
I backed up a database (SQL 2000) from EM but because some disk problems the
file became corrupted. Aparently part of the problem was the transaction lo
g
did was not truncated before (it is twice the size of the data)
Is there any tool (freebie) that allows me to recover data from the
corrupted dump file? I can open it with notepad and tested it with demo
MSSQLRecovery 2.2 and there is data there. I do need to recover the db as
there is a lot of work in there.
Thank you for any inputThe fact that the transaction log is twice the size of the data doesn't
necessary mean that it is corrupted. This is normal if you are using the
Full Recovery Mode and that you never backuped the log file. For shrinking
the log file, you must first back-it up (and not just only backup the data
file).
SQL Log Rescue from Red-Gate is a good tool to recover data from the log
file.
For the data file, I don't know.
It's not a good idea to make a backup only on the hard drive, without any
external copy.
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF
"Julio" <Julio@.discussions.microsoft.com> wrote in message
news:BD52AE00-E4F2-496A-BE41-855994DFBBA5@.microsoft.com...
> (Posting to the right group)
> I backed up a database (SQL 2000) from EM but because some disk problems
> the
> file became corrupted. Aparently part of the problem was the transaction
> log
> did was not truncated before (it is twice the size of the data)
> Is there any tool (freebie) that allows me to recover data from the
> corrupted dump file? I can open it with notepad and tested it with demo
> MSSQLRecovery 2.2 and there is data there. I do need to recover the db as
> there is a lot of work in there.
> Thank you for any input
>|||Thank you for the info.
The issue is that database became corrupted upon restore (I know, all was
done wrong), but I see data is still there on the dump file. I was looking
for a tool able to check the dump file and try to fix it (I'm working on a
copy of it) or some trick to force it to restore and repair it.
"Julio" wrote:

> (Posting to the right group)
> I backed up a database (SQL 2000) from EM but because some disk problems t
he
> file became corrupted. Aparently part of the problem was the transaction
log
> did was not truncated before (it is twice the size of the data)
> Is there any tool (freebie) that allows me to recover data from the
> corrupted dump file? I can open it with notepad and tested it with demo
> MSSQLRecovery 2.2 and there is data there. I do need to recover the db as
> there is a lot of work in there.
> Thank you for any input
>

How to recover a corrupted backup file?

(Posting to the right group)
I backed up a database (SQL 2000) from EM but because some disk problems the
file became corrupted. Aparently part of the problem was the transaction log
did was not truncated before (it is twice the size of the data)
Is there any tool (freebie) that allows me to recover data from the
corrupted dump file? I can open it with notepad and tested it with demo
MSSQLRecovery 2.2 and there is data there. I do need to recover the db as
there is a lot of work in there.
Thank you for any inputThe fact that the transaction log is twice the size of the data doesn't
necessary mean that it is corrupted. This is normal if you are using the
Full Recovery Mode and that you never backuped the log file. For shrinking
the log file, you must first back-it up (and not just only backup the data
file).
SQL Log Rescue from Red-Gate is a good tool to recover data from the log
file.
For the data file, I don't know.
It's not a good idea to make a backup only on the hard drive, without any
external copy.
--
Sylvain Lafontaine, ing.
MVP - Technologies Virtual-PC
E-mail: http://cerbermail.com/?QugbLEWINF
"Julio" <Julio@.discussions.microsoft.com> wrote in message
news:BD52AE00-E4F2-496A-BE41-855994DFBBA5@.microsoft.com...
> (Posting to the right group)
> I backed up a database (SQL 2000) from EM but because some disk problems
> the
> file became corrupted. Aparently part of the problem was the transaction
> log
> did was not truncated before (it is twice the size of the data)
> Is there any tool (freebie) that allows me to recover data from the
> corrupted dump file? I can open it with notepad and tested it with demo
> MSSQLRecovery 2.2 and there is data there. I do need to recover the db as
> there is a lot of work in there.
> Thank you for any input
>|||Thank you for the info.
The issue is that database became corrupted upon restore (I know, all was
done wrong), but I see data is still there on the dump file. I was looking
for a tool able to check the dump file and try to fix it (I'm working on a
copy of it) or some trick to force it to restore and repair it.
"Julio" wrote:
> (Posting to the right group)
> I backed up a database (SQL 2000) from EM but because some disk problems the
> file became corrupted. Aparently part of the problem was the transaction log
> did was not truncated before (it is twice the size of the data)
> Is there any tool (freebie) that allows me to recover data from the
> corrupted dump file? I can open it with notepad and tested it with demo
> MSSQLRecovery 2.2 and there is data there. I do need to recover the db as
> there is a lot of work in there.
> Thank you for any input
>

How to reader header and footer in EBCDIC file?

I have data arriving in fixed-width EBCDIC format. Each file contains one or more groups of records. Before and after each group there is a header/footer, which is not in the same layout as the records that it describes. Header, record and footer each have a different layout to the other but are consistent within themselves.

Thankfully the one thing header, footer and record layout have in common is their length, so at the moment, using the appropriate code page in the Flat File Connection Manager, I'm able to read all the columns as strings. The headers and footers just come through, albeit a bit weird looking, and I can filter them out with a conditional splt.

However, the header contains information that needs to be appended to each record in the group. Does anyone have any suggestions about how to achieve this? I'm trying to avoid developing a custom data source for this task but, if there's no other way, has anyone done it and do they have any tips?

You should search this forum for discussions on topics similar to this.

You can read the file twice, using two data flows. The first time, to extract just the header and to store its values in a table, perhaps. The second time, to extract just the detail records and to join to the table from the first run to pull in the information you need.

Or, you can use a script task to read through the file. Or a script component inside the data flow. You may have to read in the entire line as one big string though.|||I would read the file twice as does not involved custome code. I knmow John(Jwelch) has some sample code on his blog so that may be another resource apart from searching the forum