Advice needed

I have an sql server db on a remote dedicated server that is open on
internet, for remote report writing.
The company that uses is it extremely large and well known, due to this the
sql server gets hammered by bogus logins.
10,000+ of them a day,.
Security wise its ok but the bloody error log files are huge 27-48 mb.
Because I logonto this server remotely atleast once a day and check logs, I
am finding it difficult to read them due to the size for vieving log file
in a TS session.
How can I create 1 error log a day for 7 days then recycle them, or atleast
create them into more manageble sizes.
Regards
DonIf your talking about the Sql Server logs then you can use
sp_cycle_errorlog.
Andrew J. Kelly
SQL Server MVP
"Don Grover" <spamfree@.assoft.com.au> wrote in message
news:e$C62CazDHA.1736@.TK2MSFTNGP09.phx.gbl...

quote:

---

> I have an sql server db on a remote dedicated server that is open on
> internet, for remote report writing.
> The company that uses is it extremely large and well known, due to this

---

the

quote:

---

> sql server gets hammered by bogus logins.
> 10,000+ of them a day,.
> Security wise its ok but the bloody error log files are huge 27-48 mb.
> Because I logonto this server remotely atleast once a day and check logs,

---

I

quote:

---

> am finding it difficult to read them due to the size for vieving log file
> in a TS session.
> How can I create 1 error log a day for 7 days then recycle them, or

---

atleast

quote:

---

> create them into more manageble sizes.
> Regards
> Don
>

---

AdventureWorks Samples Not working

I've installed and deployed the AdventureWorks Sample reports to Report
Manager in RS 2005. When I click on any of the reports, the report just
spins away and never returns the report information. I eventually (10
minutes later) just stop the browser. I made sure I have permissions to all
the data sources as well. Has anyone else had this problem or know where I
can look to see where the report(s) are hanging?
System Information:
Windows XP Pro
IIS 5.x
SQL Server 2005 Std.
VS 2005 Pro
Reporting Services 2005Verify that the dataset(s) in a report are actually working.
"Michael" wrote:
> I've installed and deployed the AdventureWorks Sample reports to Report
> Manager in RS 2005. When I click on any of the reports, the report just
> spins away and never returns the report information. I eventually (10
> minutes later) just stop the browser. I made sure I have permissions to all
> the data sources as well. Has anyone else had this problem or know where I
> can look to see where the report(s) are hanging?
> System Information:
> Windows XP Pro
> IIS 5.x
> SQL Server 2005 Std.
> VS 2005 Pro
> Reporting Services 2005
>|||I'm pretty sure the dataset is working since when I preview in VS2005 I can
get the sample to work with no problem. Strangely also, when I use VS2005 to
deploy and open the Samples folder, I can click on a sample report and it
works as expected. Only when I go to http://localhost/reports/home.aspx ->
AdventureWorks Samples -> Sample report does it just spin away.
"Bing Bing Yu" wrote:
> Verify that the dataset(s) in a report are actually working.
>
> "Michael" wrote:
> > I've installed and deployed the AdventureWorks Sample reports to Report
> > Manager in RS 2005. When I click on any of the reports, the report just
> > spins away and never returns the report information. I eventually (10
> > minutes later) just stop the browser. I made sure I have permissions to all
> > the data sources as well. Has anyone else had this problem or know where I
> > can look to see where the report(s) are hanging?
> >
> > System Information:
> > Windows XP Pro
> > IIS 5.x
> > SQL Server 2005 Std.
> > VS 2005 Pro
> > Reporting Services 2005
> >
> >

AdventureWorks Sample Reports

Hi folks,

Newbie question. Anyone knows how to create dropdown selection boxes in a report just like in the Employee Sales Summary report? Cheers!

Moving thread to the Reporting Services Group|||

If you install the sample reports, you can just open them in report designer and investigate the Report - Report Parameter settings in the VS menu. The Employee Sales Summary report uses a query to determine the valid values list of the parameter - which results in the drop down being shown.

Alternatively, this MSDN topic should get you started: http://msdn2.microsoft.com/en-us/library/ms155917.aspx

-- Robert

AdventureWorks Report Samples Problem

Hi,
I am trying to deploy the AdventureWorks OLAP cube in C:\Program
Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks Analysis Services
Project but unfortunately the folder "AdventureWorks Analysis Services
Project" does not exist nor does the file Adventure Works DW.dwproj. I have
installed the samples using the Microsoft SQL Server 2005 Samples installer.
Where can I find this directory and project?
Kind regards,
TrevorHi Trevor,
Welcome to use MSDN Managed Newsgroup!
From your descriptions, I understood you would like to launch
AdventureWorks Analysis Services Project but cannot find it in the
identified folder. If I have misunderstood your concern, please feel free
to point it out.
Based on my knowledge, please perform the steps below to make sure you have
installed AdventureWorksDW sample datawarehouse and AdventureWorks Sample
OLAP.
- Open Add or remove Programs in Control Panel
- Select Microsoft SQL Server 2005, click Change
- Select Workstation Components under SQL Server 2005 common components,
click Next
- After System Configuration Check, click Next.
- Click Change Installed Components
- Expand Documentation, Samples and Sample Databases, Expand Sample
Databases, Expand AdventureWorksDW Sample Data Warehouse. Make sure
everything was selected and then click Next
Thank you for your patience and cooperation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Microsoft Online Partner Support
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
=====================================================This posting is provided "AS IS" with no warranties, and confers no rights.

