Report Designer crashes when accessing Access DB via ODBC

Hi:
I am trying to build a report off of a stand alone MS Access 2000 database. I can create the Data Source using the "Driver do Microsoft Access" driver, version 4.00.6019.00.
When I go to create the query to create the Dataset, I right click to add a table, I can see the table list and check the table I want to use. It is at this point the Visual Studio crashes, closes and send off the error report to Microsoft.
What's up? Why is this happening? I can write reports to my heart's content using an IBM ODBC driver against our DB2 database on an AS/400. One would think that writing reports using all MS products this should go very smooth.
Thanks in advance.
Bruce.Did you try the "Microsoft Jet 4.0 OLE DB Provider" which is designed to
work with Access?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"bwschiek@.hotmail.com" <bwschiekhotmailcom@.discussions.microsoft.com> wrote
in message news:EE8C1C06-2779-4069-9004-0E6DF55969CE@.microsoft.com...
> Hi:
> I am trying to build a report off of a stand alone MS Access 2000
database. I can create the Data Source using the "Driver do Microsoft
Access" driver, version 4.00.6019.00.
> When I go to create the query to create the Dataset, I right click to add
a table, I can see the table list and check the table I want to use. It is
at this point the Visual Studio crashes, closes and send off the error
report to Microsoft.
> What's up? Why is this happening? I can write reports to my heart's
content using an IBM ODBC driver against our DB2 database on an AS/400. One
would think that writing reports using all MS products this should go very
smooth.
> Thanks in advance.
> Bruce.|||Hi Robert:
Thanks. That did the trick.
I had been using the ODBC connection that caused VS to crash for the last year with Crystal Reports with no issues. Curious...
Thanks again.
Bruce.
"Robert Bruckner [MSFT]" wrote:
> Did you try the "Microsoft Jet 4.0 OLE DB Provider" which is designed to
> work with Access?
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "bwschiek@.hotmail.com" <bwschiekhotmailcom@.discussions.microsoft.com> wrote
> in message news:EE8C1C06-2779-4069-9004-0E6DF55969CE@.microsoft.com...
> > Hi:
> >
> > I am trying to build a report off of a stand alone MS Access 2000
> database. I can create the Data Source using the "Driver do Microsoft
> Access" driver, version 4.00.6019.00.
> >
> > When I go to create the query to create the Dataset, I right click to add
> a table, I can see the table list and check the table I want to use. It is
> at this point the Visual Studio crashes, closes and send off the error
> report to Microsoft.
> >
> > What's up? Why is this happening? I can write reports to my heart's
> content using an IBM ODBC driver against our DB2 database on an AS/400. One
> would think that writing reports using all MS products this should go very
> smooth.
> >
> > Thanks in advance.
> >
> > Bruce.
>
>

Report Builder, Stored Procedures and Views

How can I access recordsets from Stored Procedures and/or views instead of
tables from the database. I need to limit the amount of data a user can
access but the only entities showing up in the Explorer are tables.Hi,
You can access from tables and views, what ever filter criteria you can give
it in views. Go to "Data Source Views" in the Report model project and click
on add existing items from your datasource you should see tables and views.
Amarnath
"SYoung" wrote:
> How can I access recordsets from Stored Procedures and/or views instead of
> tables from the database. I need to limit the amount of data a user can
> access but the only entities showing up in the Explorer are tables.|||You're talking about a Report Project in VS. What I'm talking about is an
add on client development tool accessible via the
http://YourReportServer/Reports page called "Report Builder". This tool
allowes the user to create adhoc reports without having to write 1 line of
SQL.
"Amarnath" wrote:
> Hi,
> You can access from tables and views, what ever filter criteria you can give
> it in views. Go to "Data Source Views" in the Report model project and click
> on add existing items from your datasource you should see tables and views.
> Amarnath
>
> "SYoung" wrote:
> > How can I access recordsets from Stored Procedures and/or views instead of
> > tables from the database. I need to limit the amount of data a user can
> > access but the only entities showing up in the Explorer are tables.

Report Builder accessed using https over internet

If you access the report builder application over the internet using a secure connection such as https://<report server name>/reportserver/reportbuilder/reportbuilder.application, will report builder communicate using https? If not, will the data being transferred to/from the report server be encrypted by some other method in the application?

Report Builder actually switches between http and https based on the web service method being called and whether ListSecureMethods indicates that https should be used. You can configure these settings on the report server.

Here are a few links that might be useful:

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

http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.listsecuremethods.aspx

Report Builder (rsaccessdenied) error message

Hi,

I have created a Report Model and published it on our QA environment Report Server(Where I dont have admin access). When I try to launch the Report Builder tool and create a sample report and Run the report it gives me this error. "The permissions granted to user 'Domainname/user group' are insufficient for performing this operation. (rsAccessDenied)" I checked with the Admins on this server the usergroup has a "Browser" Role. I had read on some online fourm that if user group has browser role it should work. But I cant get it work any help is appreciated.

