Transcript Configuring ASP Session state on SQL server 사용

Configuring ASP Session
state on SQL server 사용
1.
2.
3.
4.
SQLExpress 를 설치
첫번째로. "명령 프롬프트를" 를 관리자모드에서 실행시킨다.
C:\Windows\Microsoft.NET\Framework\v4.0.30319 경로로 이동
명령어 입력
- aspnet_regsql –S .\SQLExpress –U sa –P plus123!@# -ssadd –sstype p
- 데이타베이스 사용자 추가
명령 프롬프트에서
C:\>sqlcmd -S localhost -U sa -P plus123!@#
1> -- Set ASPState as the current database
2> USE ASPState;
3> GO
Changed database context to ASPState '.
1> -- Create a new server login name: ATMS
2> CREATE LOGIN ATMS WITH PASSWORD = plus123!@#'
3> GO
1> -- Create a new database user linked to the login name
2> CREATE USER ATMS FOR LOGIN ATMS;
3> GO
1> -- Grant database ALTER permision to the user
2> GRANT ALTER To ATMS;
3> GO
1> -- Grant database CONTROL permision to the user
2> GRANT CONTROL To ATMS;
3> GO
- Web.Config 수정
<authentication mode="Forms" />
<sessionState allowCustomSqlDatabase="true" cookieless="UseCookies"
mode="SQLServer" sqlCommandTimeout="1440"
sqlConnectionString="Server=10.0.12.29\SQLExpress,1433;Database=ASPState;User ID=ATMS;Password=plus123!@#"
timeout="60" />