Advantages/Disadvantages of SQL 2005 Reporting Vs Crystal Report 1

Hi:
Can someone show me a link where I can get the Advantages/Disadvantages of
SQL 2005 Reporting Vs Crystal Report 10 ?
Thanks in advance.
--
Thanks,
SDRoyTry this:
http://www.crystalreportsbook.com/SSRSandCR_ExecSummary.asp
"SDRoy" wrote:
> Hi:
> Can someone show me a link where I can get the Advantages/Disadvantages of
> SQL 2005 Reporting Vs Crystal Report 10 ?
> Thanks in advance.
> --
> Thanks,
> SDRoy|||I just perused it and two things. One is that it was written prior to SQL
Server 2005 coming out. And, two, the licensing is incomplete. Apples to
Apples I have never heard that Crystal Reports is cheaper. The licensing
costs mentioned are per CPU for SQL Server which you might or might not have
to do. From what I have seen when we looked at Crystal Reports licensing
there is no way that you will get away with the $7,500 license fee that the
author compares to the Enterprise per processor license for SQL Server.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"John G." <John G.@.discussions.microsoft.com> wrote in message
news:9AF11023-0A1E-4CE8-87DC-81B7F583A2D0@.microsoft.com...
> Try this:
> http://www.crystalreportsbook.com/SSRSandCR_ExecSummary.asp
> "SDRoy" wrote:
>> Hi:
>> Can someone show me a link where I can get the Advantages/Disadvantages
>> of
>> SQL 2005 Reporting Vs Crystal Report 10 ?
>> Thanks in advance.
>> --
>> Thanks,
>> SDRoy

Advanced Expression?

I'm creating a report that looks through detail records and want it to sum
amounts based on a record type. If FieldType = 1 to sum accounts in a range
otherwise to sum all records with that account. The result is an error
[BC30201] Expression expected. The formula I have so far is:
=iif( Fields!FieldType.Value = 1, select sum( Fields!amount.Value) from
db.owner.table with (nolock) where Fields!account between
Fields!fromaccount.Value and Fields!toaccount.Value ,Sum(Fields!amount.Value))
I've also tried VB's Select/Case statement rather than IIF but it still
returns an error.
If this can't be done with expressions, can it be done someother way?
Thanks,
RickThis seems you might want to try creating a stored procedure and using the sp
as the basis of your report, not trying to calc that in a report cell. You
can't use a select statement from within the iif statement.
"rickp3131" wrote:
> I'm creating a report that looks through detail records and want it to sum
> amounts based on a record type. If FieldType = 1 to sum accounts in a range
> otherwise to sum all records with that account. The result is an error
> [BC30201] Expression expected. The formula I have so far is:
> =iif( Fields!FieldType.Value = 1, select sum( Fields!amount.Value) from
> db.owner.table with (nolock) where Fields!account between
> Fields!fromaccount.Value and Fields!toaccount.Value ,Sum(Fields!amount.Value))
> I've also tried VB's Select/Case statement rather than IIF but it still
> returns an error.
> If this can't be done with expressions, can it be done someother way?
> Thanks,
> Rick|||Mike,
Thanks for your reply. Are you referring to creating a stored procedure in
SQL or does RS have the ability to create stored procedures as well, like in
Report properties.custom code?
Since my post I came to the same conclusion you mention that what I'm trying
to do won't work in the reporting cell so I've been looking into creating a
function using custom code but as you mention, the select statement can't be
used within IIF. Can a stored procedure be called from IIF?
As a general custom code question, can C as well as VB code be used?
Thanks again!
Rick
"mike" wrote:
> This seems you might want to try creating a stored procedure and using the sp
> as the basis of your report, not trying to calc that in a report cell. You
> can't use a select statement from within the iif statement.
> "rickp3131" wrote:
> > I'm creating a report that looks through detail records and want it to sum
> > amounts based on a record type. If FieldType = 1 to sum accounts in a range
> > otherwise to sum all records with that account. The result is an error
> > [BC30201] Expression expected. The formula I have so far is:
> >
> > =iif( Fields!FieldType.Value = 1, select sum( Fields!amount.Value) from
> > db.owner.table with (nolock) where Fields!account between
> > Fields!fromaccount.Value and Fields!toaccount.Value ,Sum(Fields!amount.Value))
> >
> > I've also tried VB's Select/Case statement rather than IIF but it still
> > returns an error.
> >
> > If this can't be done with expressions, can it be done someother way?
> >
> > Thanks,
> > Rick|||You can try an SQL user defined function returning a table with summary
details, then use the IIF statement to get more specific, or you can use a
"Where" statement in your dataset
"rickp3131" wrote:
> I'm creating a report that looks through detail records and want it to sum
> amounts based on a record type. If FieldType = 1 to sum accounts in a range
> otherwise to sum all records with that account. The result is an error
> [BC30201] Expression expected. The formula I have so far is:
> =iif( Fields!FieldType.Value = 1, select sum( Fields!amount.Value) from
> db.owner.table with (nolock) where Fields!account between
> Fields!fromaccount.Value and Fields!toaccount.Value ,Sum(Fields!amount.Value))
> I've also tried VB's Select/Case statement rather than IIF but it still
> returns an error.
> If this can't be done with expressions, can it be done someother way?
> Thanks,
> Rick