I have published the same Report Model in Deveploment environment report server(where I have admin access) and when I do the same thing I am able to run the reports.

Some one please help me its causing delay in our testing.

Thanks

Ashwini

I think you need the report builder role. Not just browser, that is not enough permission.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=573815&SiteID=1

|||

Thank you!! I will let the Admin know about this and ask them include the Report Builder Role and will try again and see if it works.

|||

Ok we tried giving the role Report Builder to the user and Report Builder Role has these tasks assosicated - Consume Reports,Manage Individual Subscriptions,View Folders,View Models,View reports,View resources. Even after giving this role it did not work. So we even selected all the tasks under Report Builder Role just for testing this did not work either.

Here is the exact scenario: when I get the error message it says this user's "IHS-T-CRRSWQ-01\IUSR_WFS-4376A9A5D75" permission granted is insufficient this user is the one which is running on IIS. But this is one of the user under user group "NT AUTHORITY\Authenticated Users" which has Report Builder Role. I am really getting into circels here any help appreciated.

Thanks!!

|||

Please post the exact error message.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Error Message:

"The permissions granted to user ' Username' are insufficient for performing this operation. (rsAccessDenied)"

Thanks

Ashwini

|||Please, if someone has a solution, i've the same problem.

Report Builder (rsaccessdenied) error message

Hi,

I have created a Report Model and published it on our QA environment Report Server(Where I dont have admin access). When I try to launch the Report Builder tool and create a sample report and Run the report it gives me this error. "The permissions granted to user 'Domainname/user group' are insufficient for performing this operation. (rsAccessDenied)" I checked with the Admins on this server the usergroup has a "Browser" Role. I had read on some online fourm that if user group has browser role it should work. But I cant get it work any help is appreciated.

I have published the same Report Model in Deveploment environment report server(where I have admin access) and when I do the same thing I am able to run the reports.

Some one please help me its causing delay in our testing.

Thanks

Ashwini

I think you need the report builder role. Not just browser, that is not enough permission.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=573815&SiteID=1

|||

Thank you!! I will let the Admin know about this and ask them include the Report Builder Role and will try again and see if it works.

|||

Ok we tried giving the role Report Builder to the user and Report Builder Role has these tasks assosicated - Consume Reports,Manage Individual Subscriptions,View Folders,View Models,View reports,View resources. Even after giving this role it did not work. So we even selected all the tasks under Report Builder Role just for testing this did not work either.

Here is the exact scenario: when I get the error message it says this user's "IHS-T-CRRSWQ-01\IUSR_WFS-4376A9A5D75" permission granted is insufficient this user is the one which is running on IIS. But this is one of the user under user group "NT AUTHORITY\Authenticated Users" which has Report Builder Role. I am really getting into circels here any help appreciated.

Thanks!!

|||

Please post the exact error message.

Jens K. Suessmeyer

http://www.sqlserver2005.de

|||

Error Message:

"The permissions granted to user ' Username' are insufficient for performing this operation. (rsAccessDenied)"

Thanks

Ashwini

|||Please, if someone has a solution, i've the same problem.

Report Builder - Can't see Report Builder button

While logged in locally at the server running Reporting Services I can see
the "Report Builder" option on the menu bar but when I access the server from
another machine in the network the "Report Builder" option is not available.
I gave myself rights to every single option under security but can't run the
Report Builder. Any idears?Hi,
I think you have given from Management studio?. Try from your
"http://<server>/reports" replace <server> with your server name.
Go to Home->properties and try giving your login and select content Manager
and see whether you are getting "Report Model" option.
Amarnath
"SYoung" wrote:
> While logged in locally at the server running Reporting Services I can see
> the "Report Builder" option on the menu bar but when I access the server from
> another machine in the network the "Report Builder" option is not available.
> I gave myself rights to every single option under security but can't run the
> Report Builder. Any idears?|||Found the answer. You need to be logged in as "Administrator". Go to "Site
Settings" > "Configure site-wide security" > "New Role Assignment" > check
the "System User" checkbox & add the user name or group name in the textbox.
Click "OK" and that's it.
"SYoung" wrote:
> While logged in locally at the server running Reporting Services I can see
> the "Report Builder" option on the menu bar but when I access the server from
> another machine in the network the "Report Builder" option is not available.
> I gave myself rights to every single option under security but can't run the
> Report Builder. Any idears?

Report Builder

