???? ID: 317604 - ????? ???????: 04 ?????? 2010 - ??????: 2.0

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

???? ?????? ???????????? ?????? ???????? KB ?? ???????? ????? ?? ??? ???? ????? ????
?? ???????? ?? ?????? ??? ?? ?? ???? ???? ???? ??.
?????? ??????This article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.

?? ????? ??

??? ?? ??????? ???? | ??? ?? ??????? ????

??????

?? ??? ?? ??? ???? ????????? ???? ?? ?? asp.NET SQL ????? ??? ???? ?????? ??????? ?? ??? Microsoft SQL ????? ?? ???????? ???? ?????

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

??????????

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

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

????? ????? ?? ????? ??? ???? ?????? ??????? SQL ????? ?? ???????? ???? ?? ??? InstallSqlState.sql ?? UninstallSqlState.sql ????????? ????? ?? ????? ?? ??? ???? ?????
  1. ??? SQL ?????? ???????? ?????????? ??,?????.
  2. ??????????? ????? ?????????? ????? ???, InstallSqlState.sql ????????? ????? ??????? ????, ?? ???? ??? ????? ?????????. ???????? ??? ??, InstallSqlState.sql ????? ????????? ??? ?? ?? ??? ????? ??:
    ?????? ??????\WINNT\Microsoft.NET\Framework\???????\

    ?????? ??????\Windows\Microsoft.NET\Framework\version\
  3. ??? SQL ?????? ???????? InstallSqlState.sql ????? ??, ?? ??? ????? ????????????? ????????? ?????????????? ????????? ????? ?? ??? ???
  4. ????? ?? ???? UninstallSqlState.sql ????????? ????? ?? SQL ????? ??? ???? ?????? ??????? ??????????? ?? ??????? ???? ???? ?? ???, ???? w3svc ????????? ?? ????? ?????? ??? ??? ???? ?? ???, ????? ????? ?? ???? ????::
    1. Windows ????????????? ??,???????????:cmd?? ????-????? ????, ?? ???? ???OK?? ??????? ????????? ??????
    2. ??????? ????????? ??????? w3svc NET. ???? ?????? ?? ?? w3svc ????????? ??? ?? ???
  5. ??? SQL ?????? ???????? ?????????? ??,?????.
  6. ??????????? ????? ?????????? ????? ???, UninstallSqlState.sql ????????? ????? ??????? ????, ?? ???? ??? ????? ?????????. ???????? ??? ??, UninstallSqlState.sql ????? ????????? ??? ?? ?? ??? ????? ??:
    ?????? ??????\WINNT\Microsoft.NET\Framework\???????\

    ?????? ??????\Windows\Microsoft.NET\Framework\version\
  7. ??? SQL ?????? ???????? UninstallSqlState.sql ????? ??, ?? ??? ????? ????????????? ????????? ?????????????? ????????? ????? ?? ??? ???
  8. ?? SQL ????? ??? ???? ?????? ??????? ??????????? ??????? ???? ???? ?? ??? w3svc ???? ???????? ???? ?????? ??? W3svc ????????? ?? ???????? ???? ?? ??? ???????? ??????? w3svc????? ????????? ???