ADP Report Problems

Hi all I have two tables joined in a query and I need for one record to show up in the report rather then the whole history. Does that make sense??Does that make sense??No, but if you could post the SELECT statment, an example of what you don't want, and a "cut down" example or two of what you do want, I bet we could figure it out! ;)

-PatP|||Hi all I have two tables joined in a query and I need for one record to show up in the report rather then the whole history. Does that make sense??

No ... but if you hum a few bars I think we can fake it :D|||"ADP Report Problem"?
Should this thread be in the Access forum?|||"ADP Report Problem"?
Should this thread be in the Access forum?I thought the same but I was waiting until anyone actually figured out what the problem was....|||Considering that 95% or better of Desireemm's problems are SQL, I'm willing to give this one the benefit of the doubt. If it turns out that the question belongs elsewhere, we can move it once we know enough to know where to move it to!

-PatP|||I'm so sorry guys I didnt post the Select Statement. You see I have two tables that are joined, the ActiveConditionals table holds the employees conditionals and they could have several of them but I only want to show in my report the most recent ones, from the last two years I would say?/

SELECT TOP 100 PERCENT dbo.EmployeeGamingLicense.TM#, dbo.EmployeeGamingLicense.LASTNAME, dbo.EmployeeGamingLicense.FIRSTNAME,
dbo.ActiveConditional_tbl.CONDITIONAL, dbo.ActiveConditional_tbl.DATEOFCONDITIONAL, dbo.ActiveConditional_tbl.INVESTIGATOR_COND,
dbo.ActiveConditional_tbl.REASONFORCOND
FROM dbo.ActiveConditional_tbl INNER JOIN
dbo.EmployeeGamingLicense ON dbo.ActiveConditional_tbl.TM# = dbo.EmployeeGamingLicense.TM#
ORDER BY dbo.EmployeeGamingLicense.LASTNAME|||So what do you want. The most recent record, or the records from the past 2 years (possibly multiple records)?|||I figured it out guys I'm sorry to waste your time, your the BEST|||I figured it out guys I'm sorry to waste your time, your the BESTI know - we are that good. Ever so glad we sorted out the problem for you :D

Adobe Export

What causes blank pages to occur when the report is exported to Adobe?
Currently, no page breaks or repeat header/footer is being used.
Thanks!Your page only needs to be as big as your data on it. I've had that problem
and what I did to fix it was resize my page to fit the layout. I think if
you leave space below or beside your text boxes, the space will show on your
report. I hope this helps.
--Chad
"Terry" wrote:
> What causes blank pages to occur when the report is exported to Adobe?
> Currently, no page breaks or repeat header/footer is being used.
> Thanks!
>|||Your solution to the blank pages being generated when reports are exported to
Adobe worked well.
Thank you so much for your assistance.
"chalexan" wrote:
> Your page only needs to be as big as your data on it. I've had that problem
> and what I did to fix it was resize my page to fit the layout. I think if
> you leave space below or beside your text boxes, the space will show on your
> report. I hope this helps.
> --Chad
> "Terry" wrote:
> > What causes blank pages to occur when the report is exported to Adobe?
> >
> > Currently, no page breaks or repeat header/footer is being used.
> >
> > Thanks!
> >
> >

ADO.NET DataSets as a DataSource

Can I use a ADO dataset as a datasource for a report using Reporting Services
2000? Or will I have to implement a custom data extension. Does anyone know?You have to implement an extension until version 2, then there will be new
web and winform controls.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Aparna" <Aparna@.discussions.microsoft.com> wrote in message
news:819219C0-B02D-470D-BA74-D15A72DD014C@.microsoft.com...
> Can I use a ADO dataset as a datasource for a report using Reporting
Services
> 2000? Or will I have to implement a custom data extension. Does anyone
know?

ADO error: Invalid object name <object name>.

I tried to create a report that is based on a stored procedure and I get this error when I try to verify the SQL.

ADO error: Invalid object name '#MatPatAbsence'.

If I click on the RUN exclaimation mark, I get no data, but do get the column names.

#MatPatAbsence is a temporary table created in the stored procedure and deleted once used.

I have also created another similar report from a stored procedure that has temporary tables and all are working fine.

also this stored procedure runs fine in query analyzer.

Can any one help please?

paste your query, I will take a look

ADO Error Code:0x80040e4d

Hello all,

I use Crystal Report v9, SQL server 2000.
When I try to connect to a Database via ADO, I got the following error.

Login failed.
Details :ADO Error Code:0x80040e4d
Source:Microsoft OLE DB Provider for SQL Server
Description:Login failed for usexxxxxxx
SQL State: 42000
Native Error:18456

