how to handle database stored session variables in mirror setup? -


we have changed system having single database mirrored setup primary, secondary , witness servers. sql server 2012 std.

the applications on web servers configured connectionstring containing failerover partner keyword. far - application database.

but applications web.configs use

sessionstate mode="sqlserver"... <

connectionstring because store sessions variables in database. worked fine when there single database server need figure out how set in mirrored database environment.

what recommended way handle applications keep running if primary db server goes down? don't care if sessions lost when application switches on secondary db-server, thought creating aspstate database on both primary , secondary db server work. seems not able create aspstate database on mirror.

(running aspnet_regsql.exe -s server6102 -u aspstatedbo -p supersecretpswd -ssad d -sstype p gives me "access denied." created user aspstatedbo user on secondary sql server in same way , same password did on primary running aspnet_regsql command on secondary gives me access denied.)

i'd appreciate general recommendations on how setup session handling in scenario - 2 or more web servers , failover sql server cluster.

(mirroring aspstate database felt bit unnecessary me. doesn't matter if sessions lost in odd event primary server goes down. long new sessions automatically handled mirror then. mirroring aspstate, alongside mirrored application database,database brings lot of unnecessary added latency hilary said.)

is there no way duplicate aspstate database achieve want?


Comments

Popular posts from this blog

android - InAppBilling registering BroadcastReceiver in AndroidManifest -

python Tkinter Capturing keyboard events save as one single string -

sql server - Why does Linq-to-SQL add unnecessary COUNT()? -