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

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

?? ????? ??

??????

?? ??? ?? ??? ???? ????????? ???? ?? ?? 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 ???????? ??? ???? ????? ?? ??? ????? ???? ?????? ?? ????? ????:
    311209TO HOW: ???????? asp.NET ??????? SQL Server ???? ?????? ?? ??????? ?? ???

??????

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

Cutting ??????: ????? ???? ?? ????????? ?? ???????? ??? asp.NET (???MSDN Magazine????)
HTTP://MSDN.Microsoft.com/msdnmag/issues/01/11/cutting/default.aspx

???

???? ID: 317604 - ????? ???????: 04 ?????? 2010 - ??????: 2.0
???? ???? ???? ??:
  • 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

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

 

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