November 14, 2008 at 1:24 pm
SQL Reporting Services 2000 and 2005 use Windows-Authentication only. Right?
Reporting Services 2000 support SQL-Authentication? This would enable us to use Reporting Services where we've been prevented here to fore.
Thanks, Bob
November 14, 2008 at 2:20 pm
You can use both (Windows or SQL)
Are you asking for the SSRS service account
or the report execution at run time?
Either way, you can use either
November 14, 2008 at 3:57 pm
I am asking for the report execution at runtime, for ad hoc and canned reports (that are written with stored procedures).
Can the end user connect with SQL Authentication?
We tried for a month and could not make it work with SQLServer 2000 and SSRS 2000.
Does SSRS have a SQL Authentication capability with SSRS 2000?, SSRS 2005? SSRS2008?
TIA
November 17, 2008 at 6:03 am
In your datasource for the report you can define how authentification is done. If you use the option "The credentials supplied by the user running the report", the user will be prompted for a username and password. The username can be either a windows login or a sql login.
[font="Verdana"]Markus Bohse[/font]
October 4, 2012 at 2:31 am
@Markus, I'm new to this, how do you authenticate using a SQL login?
This is my problem:
I'm trying to integrate form/custom authentication with SSRS? basically when a user goes to the reports URL, they are asked to enter their username and password which then checks against a SQL or other database and if authenticated, access is granted.
Any help will be appreciated.
Jeremaine
October 4, 2012 at 3:12 am
You need to set the data source to run using a SQL account to make the report access the DB using a SQL login.
Access to the SSRS web page is done via Windows auth unless you have written your own custom authentication provider.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply