How Do You Allow Users To View Reports Without Having To Enter User/password?

May 31, 2007

Ideally, I'd like to have the reports use windows authentication, ie grab current user/password so long as user does not have to enter it manually. If that is not possible, then how do I make it so user does not have to enter this info manually? My theory is that I have IIS set up incorrectly for doing this, but I'm not familiar enough with either reporting services or IIS to find out.

View 1 Replies


ADVERTISEMENT

Can't Enter User&&password For Integration Services

Oct 27, 2006

I'm about to start using Integration Services in Mgmt Studio 2005.

But, when I try to register a server for Integration Services,
the option for choosing between Windows authentication and SQL Server
authentication is greyed out, and it's set to Windows.
My domain user is automatically filled in, but greyed out. I can't enter
my password since this field is also greyed out.
Is this some installation problem? (Connection to a Database Engine works fine.)

View 3 Replies View Related

Users Cannot View Reports That I (=creator) Can

Jan 26, 2007

Hello colleagues,

I am trying to create some reports in VS.NET for our Microsoft CRM3.0.

I am using a SQL query like this:

SELECT CRMAF_Account.Name, CRMAF_Account.primarycontactidName, CRMAF_Account.address1_line1, CRMAF_Account.address1_line2, CRMAF_Account.address1_city, ActivityPointer.scheduledstart, ActivityPointer.subject, ActivityPointer.description
FROM ActivityPointer, FilteredAccount CRMAF_Account INNER JOIN FilteredSystemUser FSU ON CRMAF_Account.ownerid = FSU.systemuserid
WHERE ActivityPointer.regardingobjectid = CRMAF_Account.accountID AND FSU.Domainname = SYSTEM_USER
ORDER BY Datum DESC

When I run this query, I get the desired result (I am the database dbo), but when any user tries doing the same, they get an error

An error has occurred during report processing. (rsProcessingAborted) Get Online Help

Query execution failed for data set '[DatabaseName]'. (rsErrorExecutingCommand) Get Online Help

SELECT permission denied on object 'ActivityPointer', database '[DatabaseName]', owner 'dbo'.

I desperately need to know which user rights are missing and where are they missing - I do not suppose that the rights are expected to be assigned directly to the database tables

Any quick help would be highly appreciated. I would also appreciate any articles with examples how to use parameters, filters and subreports.

Thank you very much.

Marek Hlavac.

View 1 Replies View Related

Restrict Users To View Reports And Also Folders In Report Manager

May 6, 2008



Hi,

I would like to restrict users to allow to view related reports only...
like i have 2 users..with 4 reports

1 user can see only two reports
2 user can see only another two reports

how can i do this by SSRS???
Can i do by using Configure item-level role definitions in seetings link..
or is thr any another way to do this?

Pls reply back

Regards,
Maruthi..


View 4 Replies View Related

How To Authenticate Users Using User Login And Password Stored In SQL Database?

Feb 2, 2007

Hi. I have a DetailsView with Bound Fields "Login" and "Password". This informations are stored in SQL database. How to solve such authorization? How to compare password stored in database against passowrd typed by user? Is this a good idea to use CustomValidator control to write some checking procedure?. Regards. Pawel.

View 1 Replies View Related

A New User Cannot View Reports

Nov 28, 2007



Hi,
i have a prob;lem while using report manager.when i login As "administrator" to the report manager i can see all the folders and i can check also reports. when i create new users with some role and i login as new user i can see the specified folder and report but when i click to see the report this message appear:
" Your browser does not support scripts or has been configured not to allow scripts".
Note that these same reports i can check them when i login as administrator

i am using sql server 2005

please it's important to resolve this problem as soos as possible
thx
labiba

View 3 Replies View Related

How Can One User View Other Users That Belong To A Database Role?

Nov 15, 2006

After upgrading my database from SQL2000 to SQL2005 I have noticed a change in behavior of sp_helprolemember.

In SQL2000 I could connect as 'user1' and use sp_helprolemember to find all users that belong to a certain role.

In SQL2005 sp_helprolemember seems to only show me the roles that connected user belongs to. For example, if I connect as 'user1' I only see the roles that 'user1' belongs to.

Any advice on how to duplicate the behavior from SQL2000?

View 8 Replies View Related

Possible For User To Enter A Range Of Date

Nov 24, 2014

I have been asked to write a query on SBO.It requires (among other) a reference to a budget, which does not exist anywhere now.It is a yearly budget that changes quarterly.I suppose I could add a table and update the no. each quarter - but will the history be kept?What would you recommend?Also, they require a quarterly comparison (all in the same report) is it possible for the user to enter a range of date (for sales data, for example) and also receive the data for that range only last year's?

