SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
SQL Server
SQL Server 2008
Product Documentation
SQL Server 2008 Books Online
Reporting Services
Technical Reference
Feature Reference
Report Designer in Business Intelligence Development Studio F1 Help
Report Designer F1 Help
Action Properties Dialog Box
Axis Properties Dialog Box, Axis Options
Axis Properties Dialog Box, Line
Axis Properties Dialog Box, Label Font
Axis Properties Dialog Box, Labels
Axis Properties Dialog Box, Major Tick Marks
Axis Properties Dialog Box, Minor Tick Marks
Axis Properties Dialog Box, Number
Axis Properties Dialog Box, Visibility
Axis Title Properties Dialog Box, Font
Axis Title Properties Dialog Box, General
Calculated Series Properties Dialog Box, Action
Calculated Series Properties Dialog Box, Axes and Chart Area
Calculated Series Properties Dialog Box, Border
Calculated Series Properties Dialog Box, Fill
Calculated Series Properties Dialog Box, Formula
Calculated Series Properties Dialog Box, Legend
Calculated Series Properties Dialog Box, Markers
Calculated Series Properties Dialog Box, Shadow
Calculated Series Properties Dialog Box, Visibility
Category Group Properties Dialog Box, Filters
Category Group Properties Dialog Box, General
Category Group Properties Dialog Box, Sorting
Category Group Properties Dialog Box, Variables
Chart Area Properties Dialog Box, 3D Options
Chart Area Properties Dialog Box, Alignment
Chart Area Properties Dialog Box, Border
Chart Area Properties Dialog Box, Fill
Chart Area Properties Dialog Box, Shadow
Chart Area Properties Dialog Box, Visibility
Chart Properties Dialog Box, Action
Chart Properties Dialog Box, Border
Chart Properties Dialog Box, Fill
Chart Properties Dialog Box, Filters
Chart Properties Dialog Box, General
Chart Properties Dialog Box, Visibility
Chart Title Properties Dialog Box, Action
Chart Title Properties Dialog Box, Border
Chart Title Properties Dialog Box, Fill
Chart Title Properties Dialog Box, Font
Chart Title Properties Dialog Box, General
Chart Title Properties Dialog Box, Shadow
Chart Title Properties Dialog Box, Visibility
Column Visibility Dialog Box
Convert CRI Dialog Box
Cube Selection Dialog Box
Data Source Properties Dialog Box, Credentials
Data Source Properties Dialog Box, General
Dataset Properties Dialog Box, Fields
Dataset Properties Dialog Box, Filters
Dataset Properties Dialog Box, Options
Dataset Properties Dialog Box, Parameters
Dataset Properties Dialog Box, Query
Define Query Parameters Dialog Box
Delete Columns Dialog Box
Delete Group Dialog Box
Delete Rows Dialog Box
Embedded Images Dialog Box
Enter Data Source Credentials Dialog Box
Expression Dialog Box
Grouping Pane
Gauge Label Properties Dialog Box, Action
Gauge Label Properties Dialog Box, Border
Gauge Label Properties Dialog Box, Fill
Gauge Label Properties Dialog Box, Font
Gauge Label Properties Dialog Box, General
Gauge Label Properties Dialog Box, Shadow
Gauge Panel Group Properties Dialog Box, Filters
Gauge Panel Group Properties Dialog Box, General
Gauge Panel Group Properties Dialog Box, Sorting
Gauge Panel Group Properties Dialog Box, Variables
Gauge Panel Properties Dialog Box, Action
Gauge Panel Properties Dialog Box, Border
Gauge Panel Properties Dialog Box, Fill
Gauge Panel Properties Dialog Box, Filters
Gauge Panel Properties Dialog Box, General
Gauge Panel Properties Dialog Box, Visibility
Image Properties Dialog Box, Action
Image Properties Dialog Box, Border
Image Properties Dialog Box, General
Image Properties Dialog Box, Size
Image Properties Dialog Box, Visibility
Linear Gauge Properties Dialog Box, Action
Linear Gauge Properties Dialog Box, Back Fill
Linear Gauge Properties Dialog Box, General
Linear Gauge Properties Dialog Box, Frame
Linear Gauge Properties Dialog Box, Frame Border
Linear Gauge Properties Dialog Box, Frame Fill
Linear Gauge Properties Dialog Box, Frame Shadow
Linear Pointer Properties Dialog Box, Action
Linear Pointer Properties Dialog Box, Pointer Border
Linear Pointer Properties Dialog Box, Pointer Fill
Linear Pointer Properties Dialog Box, Pointer Options
Linear Pointer Properties Dialog Box, Shadow
Linear Scale Properties Dialog Box, Action
Linear Scale Properties Dialog Box, Border
Linear Scale Properties Dialog Box, Fill
Linear Scale Properties Dialog Box, General
Linear Scale Properties Dialog Box, Label Font
Linear Scale Properties Dialog Box, Labels
Linear Scale Properties Dialog Box, Layout
Linear Scale Properties Dialog Box, Major Tick Marks
Linear Scale Properties Dialog Box, Minor Tick Marks
Linear Scale Properties Dialog Box, Number
Linear Scale Properties Dialog Box, Shadow
Linear Scale Range Properties Dialog Box, Action
Linear Scale Range Properties Dialog Box, Border
Linear Scale Range Properties Dialog Box, Fill
Linear Scale Range Properties Dialog Box, General
Linear Scale Range Properties Dialog Box, Shadow
Legend Properties Dialog Box, Border
Legend Properties Dialog Box, Font
Legend Properties Dialog Box, Fill
Legend Properties Dialog Box, General
Legend Properties Dialog Box, Visibility
Legend Properties Dialog Box, Shadow
Legend Title Properties Dialog Box, Font
Legend Title Properties Dialog Box, General
Legend Title Properties Dialog Box, Shadow
Minor Gridline Properties Dialog Box, Visibility
Minor Gridline Properties Dialog Box, Gridline Options
Major Gridline Properties Dialog Box, Visibility
Major Gridline Properties Dialog Box, Gridline Options
Placeholder Properties Dialog Box, Action
Placeholder Properties Dialog Box, Alignment
Placeholder Properties Dialog Box, General
Placeholder Properties Dialog Box, Font
Placeholder Properties Dialog Box, Number
Radial Gauge Properties Dialog Box, Action
Radial Gauge Properties Dialog Box, Back Fill
Radial Gauge Properties Dialog Box, Frame
Radial Gauge Properties Dialog Box, Frame Border
Radial Gauge Properties Dialog Box, Frame Fill
Radial Gauge Properties Dialog Box, Frame Shadow
Radial Gauge Properties Dialog Box, General
Radial Pointer Properties Dialog Box, Action
Radial Pointer Properties Dialog Box, Cap Fill
Radial Pointer Properties Dialog Box, Cap Options
Radial Pointer Properties Dialog Box, Pointer Border
Radial Pointer Properties Dialog Box, Pointer Fill
Radial Pointer Properties Dialog Box, Pointer Options
Radial Pointer Properties Dialog Box, Shadow
Radial Scale Properties Dialog Box, Action
Radial Scale Properties Dialog Box, Border
Radial Scale Properties Dialog Box, Fill
Radial Scale Properties Dialog Box, General
Radial Scale Properties Dialog Box, Labels
Radial Scale Properties Dialog Box, Label Font
Radial Scale Properties Dialog Box, Layout
Radial Scale Properties Dialog Box, Major Tick Marks
Radial Scale Properties Dialog Box, Minor Tick Marks
Radial Scale Properties Dialog Box, Number
Radial Scale Properties Dialog Box, Shadow
Radial Scale Range Properties Dialog Box, Action
Radial Scale Range Properties Dialog Box, Border
Radial Scale Range Properties Dialog Box, Fill
Radial Scale Range Properties Dialog Box, General
Radial Scale Range Properties Dialog Box, Shadow
Rectangle Properties Dialog Box, Border
Rectangle Properties Dialog Box, Fill
Rectangle Properties Dialog Box, General
Rectangle Properties Dialog Box, Visibility
Report Data Pane
Page Footer Properties Dialog Box, Border
Page Footer Properties Dialog Box, Fill
Page Footer Properties Dialog Box, General
Page Header Properties Dialog Box, Border
Page Header Properties Dialog Box, Fill
Page Header Properties Dialog Box, General
Report Parameter Properties Dialog Box, Advanced
Report Parameter Properties Dialog Box, Available Values
Report Parameter Properties Dialog Box, Default Values
Report Parameter Properties Dialog Box, General
Report Body Properties Dialog Box, Border
Report Body Properties Dialog Box, Fill
Report Properties Dialog Box, Code
Report Properties Dialog Box, Page Setup
Report Properties Dialog Box, References
Report Properties Dialog Box, Variables
Reporting Services Login Dialog Box
Reporting Services Query Designers
Row Visibility Dialog Box
Select Color Dialog Box
Series Group Properties Dialog Box, Filters
Series Group Properties Dialog Box, General
Series Group Properties Dialog Box, Sorting
Series Group Properties Dialog Box, Variables
Series Label Properties Dialog Box, Action
Series Label Properties Dialog Box, Border
Series Label Properties Dialog Box, Fill
Series Label Properties Dialog Box, Font
Series Label Properties Dialog Box, General
Series Label Properties Dialog Box, Number
Series Label Properties Dialog Box, Visibility
Series Properties Dialog Box, Action
Series Properties Dialog Box, Axes and Chart Area
Series Properties Dialog Box, Border
Series Properties Dialog Box, Fill
Series Properties Dialog Box, Legend
Series Properties Dialog Box, Markers
Series Properties Dialog Box, Series Data
Series Properties Dialog Box, Shadow
Series Properties Dialog Box, Visibility
Shared Data Source Properties Dialog Box, Credentials
Shared Data Source Properties Dialog Box, General
Subreport Properties Dialog Box, Border
Subreport Properties Dialog Box, General
Subreport Properties Dialog Box, Parameters
Subreport Properties Dialog Box, Visibility
Tablix Group Dialog Box
Tablix Group Properties Dialog Box, Advanced
Tablix Group Properties Dialog Box, Filters
Tablix Group Properties Dialog Box, General
Tablix Group Properties Dialog Box, Page Breaks
Tablix Group Properties Dialog Box, Sorting
Tablix Group Properties Dialog Box, Variables
Tablix Group Properties Dialog Box, Visibility
Tablix Properties Dialog Box, Filters
Tablix Properties Dialog Box, General
Tablix Properties Dialog Box, Sorting
Tablix Properties Dialog Box, Visibility
Text Properties Dialog Box, Action
Text Properties Dialog Box, Alignment
Text Properties Dialog Box, Font
Text Properties Dialog Box, General
Text Box Properties Dialog Box, Action
Text Box Properties Dialog Box, Alignment
Text Box Properties Dialog Box, Border
Text Box Properties Dialog Box, Fill
Text Box Properties Dialog Box, Font
Text Box Properties Dialog Box, General
Text Box Properties Dialog Box, Interactive Sort
Text Box Properties Dialog Box, Number
Text Box Properties Dialog Box, Visibility
Expand Minimize
This topic has not yet been rated - Rate this topic

Shared Data Source Properties Dialog Box, Credentials

SQL Server 2008

Select Credentials on the Shared Data Source Properties dialog box to display and modify credentials to connect to a shared data source in the report. The credentials that you provide are used to access the data source and to cache a copy of the data for previewing reports. For more information about how preview data is cached, see Previewing Reports. For more information about credentials, see Specifying Credential and Connection Information for Report Data Sources.

Use Windows Authentication (integrated security)

Select this option to use Windows Authentication.

Use this user name and password

Select this option to provide a specific user name and password. For shared data sources: when you publish the report server project to the target server, the user name and password are saved as the stored credentials for the database. If you want to use the user name and password as Windows credentials, you can edit the properties for the published shared data source on the target server. For more information, see How to: Create, Delete, or Modify a Shared Data Source (Report Manager).

User name

Type a user name to log in to the data source.

Password

Type a password to log in to the data source.

Prompt for credentials

Select this option to prompt for credentials when the report is run.

Enter prompt string

Type a sentence to instruct the user to provide login credentials for the data source.

No credentials

Select this option to provide no credentials for the data source. This option only works if the data source does not accept credentials or if you are passing credentials some other way.

Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft
|
Site Feedback
© 2013 Microsoft. All rights reserved.