how the session states are stored in sql server ...where it will be configured before store it into sql server ?

You consistently post in the wrong forum, this belongs in MSSQL. On top of that this question does not make any sense -- How do you configure a session before the session exists? Are you asking about ASP.NET session state integration with MSSQL, or the state of an SQL connection being opened?

Either way this has nothing to do with C#.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.