Forms Security Extension Sample

Hi,

I have installed the SSRS 2005 Forms based login security extension as per the sample and instructions that come with the product install. I have double checked my work and debugged up to the point explained here.

My user is in the database and I can get to the login page. I have traced the code and can see the user being authenticated properly by server.LogonUser, the authentication cookie being created and placed in the response object, and then the redirect url being set to the reports/pages/folder.aspx. I have employed tcptrace and can see the sqlAuthCookie set in subsequent posts.

Unfortunately the redirect to folder.aspx never happens. I keep returning to UILogon.aspx. I think their is something either wrong with the auth cookie or the web.config in the ReportServer IIS virtual directory. The relevant xml from the web.config is attached below.

I would appreciate any thoughts. I am running on W2K3 SP1. Thanks.

Mitch

<identity impersonate="false" />

<!--<authentication mode="Windows" />-->

<authentication mode="Forms">

<forms loginUrl="logon.aspx" name="sqlAuthCookie" timeout="60" path="/"></forms>

</authentication>

<authorization>

<deny users="?" />

</authorization>

Mitch, are you initially navigating to SSRS by using http://localhost or http://someMachineName?

If you hit your site with http://localhost/reports, you'll see the behavior you're mentioning above: (It's basically a side-effect of the way the code inside the Forms Auth sample is written). Try http://someMachineName/reports instead and see if you have better luck.

|||Thanks, that was it. Now I can proceed with integrating SSRS with IBM Tivoli Access manager!

Forms Authentication Not Working

I have installed SQL Server September CTP (Full Install) on a Windows 2003
Server with IIS 6 setup with SSL. I have also installed Visual Studio 2005
(Full Install).
I installed the custom security extension example that comes with the server
install and the AdventureWorks sample reports.
When I login to the web-based Report Manager I get the following error:
Key cannot be null. Parameter name: key
The error message is displayed on an rs manager like interface with no links.
I followed the instructions that came with the Custom security extension to
the tee. I have tried several different configurations including non-SSL and
nothing works.
Does anyone know what this error pertains to or has ANYONE been able to get
Forms Authentication work AT ALL? Microsoft is not responding to any of our
posts so I guess it's up to us.
Thanks in advance.I am having the same problem with the final release version. Did you ever
resolve this issue?
"Zach" wrote:
> I have installed SQL Server September CTP (Full Install) on a Windows 2003
> Server with IIS 6 setup with SSL. I have also installed Visual Studio 2005
> (Full Install).
> I installed the custom security extension example that comes with the server
> install and the AdventureWorks sample reports.
> When I login to the web-based Report Manager I get the following error:
> Key cannot be null. Parameter name: key
> The error message is displayed on an rs manager like interface with no links.
> I followed the instructions that came with the Custom security extension to
> the tee. I have tried several different configurations including non-SSL and
> nothing works.
> Does anyone know what this error pertains to or has ANYONE been able to get
> Forms Authentication work AT ALL? Microsoft is not responding to any of our
> posts so I guess it's up to us.
> Thanks in advance.

Formatting Database Server Need Procedure for Restoring Database

Hello,
I have a database server running windows 2000 server sp4, sql server 2000
sp3. I want to format this server and start fresh with an install of windows
2003 server standard edition and reload sql server 2000. My sql server
knowledge is very basic and I need to have a procedure for bringing the
database back to its current state after the format.
I have set up a test server. I loaded Win 2003 server, sql server 2000, and
sp3 for sql. I don't know if I have to restore my master,model, ect. backups
or if I can just restore my production database?
I copied a .bak file of my database to the test server and tried restoring
it using enterprise manager. Of course the data and log file locations are
going to be on one disk instead of two like the production server but I made
the neccearry change under options. When I click ok on the restore it comes
up with the restore progress windows but its already been and hour and no
progress. I do notice a created .mdf file in the restore path but no
indication of it doing anything else.
Your help is greatly apprecaited. Please contact me at
chris.witthoft@.durexproducts.com or christopherwitthoft@.hotmail.com
Thanks,
ChrisHi Chris
When restoring a new database there is usually a period at the beginning
when no bars appear. The larger the database is the longer it takes.
Did you check that the disc was not fragmented before you restored the
database, also did you check there was ample space for the database?
The following should give you a good idea of what you will need to do
http://support.microsoft.com/kb/314546
You need to service pack SQL Server on the new host to the same level as the
existing machine.
John
"Chris Witthoft" wrote:
> Hello,
> I have a database server running windows 2000 server sp4, sql server 2000
> sp3. I want to format this server and start fresh with an install of windows
> 2003 server standard edition and reload sql server 2000. My sql server
> knowledge is very basic and I need to have a procedure for bringing the
> database back to its current state after the format.
> I have set up a test server. I loaded Win 2003 server, sql server 2000, and
> sp3 for sql. I don't know if I have to restore my master,model, ect. backups
> or if I can just restore my production database?
> I copied a .bak file of my database to the test server and tried restoring
> it using enterprise manager. Of course the data and log file locations are
> going to be on one disk instead of two like the production server but I made
> the neccearry change under options. When I click ok on the restore it comes
> up with the restore progress windows but its already been and hour and no
> progress. I do notice a created .mdf file in the restore path but no
> indication of it doing anything else.
> Your help is greatly apprecaited. Please contact me at
> chris.witthoft@.durexproducts.com or christopherwitthoft@.hotmail.com
> Thanks,
> Chris