What permissions do I need to give to a user in order to have access to the
Report Builder component?The Browser role needs the "View Models" permission.
"Kevin Antel" wrote:
> What permissions do I need to give to a user in order to have access to the
> Report Builder component?
>
>|||The user must have permission to the Execute Report Definitions task, which
is granted to the System User role by default. They must also have permission
to the View Models task on at least one report model.
"Kevin Antel" wrote:
> What permissions do I need to give to a user in order to have access to the
> Report Builder component?
>
>|||Check the last entry for "Report Builder - Can't see Report Builder button"
"Bob Meyers - MSFT" wrote:
> The user must have permission to the Execute Report Definitions task, which
> is granted to the System User role by default. They must also have permission
> to the View Models task on at least one report model.
> "Kevin Antel" wrote:
> > What permissions do I need to give to a user in order to have access to the
> > Report Builder component?
> >
> >
> >

report authentication: windows prompt removal

Hello,

I'm writing a small program to access reports on a remote server. When simply accessing the server, using the reportviewer, I get a windows prompt for login. I would like to avoid this by passing the account information.

How should I do this? (Maybe through network credentials)

Could someone send me some example code?

Thank you.

Jos

i'm not sure but i think you mean that you want to acces it through internet explorer?

if that's the case , demanding the credentials depends on the zone your page is in

see internet explorer>extra>internet options>security

by default internet explorer demands credentials for public sites and uses integrated login for intranet, that i wouldn't change

the clue is that any address with a dot . (be it in an ip or dns notation, eg 10.2.54.56 or webserver.domain.local) is regarded by default as a public address

so either you add the adress in the intranet zone or you change the adress in wins notation style ( eg //webserver/reports)

|||

Well I want to access the reports through a small asp.net program. You may see the source code in http://www.odetocode.com/Articles/95.aspx

When I access my reportserver (http://sqlreport244_9.mysite4now.com/reportserver) I get prompted for a windows login.

What I would like to do is to set the credentials on the code of the asp.net program to avoid being shown the prompt. This program will be used by several users and don't want them to have to insert the password each time they access the reports.

Thanks

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

Report Access

I have created a new report that all my users except for one can print and
view the same data on this report. One user gets the
report headers -- but no data.
I checked this user's active directory settings, and she is a member of the
same Reporting Group.
What could be the problem?Sounds like SQL data permissions issue. If I understand correctly the user
is seeing text that is static in the report but no data from the dataset.
Is the dataset SQL a stored procedure, or a select statement. If it's a
select statement probably doesn't have access to read the tables. Try
loging onto query analyzer with the users credentials (or similar) and
seeing what data is returned.
Steve MunLeeuw
"Cindy" <CindyMikeworth@.newsgroups.nospam> wrote in message
news:OHuLuAu7GHA.3644@.TK2MSFTNGP03.phx.gbl...
>I have created a new report that all my users except for one can print and
>view the same data on this report. One user gets the
> report headers -- but no data.
> I checked this user's active directory settings, and she is a member of
> the same Reporting Group.
> What could be the problem?
>|||Hello Cindy,
Does Steve's suggestion make any sense to you?
Also, you could try to test on other client with your user's credential. If
you could access the report on other client, you may need to check the IE
security setting.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================(This posting is provided "AS IS", with no warranties, and confers no
rights.)

Report "code behind"

Or rather simple access top the report in markup format from Visual studio! Sometimes I have to go to windows explorer and drill down to my report and open it as a .txt file to see what I am looking for.

Why in gods name does visual studio not have it such that I can see my report in markup.

I am running local reports which might be the reason, cant complain to much over something that is free I guess

In Visual Studio you can right-click on the report name and open in XML format - if that's what you are talking about.

Reporitng Services Web Service and Credentials

I have developed an asp.net, vb.net web app and have integrated reporting services. Right now I am using url access but am not to crazy about showing the parameters in the querystring. I am using a dynamic stored procedure to get client data. I would like to use the rs web service to programatically set the parameters and send them invisably to the web service. Since the web app is not using windows authentication I would like to pass the parameters using a hard coded account that has been set up with browse privilages in the report manager. Is it possible to hard code the credentials that are sent to the reporting service instead of the System.Net.CredentialsCache.DefaultCredentials? The report returns a bar graph which I am hoping to display on the page. Reading some posts about some problems returning images I might be posting some more questions.

Are there any good walkthroughs or code examples using reporting services web service other than MSDN's limited supply?

Thank you for your time!
--
- preisifigured out the first part

rs.Credentials = New System.Net.NetworkCredential("username", "password", "domain")

Now when i try and render my graph the image can't be found.|||this is not an answer to your question but infact a question to you. can you share with us about how far you have gotten in getting this RS thing to work. i mean i have created some reports which accept a couple of parameters. now i need to create a windows service that calls the reportservice everyday, and prints the report. which is a little similar to what you have done. xcept for the windows service part. so could you share some of your xperience ?

thanks.
dinakar

Replications

I want the replication b/w Access to MySQL... can any one let me know the
tool ....
> I want the replication b/w Access to MySQL... can any one let me know the
> tool ....
Check http://vyaskn.tripod.com/repl_ans5.htm.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com