View 5 Replies View Related

PRompting The User To Enter Dates

Apr 21, 2008



Is it possible in Reporting Services to prompt a user for dates that can then be used to do calculations?

View 4 Replies View Related

Copy Reports From Other Users My Reports Folder

Aug 7, 2007

Is there a way to copy reports from other users "My reports" folder? I am logging onto the management studio reporting services using an administrative account and I am able to view the reports from all users' "My Reports" folder. But I am not able to export them as an rdl file. I am able to export reports from other common folders, but not from the "My Reports" folder.

The reason I need to do this is some of the users have created some reports in one environment and the reports are available in their respective "My Reports" folder. I need to move these reports to their corresponding "My Reports" folder in another environment.


Is there a way to do this?

Thanks for your help.

View 3 Replies View Related

How Can I Enter A User Input Into 2 Tables Simultanously?

Oct 25, 2004

I'm running asp.net on an XP machine with MSDE 2000 as the database. I want to create a user table with a userid and password. I have a second table that contains details about the user such as home address and phone number etc. When the user first signs up, I want their userid to go into the user table and the user detail table. In my SQL insert command, I can't get @userId to go into both tables. So my question is how do I get the userID to go into both tables or is there a better way of doing this altogether?

Thanks,
Tom

View 1 Replies View Related

How To Restrict User To Enter Phone Number In Word

Dec 5, 2014

I am designing wepage using Asp.net with Sql server as database. I have used Multiline textbox in which user has to enter their family detail. Like number of brother and sister family status, source of Earning for family.

But User do not have to enter his/her phone/contact number. For that I restricted the user to enter any nuberic digit through asp.net Regex. But User is too smart now they are entering his/her contact number in words.

Suppose somebody's Contact number is 533445928 as they can not enter numberic digit because of asp.net regex which allows the user to enter only alphabets. Now they are entering their contact number in words like five three three four four nine two eight seven. I would like to restrict the user to enter contact detail in words also.

View 1 Replies View Related

SQL Server 2012 :: SSRS - Display A Message When User Enter Wrong Parameter?

Mar 12, 2015

Issue #1 I have a report that takes 8 character parameter, A error message needs to popped out if user enters parameter less than 8 character.

Issue #2 I have a report with Tablix. A message needs to display if Tablix returns no Rows.

View 1 Replies View Related

Allowing SQL Users To Change Password

Jan 26, 2004

Hi guys,

Is there anyway to allow SQL Server users to change their own passwords without giving them rights to "db_securityadmin" ?

Our M$ adviser suggested creating our own app using SQL NS and DMO to do it.

Is there any easier method, reference, download sample from the web?

View 3 Replies View Related

DB Engine :: Extract All Privileges And User Password For A User In DDL Format For Server?

Jul 12, 2010

My goal is to write a DR plan where i am restoring all user databases onto a diffrent server in a event of hardware failure. I was trying to figure out a way to extract DDL of user accounts and their permissions on all user databases so i can simplify my DR documentation. 
 
This is the plan I came up with...to restore all system and user dbs on a different Physical SQLServer.

1. build named instance $PROD

2. restore master database

    - startup sqlserver in single user mode -m or DAC sqlcmd -S ServerName -U sa -P<xxx> –A
    net stop MSSQLSERVER$PROD
    net start MSSQLSERVER$PROD -m
    - restore database master from disk e:master.bak with replace;
   
3. start sqlserver normally

4. stop SQLServer agent

5. restore msdb

-restore database msdb disk e:msdb.bak with replace;

6. restart SQLServer

7. Restore User Databases.

8. Run Sp_change_users_login for all users

-Sp_Change_users_logins 'auto_fix','username'

View 7 Replies View Related

SQL 2012 :: Contained Users Password Hash

Mar 13, 2014

I would like to perform an audit of weak passwords, which is well documented for sql users. Using the same methodology, I should be able to audit weak passwords for contained users. To accomplish this, I must be able to find the location of the password hashes for the contained users.

I have looked at sys.syslogins and sys.sql_logins, which both have the password hash for server level users, but not contained users. I was able to find sys.sysusers, which does contain contained users, but no password hash.

What is the location of the password hashes for contained users?

View 0 Replies View Related

Getting All Logins / Users With Their Password Into Other Server While Doing Migration?

Jun 24, 2015

How to get all logins & users with their password into other server while doing migration?

View 7 Replies View Related

Save And Restore A Users Password In SQL 2000