Is there anyone how has this problem?
How can I fix this?

Thanks in advance,
Do.

--
Message posted via http://www.sqlmonster.com"Do Park via SQLMonster.com" <forum@.nospam.SQLMonster.com> wrote in message
news:9caa7e6d6eff41c1984f7334221dc753@.SQLMonster.c om...
> Hello all,
>
> I use Crystal Report v9, SQL server 2000.
> When I try to connect to a Database via ADO, I got the following error.
> Login failed.
> Details :ADO Error Code:0x80040e4d
> Source:Microsoft OLE DB Provider for SQL Server
> Description:Login failed for use'xxxxxxx'
> SQL State: 42000
> Native Error:18456
> Is there anyone how has this problem?
> How can I fix this?
> Thanks in advance,
> Do.
> --
> Message posted via http://www.sqlmonster.com

"Login failed" suggests that you need to check the login you're using to
connect with - is it a SQL login, or a Windows account; are you using a DSN
or a connection string; can you connect from osql.exe or Query Analyzer
using the same account (or another account) etc.

Simon|||I use Windows authentication. I can access other databases via the same way
(Crystal Report). I connected this database via ADO successfully two or
three days ago. There was no change in my environment and SQL Server.

Best regards,
Do.

--
Message posted via http://www.sqlmonster.com|||Do Park via SQLMonster.com (forum@.SQLMonster.com) writes:
> I use Windows authentication. I can access other databases via the same
> way (Crystal Report). I connected this database via ADO successfully two
> or three days ago. There was no change in my environment and SQL
> Server.

Probably there was. Unfortunately, it is impossible for us who don't
have access to your environment to tell what is going on. You will
have to see your local admin to sort it out.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp

Administrator with No Report Manager Privileges

I am logged on as a user with administrative privileges to
my machine, to the machine housing the report server
database, and to the the web server, yet when I go to
Report Manager, I do not have access to the Home folder,
only one lower folder, and no Site Settings for anything.
How do I add the necessary privileges if I'm already the
administrator?I found that if you have set the Report Server virtual directory to allow
anonymous access in the IIS mgmt console, you may find yourself in the
situation you described. I was experimenting with anonymous and got into the
situation, where I was a local admin but options like create new folders and
upload files were all gone from Report Manager. After I removed anonymous
access, I was able to fully administer Reporting Services via Report Manager
again.
Linchi
"Terry" <anonymous@.discussions.microsoft.com> wrote in message
news:029c01c47a5e$9cc531a0$a601280a@.phx.gbl...
> I am logged on as a user with administrative privileges to
> my machine, to the machine housing the report server
> database, and to the the web server, yet when I go to
> Report Manager, I do not have access to the Home folder,
> only one lower folder, and no Site Settings for anything.
> How do I add the necessary privileges if I'm already the
> administrator?
>|||Linchi, Thanks for your response and you are correct
about the configuration of anonymous access, however,
this site needs anonymous access. Any suggestions on how
to get my rights back and keep anonymous access?
>--Original Message--
>I found that if you have set the Report Server virtual
directory to allow
>anonymous access in the IIS mgmt console, you may find
yourself in the
>situation you described. I was experimenting with
anonymous and got into the
>situation, where I was a local admin but options like
create new folders and
>upload files were all gone from Report Manager. After I
removed anonymous
>access, I was able to fully administer Reporting
Services via Report Manager
>again.
>Linchi
>"Terry" <anonymous@.discussions.microsoft.com> wrote in
message
>news:029c01c47a5e$9cc531a0$a601280a@.phx.gbl...
>> I am logged on as a user with administrative
privileges to
>> my machine, to the machine housing the report server
>> database, and to the the web server, yet when I go to
>> Report Manager, I do not have access to the Home
folder,
>> only one lower folder, and no Site Settings for
anything.
>> How do I add the necessary privileges if I'm already
the
>> administrator?
>
>.
>|||No, I have not found why or how to work around it. In my case, I didn't
really need anonymous access. I hope MS folks can shed some light on this
behavior.
Linchi
"Terry" <anonymous@.discussions.microsoft.com> wrote in message
news:085c01c47af3$75d2fe20$a301280a@.phx.gbl...
> Linchi, Thanks for your response and you are correct
> about the configuration of anonymous access, however,
> this site needs anonymous access. Any suggestions on how
> to get my rights back and keep anonymous access?
>
> >--Original Message--
> >I found that if you have set the Report Server virtual
> directory to allow
> >anonymous access in the IIS mgmt console, you may find
> yourself in the
> >situation you described. I was experimenting with
> anonymous and got into the
> >situation, where I was a local admin but options like
> create new folders and
> >upload files were all gone from Report Manager. After I
> removed anonymous
> >access, I was able to fully administer Reporting
> Services via Report Manager
> >again.
> >
> >Linchi
> >
> >"Terry" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:029c01c47a5e$9cc531a0$a601280a@.phx.gbl...
> >> I am logged on as a user with administrative
> privileges to
> >> my machine, to the machine housing the report server
> >> database, and to the the web server, yet when I go to
> >> Report Manager, I do not have access to the Home
> folder,
> >> only one lower folder, and no Site Settings for
> anything.
> >> How do I add the necessary privileges if I'm already
> the
> >> administrator?
> >>
> >
> >
> >.
> >|||When you enable anonymous access, all requests come in as the anonymous
user. Since that user does not have any role assignments in the report
server, they cannot see any folders, nor can they perform operations.
We recommend that you do not use anonymous access to the report server, but
enable windows secuirty.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Linchi Shea" <linchi_shea@.NOSPAM.ml.com> wrote in message
news:eBZrcj1eEHA.2028@.tk2msftngp13.phx.gbl...
> No, I have not found why or how to work around it. In my case, I didn't
> really need anonymous access. I hope MS folks can shed some light on this
> behavior.
> Linchi
> "Terry" <anonymous@.discussions.microsoft.com> wrote in message
> news:085c01c47af3$75d2fe20$a301280a@.phx.gbl...
>> Linchi, Thanks for your response and you are correct
>> about the configuration of anonymous access, however,
>> this site needs anonymous access. Any suggestions on how
>> to get my rights back and keep anonymous access?
>>
>> >--Original Message--
>> >I found that if you have set the Report Server virtual
>> directory to allow
>> >anonymous access in the IIS mgmt console, you may find
>> yourself in the
>> >situation you described. I was experimenting with
>> anonymous and got into the
>> >situation, where I was a local admin but options like
>> create new folders and
>> >upload files were all gone from Report Manager. After I
>> removed anonymous
>> >access, I was able to fully administer Reporting
>> Services via Report Manager
>> >again.
>> >
>> >Linchi
>> >
>> >"Terry" <anonymous@.discussions.microsoft.com> wrote in
>> message
>> >news:029c01c47a5e$9cc531a0$a601280a@.phx.gbl...
>> >> I am logged on as a user with administrative
>> privileges to
>> >> my machine, to the machine housing the report server
>> >> database, and to the the web server, yet when I go to
>> >> Report Manager, I do not have access to the Home
>> folder,
>> >> only one lower folder, and no Site Settings for
>> anything.
>> >> How do I add the necessary privileges if I'm already
>> the
>> >> administrator?
>> >>
>> >
>> >
>> >.
>> >
>

