REPORTING SERVICES: Form-Base Authorization (Form Basic Certification):
Reporting Services can be made from the SECURITY EXTENSIT for identity authentication and authorization mode;
Put the user ID and password by data inventory;
The body verification mode can be integrated with the AD / LDAP through OLE DB Provider for Microsoft Directory Services.
OLE DB Provider for Microsoft Directory Services: EXEC sp_addlinkedserver 'ADSI', 'Active Directory Services 2.5', 'ADSDSOObject', 'adsdatasource'GO SELECT [Name], SN [Last Name], ST StateFROM OPENQUERY (ADSI,' SELECT Name, Sn, ST from '' ldap: // adsISRV / OU = Sales, DC = Sales, DC = Northwind, DC = COM '' Where ObjectCategory = '' Person '' and ObjectClass = '' Contact '') RS and Some ASP.NET interface integration and pass parameters to reports, merge user rights management via ASP.NET Session. RS Security Services (NT, Passport, Custom). Delivery Targets (E-mail, SharePoint, Custom). Data Sourcees (SQL, OLE DB, XML / A, ODBC, ORACLE, CUSTOM).
Output Formats (HTML, Excel, PDF, Custom).
Figure 1 Design report
You can use Microsoft VS.NET 2003 or any 3rd Party Tools single report that supports RDL to support simultaneous use of different variety of data sources (such as Access, Ole DB, ODBC, Oracle, and .NET DATA Providers)
Tool (Freeform, Table, Matrix, Chart) Parameters (Sorting, Filtering, Grouping, Aggates) Interactive (DRILL-DOWN, DRILL-THROUGH) Side Preview Authentication Method
IIS authenticates for users connected to the report server and report manager. Although IIS supports a lot of authentication options, you can only use Windows authentication or basic authentication to access the Reporting Services component. Anonymous access and summary authentication is not supported in this release. Use the form authentication in Reporting Services http://www.microsoft.com/china/msdn/library/data/sqlserver/ufairs.mspx