Apr 21, 2008

How would I save a users password to a table, change it to a default password and restore it if necessary?

View 3 Replies View Related

SQL 2012 :: Contained Database Users Hash Password

May 15, 2014

Where is located the hash password for the contained database users?I have a script that prints all creating statement so that a Dev environment security can be reapply after a prod data refresh but I can't find the table containing the hash password when the user is "with login" for contained database.

View 4 Replies View Related

Reports Asking For Username And Password

May 18, 2007

I have two questions -



1. I have deployed the reports on our webserver. When I access the link http://servername/Reports from IE it asks me for a username and password the first time. I tried all the passwords including admin user/pwd but the dialog remains there. I close IE and start again I can access the reports. For your information, the checkbox 'Save my password' is checked in the reports. Does anyone know why the username/password dialog appears the first time?



2. Sometimes some of us get a 'Page cannot be displayed' while the others can access it. I have to start Reporting services and everyone can access the reports. Any ideas?



Thanks!!

View 3 Replies View Related

Report On Users Accessing Reports

May 13, 2008

All,

I would like a report to display the number of users and the reports accessed for a certain duration of time[being able to go back and check for previous years as well].

I read on the msdn that 60 days worth of report log is kept,and the rest gets wipped off.Any suggestions on how I would be able to get user access list for the past year as well.

View 5 Replies View Related

Non-Admin Users Cannot Load Reports

Mar 17, 2008

Originally posted this in the performance point forum, the error actually occurs if link direct to the reporting web site as well. The reports are being created in the report builder, from the web service.

-----

Attempting to add a report services report into a performance point dashboard page. Everything is installed on one box.

When the admin logins load the page, everything works great.

When a non-admin loads the page, everything except the report generates, and the following error kicks off:



An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'dataSource1'. (rsErrorOpeningConnection)
Login failed for user '####'
The user login in question has been given browse access to everything in the report services web. I'm not sure where or how to grant whatever access is necessary for this to work properly.. and really I was hoping that any authenticated user at the dashboard level would be able to view the report so I didn't have to do security twice.

Can anyone point me in the right direction?

View 4 Replies View Related

Asking Userid And Password While Deploying Reports

May 15, 2007

Hi All,



While deploying reports on the reports server, it is asking to supply user name and password. When I entered the same, it didn't accept them. What do I need to do? Is there any specific setting which I need to configure?



An immediate reply will be highly appreciated.





Thanks

Sekhar

View 6 Replies View Related

Prompt Password When Calling Certain Reports Only?

Jan 11, 2007

Hi,

When I call certain reports from an ASP application, some prompt for password and some are not.

I wonder why is this happen?

Under the Directory Security of Reports under IIS 6, I already enable Anonymous Access for IUSR_XXXX with the correct password.

I also assign IUSR_XXXX as Browser in Report Manager of Reporting Services.

The enviroment is Windows Server 2003 standard edition, IIS 6, SQL Server 2005.

Thanks in advance.

Best regards,

Pop

View 2 Replies View Related

Sending Different E-mail Reports Based On Users

Jan 21, 2008

Hey guys, I need a little help for my group project(Using ASP.NET 2 connected to SQL Server 2005). Here's the scenario:

Our system is basically a sort of login/logout system, so we have a table that has (Name, Date, Subject, TimeIn, TimeOut).

1. User registers on website, so information like e-mail is recorded into the database (and the user in the website is "linked/checked" to his data in the SQL Server for verification).
2. Users can choose to subscribe to a weekly report e-mail(maybe using a simple "IsSubscribed" boolean value in the database).
3. Every week, our system scans the database for those users who subscribed, then send different e-mail reports depending on the particular user (a compiled weekly report for Mon-Fri).

Is there such a feature in Database Mail? If not, how do I execute these types queries and just set them as a Scheduled Task?

Any help would be appreciated.

View 3 Replies View Related

Making Reports Customizeable For Users On A .NET Site

Oct 11, 2007

Hello,

We have a small .NET intranet site and I have some experience with Reporting Services. What I am looking to do is develop some reports on our website. However, I would like to make it so the user can do some customization of their reports.

For example, there would be sections of reports (Headcounts, Turnover, etc.) and in each section there would be measurements they could click to include. So I could select the Headcounts section and select the measurements such as Terminations, Hires, and Period End Headcount. I may not select the Turnover sections at all. I am almost thinking like a Google page where you can move around the sections and have your own customized report. Maybe these sections could work as Web Parts, or something like that.

Does any of this make sense? Is it possible? Are there are websites or examples that are out there that I could get an idea to see if this has been done and how to do it?