Administrator does not have any privileges

I am logged on as a user with administrative privileges to my machine, yet when I go to the Report Manager, I have no tabs or Site Settings. How do I add the necessary privileges if I'm already the administrator?Are you using a custom security extension?
-Lukasz
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in message
news:56D7FB04-7279-4193-A809-E12D46827F6A@.microsoft.com...
> I am logged on as a user with administrative privileges to my machine, yet
when I go to the Report Manager, I have no tabs or Site Settings. How do I
add the necessary privileges if I'm already the administrator?|||No. I have everything set up very generically.
"Lukasz Pawlowski [MSFT]" wrote:
> Are you using a custom security extension?
> -Lukasz
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in message
> news:56D7FB04-7279-4193-A809-E12D46827F6A@.microsoft.com...
> > I am logged on as a user with administrative privileges to my machine, yet
> when I go to the Report Manager, I have no tabs or Site Settings. How do I
> add the necessary privileges if I'm already the administrator?
>
>|||Are you loggedin locally? Your user is a memeber of the local
administrators group?
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in message
news:EC031FF7-BDCB-46B4-98E2-2E8787C030A6@.microsoft.com...
> No. I have everything set up very generically.
> "Lukasz Pawlowski [MSFT]" wrote:
> > Are you using a custom security extension?
> >
> > -Lukasz
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> >
> > "Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in message
> > news:56D7FB04-7279-4193-A809-E12D46827F6A@.microsoft.com...
> > > I am logged on as a user with administrative privileges to my machine,
yet
> > when I go to the Report Manager, I have no tabs or Site Settings. How
do I
> > add the necessary privileges if I'm already the administrator?
> >
> >
> >|||Yes. I am logged on as a member of the Administrators group. Thanks!
"Lukasz Pawlowski [MSFT]" wrote:
> Are you loggedin locally? Your user is a memeber of the local
> administrators group?
> -Lukasz
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in message
> news:EC031FF7-BDCB-46B4-98E2-2E8787C030A6@.microsoft.com...
> > No. I have everything set up very generically.
> >
> > "Lukasz Pawlowski [MSFT]" wrote:
> >
> > > Are you using a custom security extension?
> > >
> > > -Lukasz
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > >
> > > "Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in message
> > > news:56D7FB04-7279-4193-A809-E12D46827F6A@.microsoft.com...
> > > > I am logged on as a user with administrative privileges to my machine,
> yet
> > > when I go to the Report Manager, I have no tabs or Site Settings. How
> do I
> > > add the necessary privileges if I'm already the administrator?
> > >
> > >
> > >
>
>|||Was this ever resolved? I am having the same problem.
>--Original Message--
>Yes. I am logged on as a member of the Administrators
group. Thanks!
>"Lukasz Pawlowski [MSFT]" wrote:
>> Are you loggedin locally? Your user is a memeber of
the local
>> administrators group?
>> -Lukasz
>>
>> --
>> This posting is provided "AS IS" with no warranties,
and confers no rights.
>>
>> "Patrick_McD" <Patrick_McD@.discussions.microsoft.com>
wrote in message
>> news:EC031FF7-BDCB-46B4-98E2-
2E8787C030A6@.microsoft.com...
>> > No. I have everything set up very generically.
>> >
>> > "Lukasz Pawlowski [MSFT]" wrote:
>> >
>> > > Are you using a custom security extension?
>> > >
>> > > -Lukasz
>> > >
>> > > --
>> > > This posting is provided "AS IS" with no
warranties, and confers no
>> rights.
>> > >
>> > >
>> > >
>> > > "Patrick_McD"
<Patrick_McD@.discussions.microsoft.com> wrote in message
>> > > news:56D7FB04-7279-4193-A809-
E12D46827F6A@.microsoft.com...
>> > > > I am logged on as a user with administrative
privileges to my machine,
>> yet
>> > > when I go to the Report Manager, I have no tabs or
Site Settings. How
>> do I
>> > > add the necessary privileges if I'm already the
administrator?
>> > >
>> > >
>> > >
>>
>.
>|||Are the /reportserver and /reports virtual directories configured to use
integrated security and *no* anonymous access?
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Patrick_McD" <PatrickMcD@.discussions.microsoft.com> wrote in message
news:3086AADF-A3F3-4698-88E1-5AE6B2689424@.microsoft.com...
> Yes. I am logged on as a member of the Administrators group. Thanks!
> "Lukasz Pawlowski [MSFT]" wrote:
> > Are you loggedin locally? Your user is a memeber of the local
> > administrators group?
> >
> > -Lukasz
> >
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> >
> > "Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in message
> > news:EC031FF7-BDCB-46B4-98E2-2E8787C030A6@.microsoft.com...
> > > No. I have everything set up very generically.
> > >
> > > "Lukasz Pawlowski [MSFT]" wrote:
> > >
> > > > Are you using a custom security extension?
> > > >
> > > > -Lukasz
> > > >
> > > > --
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > >
> > > >
> > > >
> > > > "Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in
message
> > > > news:56D7FB04-7279-4193-A809-E12D46827F6A@.microsoft.com...
> > > > > I am logged on as a user with administrative privileges to my
machine,
> > yet
> > > > when I go to the Report Manager, I have no tabs or Site Settings.
How
> > do I
> > > > add the necessary privileges if I'm already the administrator?
> > > >
> > > >
> > > >
> >
> >
> >|||Tudor;
There is another thread on this same issue. I wonder whether you know why
setting anonymous access would result in this behavior, and whether there is
a way to retain both the admin privileges for the local admin and anonymous
access.
Linchi
"Tudor Trufinescu (MSFT)" <tudortr@.ms.com> wrote in message
news:eyJlrcyeEHA.2848@.TK2MSFTNGP10.phx.gbl...
> Are the /reportserver and /reports virtual directories configured to use
> integrated security and *no* anonymous access?
> --
> Tudor Trufinescu
> Dev Lead
> Sql Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> "Patrick_McD" <PatrickMcD@.discussions.microsoft.com> wrote in message
> news:3086AADF-A3F3-4698-88E1-5AE6B2689424@.microsoft.com...
> > Yes. I am logged on as a member of the Administrators group. Thanks!
> >
> > "Lukasz Pawlowski [MSFT]" wrote:
> >
> > > Are you loggedin locally? Your user is a memeber of the local
> > > administrators group?
> > >
> > > -Lukasz
> > >
> > >
> > > --
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > >
> > > "Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in message
> > > news:EC031FF7-BDCB-46B4-98E2-2E8787C030A6@.microsoft.com...
> > > > No. I have everything set up very generically.
> > > >
> > > > "Lukasz Pawlowski [MSFT]" wrote:
> > > >
> > > > > Are you using a custom security extension?
> > > > >
> > > > > -Lukasz
> > > > >
> > > > > --
> > > > > This posting is provided "AS IS" with no warranties, and confers
no
> > > rights.
> > > > >
> > > > >
> > > > >
> > > > > "Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in
> message
> > > > > news:56D7FB04-7279-4193-A809-E12D46827F6A@.microsoft.com...
> > > > > > I am logged on as a user with administrative privileges to my
> machine,
> > > yet
> > > > > when I go to the Report Manager, I have no tabs or Site Settings.
> How
> > > do I
> > > > > add the necessary privileges if I'm already the administrator?
> > > > >
> > > > >
> > > > >
> > >
> > >
> > >
>|||Yes, allowing anonymous access would result in this behavior.
Allowing anonymous access means all users will be seen as the same user, the
server won't even ask them to provide their authentication information.
You can't have both anonymous and non anonymous on the same virtual
directories. I presume you could create two virtual directories one allowing
anonymous access, the other not.
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Linchi Shea" <linchi_shea@.NOSPAM.ml.com> wrote in message
news:ebSCkhBfEHA.3520@.TK2MSFTNGP10.phx.gbl...
> Tudor;
> There is another thread on this same issue. I wonder whether you know why
> setting anonymous access would result in this behavior, and whether there
is
> a way to retain both the admin privileges for the local admin and
anonymous
> access.
> Linchi
> "Tudor Trufinescu (MSFT)" <tudortr@.ms.com> wrote in message
> news:eyJlrcyeEHA.2848@.TK2MSFTNGP10.phx.gbl...
> > Are the /reportserver and /reports virtual directories configured to use
> > integrated security and *no* anonymous access?
> >
> > --
> > Tudor Trufinescu
> > Dev Lead
> > Sql Server Reporting Services
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> > "Patrick_McD" <PatrickMcD@.discussions.microsoft.com> wrote in message
> > news:3086AADF-A3F3-4698-88E1-5AE6B2689424@.microsoft.com...
> > > Yes. I am logged on as a member of the Administrators group. Thanks!
> > >
> > > "Lukasz Pawlowski [MSFT]" wrote:
> > >
> > > > Are you loggedin locally? Your user is a memeber of the local
> > > > administrators group?
> > > >
> > > > -Lukasz
> > > >
> > > >
> > > > --
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > >
> > > >
> > > >
> > > > "Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in
message
> > > > news:EC031FF7-BDCB-46B4-98E2-2E8787C030A6@.microsoft.com...
> > > > > No. I have everything set up very generically.
> > > > >
> > > > > "Lukasz Pawlowski [MSFT]" wrote:
> > > > >
> > > > > > Are you using a custom security extension?
> > > > > >
> > > > > > -Lukasz
> > > > > >
> > > > > > --
> > > > > > This posting is provided "AS IS" with no warranties, and confers
> no
> > > > rights.
> > > > > >
> > > > > >
> > > > > >
> > > > > > "Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in
> > message
> > > > > > news:56D7FB04-7279-4193-A809-E12D46827F6A@.microsoft.com...
> > > > > > > I am logged on as a user with administrative privileges to my
> > machine,
> > > > yet
> > > > > > when I go to the Report Manager, I have no tabs or Site
Settings.
> > How
> > > > do I
> > > > > > add the necessary privileges if I'm already the administrator?
> > > > > >
> > > > > >
> > > > > >
> > > >
> > > >
> > > >
> >
> >
>|||Tudor;
Could you please elaborate how you can create two virtual directories and
work the way you described, when it comes to Reporting Services?
Linchi
"Tudor Trufinescu (MSFT)" <tudortr@.ms.com> wrote in message
news:uXhU5KKfEHA.140@.TK2MSFTNGP12.phx.gbl...
> Yes, allowing anonymous access would result in this behavior.
> Allowing anonymous access means all users will be seen as the same user,
the
> server won't even ask them to provide their authentication information.
> You can't have both anonymous and non anonymous on the same virtual
> directories. I presume you could create two virtual directories one
allowing
> anonymous access, the other not.
> --
> Tudor Trufinescu
> Dev Lead
> Sql Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "Linchi Shea" <linchi_shea@.NOSPAM.ml.com> wrote in message
> news:ebSCkhBfEHA.3520@.TK2MSFTNGP10.phx.gbl...
> > Tudor;
> >
> > There is another thread on this same issue. I wonder whether you know
why
> > setting anonymous access would result in this behavior, and whether
there
> is
> > a way to retain both the admin privileges for the local admin and
> anonymous
> > access.
> >
> > Linchi
> >
> > "Tudor Trufinescu (MSFT)" <tudortr@.ms.com> wrote in message
> > news:eyJlrcyeEHA.2848@.TK2MSFTNGP10.phx.gbl...
> > > Are the /reportserver and /reports virtual directories configured to
use
> > > integrated security and *no* anonymous access?
> > >
> > > --
> > > Tudor Trufinescu
> > > Dev Lead
> > > Sql Server Reporting Services
> > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > >
> > > "Patrick_McD" <PatrickMcD@.discussions.microsoft.com> wrote in message
> > > news:3086AADF-A3F3-4698-88E1-5AE6B2689424@.microsoft.com...
> > > > Yes. I am logged on as a member of the Administrators group.
Thanks!
> > > >
> > > > "Lukasz Pawlowski [MSFT]" wrote:
> > > >
> > > > > Are you loggedin locally? Your user is a memeber of the local
> > > > > administrators group?
> > > > >
> > > > > -Lukasz
> > > > >
> > > > >
> > > > > --
> > > > > This posting is provided "AS IS" with no warranties, and confers
no
> > > rights.
> > > > >
> > > > >
> > > > >
> > > > > "Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in
> message
> > > > > news:EC031FF7-BDCB-46B4-98E2-2E8787C030A6@.microsoft.com...
> > > > > > No. I have everything set up very generically.
> > > > > >
> > > > > > "Lukasz Pawlowski [MSFT]" wrote:
> > > > > >
> > > > > > > Are you using a custom security extension?
> > > > > > >
> > > > > > > -Lukasz
> > > > > > >
> > > > > > > --
> > > > > > > This posting is provided "AS IS" with no warranties, and
confers
> > no
> > > > > rights.
> > > > > > >
> > > > > > >
> > > > > > >
> > > > > > > "Patrick_McD" <Patrick_McD@.discussions.microsoft.com> wrote in
> > > message
> > > > > > > news:56D7FB04-7279-4193-A809-E12D46827F6A@.microsoft.com...
> > > > > > > > I am logged on as a user with administrative privileges to
my
> > > machine,
> > > > > yet
> > > > > > > when I go to the Report Manager, I have no tabs or Site
> Settings.
> > > How
> > > > > do I
> > > > > > > add the necessary privileges if I'm already the administrator?
> > > > > > >
> > > > > > >
> > > > > > >
> > > > >
> > > > >
> > > > >
> > >
> > >
> >
> >
>

