Monday, August 4, 2008

Creating the ASPState database

at command prompt:

sql authentication:
aspnet_regsql -S localhost -U lorem -P 1psum -ssadd -sstype p

windows authentication:
aspnet_regsql -S localhost -E -ssadd -sstype p



aspnet_regsql -S localhost -E -ssadd -sstype c -d Dial800ASPState

and then in the web.config

<sessionState mode="SQLServer" cookieless="false" timeout="1440" sqlConnectionString="data source=localhost; initial catalog=Dial800ASPState; user id=lorem; password=1psum" allowCustomSqlDatabase="true" sqlCommandTimeout="120" />

Machine key settings - web.config

Machine key settings in between system.web

< 
machineKey 
validation="SHA1"
decryption="AES"
validationKey="06B52A1252C98B3EC549F1AC96C881F07EAA4FA9261BF1844E5997FA64FD2A6503808B00FE6E79D18F559E92825AA0CE802575A0E02814DB6EDBEDFA6C8623CC"
decryptionKey="ABAA84D7EC4BB56D75D217CECFFB9628809BDB8BF91CFCD64568A145BE59719F"/ >

Recomended:

validationKey 128 char-length value for SHA1
decryptionKey 64 char-length value for AES