????? ?? ???? ????

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

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

    ???:??????????, <user name="">?? ?? ???????? ???? ?? ??? ????????? ???? ?????</user> ????????

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

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

  • ??? ?? UninstallSqlState.sql ????????? ????? ?? ????? ?? ???? w3svc ????????? ?? ??? ????, ???? ????? ?????? ????? ????? ??:
    ??????? 'ASPState' ????? ???? ?? ???? ??????? ?? ??? ????? ??? ??
  • ??? ??? ????????????ASPStateTempSessions?????? ??????? ???? ?? ?????? ???? ?? ??? ?????? ???? ???, ????????? ???? ?? SQL ????? ????? ?? ??? ??? ?? ?? ??????????? SQL ????? ??? ????? ?? ?????? ?? ??????? ???????? ???????????? ?? ?????? ?? ??????????? ?? ???? ???? ???????? ???? SQL Server ????? ?? ?? ??????
  • ?? ?? ??????? InstallSqlState.sql ?? UninstallSqlState.sql ????????? ??????? ?? ????? ??? ???? ?????? ??????? asp.NET SQL ????? ?? ???????? ???? ?? ???, ??? ?? ?? ??????? ??????ASPStateTempSessions??ASPStateTempApplications???? ?? ??? ????????tempdb??????? SQL ????? ??? ???????? ??? ??? Furthermore, ??? ?? SQL Server ???????? ????, ?? ?? ???? ?????? ???? ??? ???????? ???? ??? ?? ??ASPStateTempSessions??ASPStateTempApplications???????????????? SQL Server ???? ?????? ??????? ???????? ???? ???? ???? ???? ?? ???? ?? ?? ?? ????? ?? ???????? ???? ?? ??? ???????? ????????? ????? ?? ??? ???? ???? ?? ???? ??? ???????? ??????? ?? ??? Microsoft ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
    311209  (http://support.microsoft.com/kb/311209/EN-US/ ) TO HOW: ???????? asp.NET ??????? SQL Server ???? ?????? ?? ??????? ?? ???
????? ?? ???? ????

??????

???????? ??????? ?? ??? ?????? ?? Microsoft ???????? ??? ????? ?? ??? ????? ???? ???????? ?? ????? ????:
305140  (http://support.microsoft.com/kb/305140/EN-US/ ) ?????: asp.NET Roadmap
307598  (http://support.microsoft.com/kb/307598/EN-US/ ) ?????: asp.NET ?????? ??????? ????? ???
236166  (http://support.microsoft.com/kb/236166/EN-US/ ) ????????? Re-Read ???? ?? ??? NET STOP ?? ?? IIS ?????? ??????? NET ???? ?? ????? ????
ASP.NET ???? ?????? ??????? ?? ???? ??? ???? ??????? ?? ??? ????? Microsoft ??? ???? ?? ????? ????:
???? ??????
(vs.71) http://msdn2.Microsoft.com/en-us/library/87069683 .aspx (http://msdn2.microsoft.com/en-us/library/87069683(vs.71).aspx)

Cutting ??????: ????? ???? ?? ????????? ?? ???????? ??? asp.NET (???MSDN Magazine????)
HTTP://MSDN.Microsoft.com/msdnmag/issues/01/11/cutting/default.aspx (http://msdn.microsoft.com/msdnmag/issues/01/11/cutting/default.aspx)
????? ?? ???? ????
???? ???? ???? ??:
  • 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
????? ?? ???? ????
??????: 
kbconfig kbhowtomaster kbstate kbwebforms kbmt KB317604 KbMthi
????? ?? ???? ????
???? ?????? ???????????? ?????? ????????
??????????: ?? ???? ?? ???? ??????? ?? ????? ?? Microsoft ????-?????? ?????????? ?????? ?????? ???? ??? ??. Microsoft ???? ??? ????-???????? ?? ????-???????? ????? ?????? ?? ???? ???????? ???? ?? ???? ????? ????? ??? ?? ??? ?????? ?? ???? ???? ???? ??? ????? ??. ???????, ????-???????? ???? ????? ???? ???? ???? ???. ?????, ????????, ?????-???? ?? ??????? ?? ???????? ?? ???? ???, ???? ?? ??? ?????? ???? ???? ??? ????? ??? ?? ???? ??. Microsoft ??????? ??? ???? ?? ?????? ?? ??????????, ????????? ?? ??? ?????? ?? ???? ????? ?? ???? ???????? ?? ??? ???? ????? ?? ??? ????????? ???? ??. Microsoft ????-?????? ?????????? ?? ????? ?????? ?? ?? ??? ??.
?????????? ?? ??????? ????????? ??????? ??:317604  (http://support.microsoft.com/kb/317604/en-us/ )
????? ?? ???? ????