Session state not working on windows azure

Question

Session state not working on windows azure

Here is my SessionState settings in web.config

<sessionState cookieless="false" mode="SQLServer"
sqlConnectionString="data source=xxxxxxxxx.database.windows.net;Database=xxxxxx;User ID=testuser@m9f6otec68;Password=xxxxxxx;Trusted_Connection=False;Encrypt=True;"
timeout="20"
allowCustomSqlDatabase="true"
/>

It is working properly on localhost

Answer 1

Hi JignseshJ,

Can you be more specific? Or you getting errors or weird behaviors? If so, can you describe it?

Are you just using SQL Azure as your SessionState DB? Do you have a WebRole?

---

Best Regards,
Carlos Sardo

Answer 2

Hi Carlos,

I did not get any error. When I checked the sql azure db session table, I did not see any session entry. I am using InProc now.

There is a one webrole.

Here is a web.config setting for session state :

<sessionState cookieless="false" mode="SQLServer"
sqlConnectionString="data source=xxx.database.windows.net;Database=SessionSqlState;User ID=xxx;Password=xxxx;Trusted_Connection=False;Encrypt=True;"
timeout="20"
allowCustomSqlDatabase="true"
/>

Thank you.

Answer 3

Hi,

You could take a look at using the Windows Azure Cache for session state storage. There is a walk-through on this here

http://msdn.microsoft.com/en-us/wazplatformtrainingcourse_buildingappswithcacheservice_topic3.aspx

Regards,

Alan

---

Free EBook: "Windows Azure Service Bus Developer Guide" http://www.cloudcasts.net/devguide/

Answer 4

Hi JignseshJ, 

Don't use SessionState InProc, use Windows Azure Cache instead.

Hope this helps!

---

Best Regards,
Carlos Sardo

Answer 5

Hi Carlos,

I can not use azure cache due to pricing. I know SessionsState InProc will create problem with multiple instance.

Thank you.

Jignesh

Answer 6

Jignesh,

Windows Azure Cache (preview) is free! It runs on your Web/Worker Role(s).

---

Best Regards,
Carlos Sardo