Thank you.

-Gumbatman

View 8 Replies View Related

Can I Get Ordinary Users To Create Reports Rather Than Admin...?

May 30, 2007

Can I get ordinary users to create reports rather than admin using a web browser interface?

View 2 Replies View Related

Can Sql Server Reports Vieweble By Anonymous Users?

Aug 3, 2007

Hi there,

I created reports and deployed successfully. but one problem i am facing is when i am opening the browser to see reports, it is asking for credentials..

But i want to show these reports for anonymous users

Is there any way to show reports for anonymous users? If yes, what is the process. please refer me any articles.

please help me out.

thanks
praveen.

View 3 Replies View Related

Problem Getting Some Users To Be Able To Run Reports (probably Security Of Some Sort)

Jan 12, 2007

I am able to deploy and run reports from my screen at work, but some non-developers cannot run them. They can see the reports, but get the following error message when they click on the report:

An error has occurred during report processing. (rsProcessingAborted)

Cannot create a connection to data source 'DataSource1'. (rsErrorOpeningConnection)

For more information about this error navigate to the report server on the local server machine, or enable remote errors
--------------------------
-----

- I assume the preceding error has something to do with credentials. I am using Windows security authentication for this. One user has worked through this and is now getting cannot run report query (one of the report queries in the report). Help would be appreciated.

View 3 Replies View Related

Changing The Administrator Password MURDERED My Reports!

Nov 18, 2007

Hi. I changed the Administrators Login password on my web & data base servers, both of which are hosted on Windows Server 2003 and run iis6. This caused the reports (I'm using 2005 Reporting services) to stop running. Rather I get the error: "The request failed with HTTP status 401: Unauthorized"



I made the necessary adjustments to the web.config and the reports just won't run. I have been struggling over this all day. Can anyone offer me some advice?

Thanks

HP

View 1 Replies View Related

View && SP's For Just A Few Users

Jul 20, 2005

I have read about Views vs. SP's and I have question to which I could notreadily find the answer.The database I'm creating will only have 1 user from the start and up tothree maximum. Is there any reason that I shouldn't just use SP's foreverything or might there be an advantage to using views.This is not a heavy I/O project either and most of the day to day use willbe record manipulation and reference rather than new record entry.Thanks-Jake

View 2 Replies View Related

View Users

Jul 20, 2005

HiWhat is the sql commnad to view active user on sql sever databasesThanks

View 1 Replies View Related

1 To 1, 1 To Many. Create One Stored Procedure For Crystal Reports(CR). For Any CR Users Also.

Jul 12, 2007

Situation: If possible, create one stored procedure for Crystal Reports(CR). For any CR users ou
there, looking for coding suggestion also. Thank you for your assistance.

Currently, CR has a header(Report Header) coming from 1 to 1 tables, there is a parameter
which is passed in, allowing it to retrieve one record for the header(report header or RH).

The CR then has 4 subreports in which each has its own stored procedure. This I believe happens
because the Report Header records relationship to the subreport is 1 to many. The 3 remaining
subreports relationship to the Report Header is also a 1 to many. The main problem is the
subreports is that there may or may not have any records based on this, the subreport is
suppressed within CR and thus there can be alot of unused white space on the 1st page and one
of the subreports prints on a 2nd page when it could have been on the 1st page.

Example:

Main Stored Procedure(sp)
RH Tables: aaa, bbb, ccc, ddd are 1 to 1 record tables and have a @xyz parameter.

Results of subreports and their associated procedure are varchar(8000) decriptions. Each line
should be counted in some manner in the stored procedure(sp) and then should be counted in CR
to avoid excess white space. To complicate matters subreport 2 to has font, bold, showbox but
can have different font sizes. These variations could cause different line space requirements.
Any ideas?


Each line should be counted in some manner in the stored procedure and then should be counted
in CR. There is a count of records for each the main stored procedure.

RH has 1 record to many records in subreport 1 with same @xyz parameter.
RH has 1 record to many records in subreport 2 with same @xyz parameter.
RH has 1 record to many records in subreport 3 with same @xyz parameter.
RH has 1 record to many reords in subreport 4 with same @xyz parameter.

Because of the relationships, its seems impossible to create one stored procedure which give
in one select statement with all the 1 to 1, 1 to many relationsips, as stated above. I thought
concatinating i.e. 3 records together and then parsing it out some how in CR, along with
utilizing the i.e. 3 record count to help count lines. Thought of some how creating a temporary
table matrix for 8pt - 28pt for line and spacing considerations.







View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved