Report error

Hi all,

I just setup SQL 2005 Report Service, and then I used the browser to view the "folder.aspx"

Nothing showed up but I received an error page with the message like the following:

"The request failed with HTTP status 400: Bad Request."

So, what did I do wrong?

Thanks,

Frank

System Engineer

Start debugging with your http://localhost/reportserver. How were the RS virtual directories created? Try creating them using the configuration tools, and re-apply the script mappings.|||If the suggestions from James is not working, try to dive deeper into the error of the reporting services engine, by setting the logging mode to verbose and see where the error is based on. If you have a blank report server with not much reports one, try to reinstall the whole thing, that is sometimes better than (try) fixing the issues that popup. I had that a while ago, the cause was that there were file locks on the files that needed to be changed. The installer didn′t pop up a message and *bump* there were many erros coming up regarding authentication etc.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de

Report Builder Security Filter Examples

Does anyone have any examples on how to use the security filters in
report builder models. Do you setup a standard filter. How do you pass
the user back to the server in the query?
ThanksI have the same type of question...I need to be able to pass parameters
(userid) back to my model due to security setup in our system...we have
several 'user-access' tables for varying levels of security. For
example, any given user has access to specific accounts, but only
certain members within that account and only specific coverages within
those members. I don't see how I can set this up using roles but
perhaps I'm just missing it.|||the getuserid() function can be used... but... reportbuilder keep in cache
the first user which access a filter object where the getuserid() function
is used!!!
so if an "administrator" try the model, then every other users use the same
access!!!
but using the getuserid() into reportbuilder himself (the user create a
report and explicitly setup a filter) then the ID used is the right one, but
its not a good solution.
I'll do some other tests and keep you informed.
"tim" <tbush@.ccmsi.com> wrote in message
news:1141664357.097038.87240@.i40g2000cwc.googlegroups.com...
>I have the same type of question...I need to be able to pass parameters
> (userid) back to my model due to security setup in our system...we have
> several 'user-access' tables for varying levels of security. For
> example, any given user has access to specific accounts, but only
> certain members within that account and only specific coverages within
> those members. I don't see how I can set this up using roles but
> perhaps I'm just missing it.
>|||I will be posting an entry on my blog (http://blogs.msdn.com/bobmeyers)
shortly explaining how to use security filters.
FYI, the incorrect behavior of the GETUSERID() function is a known issue
that is fixed in SP1, which will be available shortly.
"Jéjé" wrote:
> the getuserid() function can be used... but... reportbuilder keep in cache
> the first user which access a filter object where the getuserid() function
> is used!!!
> so if an "administrator" try the model, then every other users use the same
> access!!!
> but using the getuserid() into reportbuilder himself (the user create a
> report and explicitly setup a filter) then the ID used is the right one, but
> its not a good solution.
> I'll do some other tests and keep you informed.
>
> "tim" <tbush@.ccmsi.com> wrote in message
> news:1141664357.097038.87240@.i40g2000cwc.googlegroups.com...
> >I have the same type of question...I need to be able to pass parameters
> > (userid) back to my model due to security setup in our system...we have
> > several 'user-access' tables for varying levels of security. For
> > example, any given user has access to specific accounts, but only
> > certain members within that account and only specific coverages within
> > those members. I don't see how I can set this up using roles but
> > perhaps I'm just missing it.
> >
>
>|||thanks!
your blog appear to be great and usefull.
favorites favorites... ;-)
"Bob Meyers - MSFT" <BobMeyersMSFT@.discussions.microsoft.com> wrote in
message news:D083E8EC-F89C-4E6A-AE99-0BEFDE4F877B@.microsoft.com...
>I will be posting an entry on my blog (http://blogs.msdn.com/bobmeyers)
> shortly explaining how to use security filters.
> FYI, the incorrect behavior of the GETUSERID() function is a known issue
> that is fixed in SP1, which will be available shortly.
> "Jéjé" wrote:
>> the getuserid() function can be used... but... reportbuilder keep in
>> cache
>> the first user which access a filter object where the getuserid()
>> function
>> is used!!!
>> so if an "administrator" try the model, then every other users use the
>> same
>> access!!!
>> but using the getuserid() into reportbuilder himself (the user create a
>> report and explicitly setup a filter) then the ID used is the right one,
>> but
>> its not a good solution.
>> I'll do some other tests and keep you informed.
>>
>> "tim" <tbush@.ccmsi.com> wrote in message
>> news:1141664357.097038.87240@.i40g2000cwc.googlegroups.com...
>> >I have the same type of question...I need to be able to pass parameters
>> > (userid) back to my model due to security setup in our system...we have
>> > several 'user-access' tables for varying levels of security. For
>> > example, any given user has access to specific accounts, but only
>> > certain members within that account and only specific coverages within
>> > those members. I don't see how I can set this up using roles but
>> > perhaps I'm just missing it.
>> >
>>|||Thanks Bob...I look forward to it...I am stumped.
J=E9j=E9 wrote:
> thanks!
> your blog appear to be great and usefull.
> favorites favorites... ;-)
> "Bob Meyers - MSFT" <BobMeyersMSFT@.discussions.microsoft.com> wrote in
> message news:D083E8EC-F89C-4E6A-AE99-0BEFDE4F877B@.microsoft.com...
> >I will be posting an entry on my blog (http://blogs.msdn.com/bobmeyers)
> > shortly explaining how to use security filters.
> >
> > FYI, the incorrect behavior of the GETUSERID() function is a known issue
> > that is fixed in SP1, which will be available shortly.
> >
> > "J=E9j=E9" wrote:
> >
> >> the getuserid() function can be used... but... reportbuilder keep in
> >> cache
> >> the first user which access a filter object where the getuserid()
> >> function
> >> is used!!!
> >>
> >> so if an "administrator" try the model, then every other users use the
> >> same
> >> access!!!
> >> but using the getuserid() into reportbuilder himself (the user create a
> >> report and explicitly setup a filter) then the ID used is the right on=e,
> >> but
> >> its not a good solution.
> >>
> >> I'll do some other tests and keep you informed.
> >>
> >>
> >> "tim" <tbush@.ccmsi.com> wrote in message
> >> news:1141664357.097038.87240@.i40g2000cwc.googlegroups.com...
> >> >I have the same type of question...I need to be able to pass paramete=rs
> >> > (userid) back to my model due to security setup in our system...we h=ave
> >> > several 'user-access' tables for varying levels of security. For
> >> > example, any given user has access to specific accounts, but only
> >> > certain members within that account and only specific coverages with=in
> >> > those members. I don't see how I can set this up using roles but
> >> > perhaps I'm just missing it.
> >> >
> >>
> >>
> >>|||how can I get SQL userid into the model rather than the Windows ID?|||to use the SQL Server user id , use SQL servers syntaxes (suser_sname or
user_name and other user_id functions)
"tim" <bush.timothy@.gmail.com> wrote in message
news:1144296426.518067.71590@.i40g2000cwc.googlegroups.com...
> how can I get SQL userid into the model rather than the Windows ID?
>|||thanks...was finally able to use SUSER_SNAME(SUSER_SID()) to get what I
needed. Now I'm trying to get the filters to work with it.|||Note that with the SP1 version of BOL (which will be available for download
when SP1 is released), there is a tutorial that walks you through how to set
up security filters using the GetUserID().
"tim" wrote:
> Thanks Bob...I look forward to it...I am stumped.
> Jéjé wrote:
> > thanks!
> >
> > your blog appear to be great and usefull.
> > favorites favorites... ;-)
> >
> > "Bob Meyers - MSFT" <BobMeyersMSFT@.discussions.microsoft.com> wrote in
> > message news:D083E8EC-F89C-4E6A-AE99-0BEFDE4F877B@.microsoft.com...
> > >I will be posting an entry on my blog (http://blogs.msdn.com/bobmeyers)
> > > shortly explaining how to use security filters.
> > >
> > > FYI, the incorrect behavior of the GETUSERID() function is a known issue
> > > that is fixed in SP1, which will be available shortly.
> > >
> > > "Jéjé" wrote:
> > >
> > >> the getuserid() function can be used... but... reportbuilder keep in
> > >> cache
> > >> the first user which access a filter object where the getuserid()
> > >> function
> > >> is used!!!
> > >>
> > >> so if an "administrator" try the model, then every other users use the
> > >> same
> > >> access!!!
> > >> but using the getuserid() into reportbuilder himself (the user create a
> > >> report and explicitly setup a filter) then the ID used is the right one,
> > >> but
> > >> its not a good solution.
> > >>
> > >> I'll do some other tests and keep you informed.
> > >>
> > >>
> > >> "tim" <tbush@.ccmsi.com> wrote in message
> > >> news:1141664357.097038.87240@.i40g2000cwc.googlegroups.com...
> > >> >I have the same type of question...I need to be able to pass parameters
> > >> > (userid) back to my model due to security setup in our system...we have
> > >> > several 'user-access' tables for varying levels of security. For
> > >> > example, any given user has access to specific accounts, but only
> > >> > certain members within that account and only specific coverages within
> > >> > those members. I don't see how I can set this up using roles but
> > >> > perhaps I'm just missing it.
> > >> >
> > >>
> > >>
> > >>
>

Report Builder grouping?

Hello,
I am experiencing some funky (yes, that is a technical term) behavior with
SSRS 2005 Report Builder. I have a model setup with some of the fields set
to have their DiscourageGrouping property equal to True and some with it to
False. It seems that only SOMETIMES, when I add the fields with the
DiscourageGrouping set to TRUE to the report it wants to create a new group
for me.
I understand that this is the behavior when you add the columns to the left
of the other fields on the report (I think that the documentation refers to
this as a Value Group). BUT this is happending when I add the field as the
first item on the report. Each subsequent field I add to the left on the
report is inserted to another "main" group...
One note about my Report Model. It was created off a SQL View, not a bunch
of tables (tables probably being the more widely used situation).
Any idea what might be causing this strange behavior?
Anywhere I can go for more information on Report Builder usage? I haven't
found a whole lot of documentation on the usage of the product out there
(other than what is in BOL).
Thanks!
-BrianOK...I know what it is doing to me...but I don't know if it is a bug or if it
was intended to act this way...
Whenever the first field on the report is defined in the Report Model with
DiscourageGrouping = False, it creates a group even though I want it
displayed with the rest of the data. When DiscourageGrouping = True, the
field will not, by default, create it's own group when it is the first field
on the report.
For example, suppose I have 3 fields in my Report Model (AccountName, State,
City, Zip). I have AccountName and State defined as DiscourageGrouping =False b/c the users may want to group on these fields sometimes, but not all
the time (when I set DiscourageGrouping = True, it looks like I can never
group on the field).
When a report creator, using Report Builder (not Repot Designer!!), to
create a report and drops AccountName on the report first, it creates a group
for AccountName. When the user adds fields to the right of the AccountName
field, the fields are in a separate group. If the user just wants a listing
of all Accounts with their addresses, with no Groupings, and they want
AccountName as the first field in the group, how is this possible'
Thanks!
-Brian
"brianpmccullough" wrote:
> Hello,
> I am experiencing some funky (yes, that is a technical term) behavior with
> SSRS 2005 Report Builder. I have a model setup with some of the fields set
> to have their DiscourageGrouping property equal to True and some with it to
> False. It seems that only SOMETIMES, when I add the fields with the
> DiscourageGrouping set to TRUE to the report it wants to create a new group
> for me.
> I understand that this is the behavior when you add the columns to the left
> of the other fields on the report (I think that the documentation refers to
> this as a Value Group). BUT this is happending when I add the field as the
> first item on the report. Each subsequent field I add to the left on the
> report is inserted to another "main" group...
> One note about my Report Model. It was created off a SQL View, not a bunch
> of tables (tables probably being the more widely used situation).
> Any idea what might be causing this strange behavior?
> Anywhere I can go for more information on Report Builder usage? I haven't
> found a whole lot of documentation on the usage of the product out there
> (other than what is in BOL).
> Thanks!
> -Brian

report builder button missing

I have setup the RS on production server ( a named instance). The report
builder button is missing. I only can see new folder, new data source, upload
button on the http://servername/reports$instancename/Pages/Folder.aspx. I
have given myself all the rights in role setting.
I have searched in google. However only found something saying "by setting
the report server system property EnableReportDesignClientDownload to true".
However not found anything saying how to do that. checked every sql 2005
configuration tool. Not found anything to let you set that property.
Besides I have tried using
http://<servername>/reportserver/reportbuilder/reportbuilder.application
launched reportbuilder. And got permission ...insufficient (rsAccessDenied).
My project due tomorrow. Please Help!! really appreciate it!!On May 29, 5:02 pm, Daisy <diy...@.msnews.group.post> wrote:
> I have setup the RS on production server ( a named instance). The report
> builder button is missing. I only can see new folder, new data source, upload
> button on thehttp://servername/reports$instancename/Pages/Folder.aspx. I
> have given myself all the rights in role setting.
> I have searched in google. However only found something saying "by setting
> the report server system property EnableReportDesignClientDownload to true".
> However not found anything saying how to do that. checked every sql 2005
> configuration tool. Not found anything to let you set that property.
> Besides I have tried using
> http://<servername>/reportserver/reportbuilder/reportbuilder.application
> launched reportbuilder. And got permission ...insufficient (rsAccessDenied).
> My project due tomorrow. Please Help!! really appreciate it!!
Go to Site Settings from the Report Manager page. Select 'Configure
system-level role definitions'
and edit an existing system role or create a new system role that
includes the Execute Report Definitions task. Then make sure your
user ID is assigned that system role.
HTH
toolman|||That really helps. Thanks a bunch!
"toolman" wrote:
> On May 29, 5:02 pm, Daisy <diy...@.msnews.group.post> wrote:
> > I have setup the RS on production server ( a named instance). The report
> > builder button is missing. I only can see new folder, new data source, upload
> > button on thehttp://servername/reports$instancename/Pages/Folder.aspx. I
> > have given myself all the rights in role setting.
> > I have searched in google. However only found something saying "by setting
> > the report server system property EnableReportDesignClientDownload to true".
> > However not found anything saying how to do that. checked every sql 2005
> > configuration tool. Not found anything to let you set that property.
> >
> > Besides I have tried using
> > http://<servername>/reportserver/reportbuilder/reportbuilder.application
> > launched reportbuilder. And got permission ...insufficient (rsAccessDenied).
> >
> > My project due tomorrow. Please Help!! really appreciate it!!
> Go to Site Settings from the Report Manager page. Select 'Configure
> system-level role definitions'
> and edit an existing system role or create a new system role that
> includes the Execute Report Definitions task. Then make sure your
> user ID is assigned that system role.
> HTH
> toolman
>

Report Access over the internet

Hi,

I need to install and setup accounts so that external users can see the reports

over the internet. The SQL Server is behind a firewall and SSRS 2000 will be on a separate machine.

Would someone know how I can install RS and what kind of accounts need to be created and set up so users outside the network can see the reports?

Very much appreciate your help!

Take a look at using Forms Authentication with Reporting Services. This is the recommended way to access reports from the internet. There are other ways(enabling Anon access), but they are not recommended.

http://msdn2.microsoft.com/en-us/library/ms152899.aspx

http://blogs.msdn.com/bimusings/archive/2005/08/04/447939.aspx

replications and stored procedures and sa account

I have just setup my first Transactional replication between twoservers. Next I needed to test what would happen if the live serverwent down.
I disconnected the live server and connected it to the backup server(doing all the ip setup bits as well). Then I tried running my web app.
The web app ran great. I can look at the data that was replicated. Myproblem is that I cannot seem to add any data. Ever time I try to run astored procedure, the web app crashes with 'sa' account login failed. Itried running the stored procedures through SQL Query Analyzer, and itsays the same thing.
I know there is no problem with the sa account, as I can view the datausing this. There are no permissions set on any of the objects in thedatabase. The only thing I can think of is that the replication hassomehow disabled the ability to add data to the replicated database.
Can anyone point out what is happening?
Foundan MSDN article which explains why this is happening. Solve the problem.

replication--alternate snapshot location folder-- question

Hello.
I am needing to setup replication for some
pretty big tables. My distributor has
limited space on it. I was wondering if I
can redirect the snapshot location folder
using the options under properties. Answer
is yes, but my question is once the snap
shot has been done and moved over to the
subsriber, is this data then removed from
the original snapshot location? Does it
need to get back to this directory at a
later time for any part of syncing? Or is
it once the snapshot is done and has been
applied, I can go remove that snapshot
location without worries?
Thanks,
I just checked this for you - copying then deleting the original snapshot
files before running the merge agent, and synchronization worked without any
issues.
Regards,
Paul Ibison
|||In article <#sYdrSAfEHA.396
@.TK2MSFTNGP12.phx.gbl>,
Paul.Ibison@.Pygmalion.Com says...
> I just checked this for you - copying then deleting the original snapshot
> files before running the merge agent, and synchronization worked without any
> issues.
> Regards,
> Paul Ibison
>
>
yes, i was able to do this as well. Thanks
for looking at this.. i actually had really
good luck this weekend with using an
alternate snapshot location. One thing I
noticed is that you have to stage the
snapshot agents out a little bit. i was
running too many at once and it would cause
some problems.
thanks,
comb

Replication/mirroring on tables without a primary key

One of my clients is using an SQL Server 2000 database provided by a
third party. I attempted to setup transactional replication, but this
failed as a number of their tables do not have primary keys.
What they are really after is simply a mirrored database for reporting
purposes. So far, my position is that this cannot be done unless:-
(1) The vendor adds primary keys to the database
(2) The vendor upgrades to 2005 (and then I can use mirroring)
Notes:
A. I have discounted using snapshot replication due to the dynamic
nature of some of the tables that don't have a primary key
B. Although I can change the database schema myself to set the primary
keys, I do not want to do this as the vendor wont support the app, it
is risky and would involve a lot of work.
Are there any other solutions to this? eg third party products?
You could use log shipping in standby mode for this if you can control when
the reports are accessed. The main problem is that the restore of the logs
will drop all user connections, but in some cases this can be manageable.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Thanks Paul
I discounted log shipping as the interface is via the web and we
cant/dont want to drop user connections.
On Jan 24, 11:14 pm, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> You could use log shipping in standby mode for this if you can control when
> the reports are accessed. The main problem is that the restore of the logs
> will drop all user connections, but in some cases this can be manageable.
> Cheers,
> Paul Ibison SQL Server MVP,www.replicationanswers.com.
|||In that case I'd upgrade to SQL Server 2005 and use mirroring/database
snapshots. Can't see another option as the requirements are incompatible
with current options
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||You mention manageable regarding the user connections, I see a couple
of options here:
(1) More frequent logs (eg 15 mins). This would minimise the risk of
getting disconnected as applying the transactions would be very quick
AND/OR (2) Build a level of fault tolerance into the s/w so that if
they get the message regarding disconnected because of the transaction
log being applied, the s/w retries.
Is this the sort of thing you were meaning?
On Jan 25, 5:22 pm, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> In that case I'd upgrade to SQL Server 2005 and use mirroring/database
> snapshots. Can't see another option as the requirements are incompatible
> with current options
> Cheers,
> Paul Ibison SQL Server MVP,www.replicationanswers.com.
|||I was really thinking of latency. If you can allow say a day's latency, you
could ship the logs each evening during the out of hours time and this way
keep things going.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com .
|||Thanks so much for your feedback Paul, I really appreciate it.
Unfortunately, the day's latency is unacceptable by the client. I did
try that initially but with no luck. They need data to be no more than
30mins late.
So given that log-shipping is the only possible alternative for SQL
Server 2000, I need to give the developers/query writers some guidance
on how they need to develop in this regime. So far, what I have been
thinking was:
(1) When developing SQL queries don't develop using the server that
uses log shipping as you will frequently lose your connection.
(2) In the application, do not keep keep connections open
unnecessarily. Open the connection,. perform the query and close the
connection as quick as possible. I am assuming 'pooled connections'
are still the best way to go.
(3) Try and build in fault tolerance into the application, ie if you
cannot open a connection, then retry within a set period. Also, if you
get an error when executing your query, close the connection (if you
can) and retry. Finally, if you cant close the connection, then just
ignore.
(4) Keep your queries short and snappy and avoid cursors.
Is there any white paper or guidance from Microsoft on this issue or
anyone with practical experience in running an app against a database
that uses 'log shipping'?
On Jan 25, 7:11 pm, "Paul Ibison" <Paul.Ibi...@.Pygmalion.Com> wrote:
> I was really thinking of latency. If you can allow say a day's latency, you
> could ship the logs each evening during the out of hours time and this way
> keep things going.
> Cheers,
> Paul Ibison SQL Server MVP,www.replicationanswers.com.
|||You could set the rowguid column that is used by replication as the
primary key - just don't make it clustered.
PromisedOyster wrote:
> One of my clients is using an SQL Server 2000 database provided by a
> third party. I attempted to setup transactional replication, but this
> failed as a number of their tables do not have primary keys.
> What they are really after is simply a mirrored database for reporting
> purposes. So far, my position is that this cannot be done unless:-
> (1) The vendor adds primary keys to the database
> (2) The vendor upgrades to 2005 (and then I can use mirroring)
> Notes:
> A. I have discounted using snapshot replication due to the dynamic
> nature of some of the tables that don't have a primary key
> B. Although I can change the database schema myself to set the primary
> keys, I do not want to do this as the vendor wont support the app, it
> is risky and would involve a lot of work.
> Are there any other solutions to this? eg third party products?
>
|||You could set the rowguid column that is used by replication as the
primary key - just don't make it clustered.
PromisedOyster wrote:
> One of my clients is using an SQL Server 2000 database provided by a
> third party. I attempted to setup transactional replication, but this
> failed as a number of their tables do not have primary keys.
> What they are really after is simply a mirrored database for reporting
> purposes. So far, my position is that this cannot be done unless:-
> (1) The vendor adds primary keys to the database
> (2) The vendor upgrades to 2005 (and then I can use mirroring)
> Notes:
> A. I have discounted using snapshot replication due to the dynamic
> nature of some of the tables that don't have a primary key
> B. Although I can change the database schema myself to set the primary
> keys, I do not want to do this as the vendor wont support the app, it
> is risky and would involve a lot of work.
> Are there any other solutions to this? eg third party products?
>
|||You could set the rowguid column that is used by replication as the
primary key - just don't make it clustered.
PromisedOyster wrote:
> One of my clients is using an SQL Server 2000 database provided by a
> third party. I attempted to setup transactional replication, but this
> failed as a number of their tables do not have primary keys.
> What they are really after is simply a mirrored database for reporting
> purposes. So far, my position is that this cannot be done unless:-
> (1) The vendor adds primary keys to the database
> (2) The vendor upgrades to 2005 (and then I can use mirroring)
> Notes:
> A. I have discounted using snapshot replication due to the dynamic
> nature of some of the tables that don't have a primary key
> B. Although I can change the database schema myself to set the primary
> keys, I do not want to do this as the vendor wont support the app, it
> is risky and would involve a lot of work.
> Are there any other solutions to this? eg third party products?
>