Administrator cannot see administration toolbar, buttons and shortcuts on Report Manager

Hy everybody.

I have recently installed from scratch RS 2003 on a WIN2003 SRV and got that the problem that the administrator cannot access or even see the regular administration toolbar and links at the Report Manager, such as Site Configuration, Upload New File, the common 'Contents | Properties ' tab, among other stuff. The only options available are 'Home', 'My Subscriptions' and 'Help', in the right superior link bar. I find this behaviour very strange, since the RS comes right out of the box configured with full access to administrator, but right now I CAN'T do any administration task on the RS Server.

Another strange behaviours I've found:
- The few links that appear redirect to the internal ip address of the server.
- When you call the '/ReportServer/ReportingService.asmx' it returns an XML document, not the usual browsing interface.

There's some information about the server configuration I think it might help:
- IIS is running more than one website, and the RS server is not installed on the Default WebSite, wich is stopped.
- SharePoint Services is running in the server, but not in the DefaultWebSite.
- The security settings of the virtual directory of the Report Manager are configured to use Windows Authentication and are NOT configured to use anonymous authentication.
- The server is published to the Internet.

There's some stuff that I tried and for now didn't worked:
- Create the virtual directories in other websites.
- Switch the attributes of the 'impersonate' attribute in Web.config file between true and false.
- Enable anonymous authentication and use the administrator account to impersonate.
- The steps described in the help article 'Troubleshooting a Side-by-Side Installation of Reporting Services and Windows SharePoint Services'
- Reinstalling the RS product.

