HOW TO: ????? SQL Server ??? ???? ???? ???? ASP.NET

?????? ????????? ?????? ?????????
???? ???????: 317604 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

??????

???? ??? ??????? ???? ????? ??? ????? ????? Microsoft SQL Server ?????? ???? ???? ????? ??? ASP.NET SQL Server.

???????

???? ??????? ??????? ??????? ?????? ??? ????? ?????? ???????? ?????? ? ??? ??????? ???? ???????:
  • ????? Microsoft Windows 2000 Professional ?? ???? ??????? Microsoft Windows 2000 Server ?? ???? ??????? Microsoft Windows 2000 Server ?? Microsoft Windows XP
  • ???? ??? Microsoft .NET
  • ????? ??????? ???????? ?? Microsoft "(IIS)
  • Microsoft SQL Server

????? ???? SQL ?? ASP.NET ???? ???? ????? ???? SQL

??? ??????? ??????? ????? ????? InstallSqlState.sql ?? ????? ??????? ?????? UninstallSqlState.sql ????? ????? ???? ???? ????? ??? SQL Server.
  1. ?? ???? ??????? SQL ? ?? ??????? ???? ???? ??? ???.
  2. ?? ???? ?????? ??? ??? ??????? ? ?????? ??? ??? ???????? ????? InstallSqlState.sql ?? ???? ??? ???. ?????????? ???? InstallSqlState.sql ?? ??? ???????? ???????:
    system drive\WINNT\Microsoft.NET\Framework\ version \

    system drive\Windows\Microsoft.NET\Framework\ version\
  3. ??? ??? InstallSqlState.sql ?? ???? ??????? SQL "? ???? ??? ????? ??????? ??????? ?????? ???????? ?????.
  4. ??? ????? ??? ???????? ????? UninstallSqlState.sql ?????? ????? ????? ???? ???? ????? ??? SQL Server ? ??? ????? ????? w3svc. ?????? ????? ???? ??????? ???????:
    1. ?? ??????? ???? ? ?? ???? ??? ????? ????? cmd ?? ?? ???? ??? ????? ???? ???? ???????.
    2. ???? net stop w3svc ?? ???? ???????. ???? ????? ????? ????? w3svc.
  5. ?? ???? ??????? SQL ? ?? ??????? ???? ???? ??? ???.
  6. ?? ???? ?????? ??? ??? ??????? ? ?????? ??? ??? ???????? ????? UninstallSqlState.sql ?? ???? ??? ???. ?????????? ???? UninstallSqlState.sql ?? ??? ???????? ???????:
    system drive\WINNT\Microsoft.NET\Framework\ version \

    system drive\Windows\Microsoft.NET\Framework\ version\
  7. ??? ??? UninstallSqlState.sql ?? ???? ??????? SQL "? ???? ??? ????? ??????? ??????? ?????? ???????? ?????.
  8. ??? ????? ????? ????? ????? ???? ???? ????? ??? ???? SQL ??? ????? ????? ???? w3svc. ?????? ????? ????? w3svc ???? net start w3svc ?? ???? ???????.

????? ??? Web.config ????? ????? ??

?????? ????? ???? ???? ????? ??? ASP.NET SQL Server ??? ????? ?? <sessionstate> ???? ?? ??? Web.config ??????? ????? ?? ??? ???:
  1. ????? ??? ???<sessionstate> ???? SQLServer ??????? ???? ???? ????? ???? ??? ??????? ?? SQL Server.
  2. ????? ??? sqlConnectionString ?????? ????? ??????? ?? SQL Server. ?????? ??? ????: sqlConnectionString
    sqlConnectionString="data source=MySQLServer;user id=<username>;password=<strongpassword>"
    

    ????????? ?? ???? ???????? < ??? ????????? > ?????? ?????? ??? ??????? ??? ????? ????????.

    <sessionstate>??????? ??? ?? ???? ?????? ??? ???:
    <sessionState 
                mode="SQLServer"
                sqlConnectionString="data source=127.0.0.1;user id=<username>;password=<strongpassword>"
                cookieless="false" 
                timeout="20" 
        />
    						
    Ensure ?????? ???????? ???? ?????? ??????? ??? ????? ?? <sessionstate> ???? ? ??? ?????? ????????. ??? ???????? ???????? ???? ????? ??????.

??????? ??????? ????????

  • ??? ?? ??? ?????? ????? w3svc ??? ????? ??? ???????? ????? UninstallSqlState.sql ????? ????? ????? ???????:
    ?? ???? ????? ????? ???????? 'ASPState' ???? ??? ????????? ??????
  • ??? ??? ?? ??? ????? ????????? ?? ???? ASPStateTempSessions ??? ?????? ??? ?????? ????? ????? ??? ?????, ???? ?? ????? ???? SQL Server. ????? ????? ??? ??????? ???? ????????? ??????? ???????? ???? ???? ?? SQL Server. ???? SQL Server ????? ??? ??????.
  • ??? ??????? "????????? InstallSqlState.sql" ? "????? ??????? ?????? UninstallSqlState.sql ?????? ????? ???? ???? ????? ??? ASP.NET SQL Server ???? ????? ??? ??????? ASPStateTempSessions ???????? ASPStateTempApplications ??? ????? ?????? tempdp ?? SQL Server ???? ???????. ????? ??? ???? ?? ???? ????? ????? SQL Server ??? ???? ?????? ???? ???? ????? ???? ?? ??????? ?? ASPStateTempSessions ???????? ASPStateTempApplications.?????? ??? ??????? ?????? ??? ????? ????? ??????? ?????? ?????? ?????? ????? ???? ???? ??? SQL Server ???????? ?????? ???? ????? ??? ??? ????? ??? ????? ????? ?????? ???? ??? ??? ??????? ????? ?????? ?? "????? ??????? ?? Microsoft:
    311209HOW TO: ????? ASP.NET ?????? ???? ???? ????? ???? SQL ???????

?????

?????? ??? ??????? ??????? ???? ??? ???? ????????? ????????? ??????? ?? "????? ??????? ?? Microsoft:
305140INFO: ASP.NET ???????
307598INFO: ???? ???? ??? ????? ???? ASP.NET
236166??????? STOP NET ? NET ????? ??? ????? IIS ??? ????? ????? ???????
????? ?? ????????? ??? ????? ???? ???? ASP.NET ?????? ??? ????? Microsoft ??????? ??? ?????:
???? ???? ?????
http://msdn2.microsoft.com/en-us/library/87069683(vs.71).aspx

???? ????: ??????? ???? ??? "?" ???????? ??????? ?? ASP.NET (????? Magazine MSDN)
http://msdn.microsoft.com/msdnmag/issues/01/11/cutting/default.aspx

???????

???? ???????: 317604 - ????? ??? ??????: 29/???? ??????/1428 - ??????: 6.6
????? ???
  • Microsoft ASP.NET 1.1
  • Microsoft ASP.NET 1.0
  • Microsoft SQL Server 2000 Standard Edition
  • Microsoft SQL Server 7.0 Standard Edition
  • Microsoft SQL Server 2000 64-bit Edition
????? ??????: 
kbmt kbconfig kbhowtomaster kbstate kbwebforms KB317604 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????317604

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com