Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Jan 01, 2013 04:41 PM by anujrathi
Jan 01, 2013 09:11 AM|LINK
we have more than 50 websites which are ruuning in a single database. Now, I have to implement Single Sign In functionlaity in all websites. So, I have decided to store Session in SQL server. I have run aspnet_regsql.exe with approprite options.
But this tool has created all Stoted Procedures in "dbo" Schema. Is there any way to install script in different Schema?
I can't use dbo because this is highly secured database & we can not allow user with dbo permission. I have created different Schema for tables,views & Stored Procedures & application user has only execute permmission on stored procedures.
Is it possible to save Session State in my database without giving "dbo" permission & related tables/Views/Stored procedures should be in a Schema (e.g.: TestSchema) other than dbo.
Can I configure Session State by creating a seperate user (say sessionUser) & a Seperate Schema (e.g.: SessionSchema) by providing the the full permission of this perticular Schema
Jan 01, 2013 02:38 PM|LINK
I'm confused why single sign on has anything to do with session state.
Jan 01, 2013 04:41 PM|LINK
You are right. Mainly I am a DB guy (but have knowledge of .NET also).
I was bit confuesed in Session & Authentication(forms). After a lot R&D & testing on various domains, I have found a way. Pls let me know, Is it correct?
1. I have set default common domain for httpCookie in web.config in all applications. Now all cookies will use same domain.
2. I have changed the Machine Key settings & these are same accross all applications.
3. domain atribute in forms authentication node in web.config is same accross all applications.
& this tecgnique is working fine without implementing sql server Session State.
But I still want to know, Can we install ASPState DB in any other Schema?