I really hope you guys can help me with this.

Thanks in advance.
JCAlthough you said your Report Manager is configured for WIndows auth, is your Report Server directory the same way? Anonymous is not on either one?

Administration Of Reporting Services

Books online talk about a report manager page to monitor and administrator running job, subscriptions etc...

But I use Reporting Servcies in sharepoint administration mode? Where do I go to see something similiar?

Thanks

Try putting the url below into an Internet Explorer address bar and click on go. It should pull up Report Manager for you.

For default SQL Server instances use this:

http://localhost/reports/Pages/Folder.aspx <-- substitute your web server name for localhost

For named SQL Server instances use this:

http://localhost/reports$InstanceName/Pages/Folder.aspx <-- substitued your web server name for localhost and your SQL Server instance name for InstanceName

|||

This do not work becuase as soon as you run in sharepoint integrated mode, you loose the report manager functionality. Actually, an error is returned if you try to navigate to that page.

Frank

Admin rights to Report Manager disappeared...?

Hi,
Out of the blue I have lost administration rights to RS Report Manager. I
can no longer access several reports (others do work). When I connect to the
Report Manager the GUI is displayed, but I can't access all of the usual tabs
(ie. under the properties tab I can only see the 'General' and 'Security'
options, nothing else.)
I've tried accessing Report Manager via a client with domain admin rights
and via the RS server with local admin rights still the same problem...
Can anybody get me started on troubleshooting?
Kind Regards,
Casey.Casey,
I had this same problem...everything worked fine and then out of the
blue I couldn't update reports, deploy new reports, log into Report
Manager. I discovered that in Computer Management console when I Right
clicked on Default Web Site and went into Properties, then Directory
Security, then clicked on Anonymous Access and Authentication control,
and clicked the Edit button, that I did have Anonymous Access set.
When I tried to remote into that web server and perform changes I was
getting logged in as the anonymous user account with the limited rights
I gave that account. After hours when I'm working on the web server
now, I turn the anonymous option off, Restart IIS and do my
work...finally with the proper rights.
I hope this helps...
Jeff

AdjustTokenPrivileges () failed (00000514)

hello,

I am running into a problem in Report Server 2005. When I add a subreport to an existing report, when I navigate to a different page of the report, I get the following in SQLDUMPER_ERRORLOG.log:

AdjustTokenPrivileges () failed (00000514)
Input parameters: 4 supplied
ProcessID = 576
ThreadId = 0
Flags = 0x0
MiniDumpFlags = 0x0
SqlInfoPtr = 0x04E75860
DumpDir = <NULL>
ExceptionRecordPtr = 0x00000000
ContextPtr = 0x00000000
ExtraFile = <NULL>
InstanceName = <NULL>
ServiceName = <NULL>

Without the subreport, the page navigation works fine. The parameter between the reports is a numeric id. The report is current running on SQL Server 2005, SP1. Does anyone know of a workaround?

Thanks in advaced.

Young Shen

I ended up installing SQL Server 2005 SP2, which resolved the issue. Apparently this is a known bug that has been fixed.

Thanks.

Young