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" />

No comments: