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

???? ???????: 815146 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???????? ????? ????? ??????? ?????? ?????? ???????
????? ???? | ?? ????

?? ??? ??????

??????

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

?????? breeches ?????? ??????? ?????? ?? ????????? ?????? ???????? ???? ?? ??????? ???????? ????? ??????? ?????????? ?????? ???. ??? ???? ??????? ?? ??? ??????? ????? ???? ?? ?????? ????? ???????? ???? ???? ???? ??????? ?????? ????????? ??? ???????? 1433 ???? TCP. ???? ???????? ?????? ???? SQL ??? ?????? ???.

???? ????? ?????? ??????? ????? ?? ?? ??????? ??????? (??? ????????? ?????????? ????????) ?? ????? ????? ??????? ?????????? ???? ?????? ??????? ??????? ????? ???????? ?????????. ??????? ?????? ?? ????????? ???? .NET SQL Server ????? ????????. ?????? ??? ????? ????? ??? ????????? ??????? ?? ????? ?????? ?? ????? ??? ?????? ?????????. ???? ??? ??????? ????? ????? ?? ?? ??? ?????? ???? ??????? ???? ??????? ?????? SQL Server ? ??? ?????? ???? ??????? ????? ???? .NET ??????? ?? ???? ??????? ?????? SQL Server.



????? ??? ???? ???? SQL


??? ????? ?????? ??????? ??????? ?????? ?????? ????????? ????? ???? ??????? ?????? SQL Server TCP/IP ??????? ?????????:
  1. ???? ??? ???? ? ???? ??? ??????? ?? ?? ???????? ??? Microsoft SQL Server. ???? ??? ?????? ???????? Network Server.
  2. ?? ??????? ????????? ????? ???? ??? TCP/IP ?? ???? ??? ?????.
  3. ????? ?????? ????????? ??? ??? ?????? ???? ?????. ?????????? ??? ????? ??? ?????? ??? 1433.
  4. ???? ??? ????? ?????? ??? ?????? "?????? ????????" ?? ???? ??? ?????.
  5. ????? ????? SQL Server ??? ????????? ????? ???????.

????? ????? .NET

?????? ?????? ????????? ???? .NET ???????? ??????? ?? Microsoft SQL Server ???? ??????? ???????:
  1. ??? ??? .config ??????? ????? ?? ?? ???? ?? (??? ???????). ???? ???? ??? .config ??????? ?? ?????? ????? ???????? ????? ???? .config Application Name. ??????? ASP.NET ??? ?? ???? ????? ????? .config Web.config ?? Application Name.
  2. ???? ???? ???? .NET ????????? ???? ????? ????? ?????? ?????? ?????? ?????? ???? ????????. ????? ???? ???????? ????? ???? ?????? ???? ????? ????????. ??? ???? ????? ??????? ???? ???? ?? ????? ????? ?????? ????? ???? ????????. ????? ?? ??? .config (?? ???????) ?? ?????? ???? ?????? ???? ????????. ???? ???? ????? ????? ???? ???????? ????? ???? ?????????? ???????? ?? dsn. ??? ???? ??????? ????? ?????? ?? ???? <appsettings>????? ?????? ?? ????? ????? ?????? ???? ???????? ????? ????? ????????:
    <appSettings>
	<add key="appDSN" value="data source=SERVER-NAME;initial catalog=ratings;integrated security=SSPI;persist security info=False;packet size=4096" />
</appSettings>
  3. ????? ???? ???????? ??????? ??? ?????? ?????? ????? ?? ?? ???? ????? ????? ???? ???? ??? ??? ???? ????? ???????? ?? ????? IP. ?????? ??????? ? SERVER-NAME,port ?. ??? ???? ??????? ?????? ??????? ???????? ???? ??????? ?????? SQL Server ???? SQLDB ???? ??? ???? ?? 5656 ????? ?????? ??? ???? ???????? = SQLDB ? 5656.
  4. ??? ??? .config. ????? ????? ??????? ASP.NET ???????? ??? ????? ???? ????????. ??? ???? ????? ????? ???? ????? ????????? ???? .NET ??????? ???? ??????? ??????.

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

?????

?????? ??? ??????? ??????? ???? ??? ????? ???????? ??????? ?????? ?? "????? ??????? ?? Microsoft:
315736
(http://support.microsoft.com/kb/315736/EN-US/ )
HOW TO: ?????? ????? ASP.NET ?? ???? ??????? ???? Windows
315588
(http://support.microsoft.com/kb/315588/EN-US/ )
HOW: ????? ASP.NET ??????? ???????? ???? ?????? ??????
818014
(http://support.microsoft.com/kb/818014/EN-US/ )
HOW: ????????? ???? ????? ??? ?????? .NET Framework ??????


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

???????

???? ???????: 815146 - ????? ??? ??????: 28/???/1424 - ??????: 2.5
????? ???
  • Microsoft .NET Framework 1.0
  • Microsoft .NET Framework 1.1
????? ??????: 
kbmt kbsystemdata kbsecurity kbhowtomaster kbconfig KB815146 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????815146
(http://support.microsoft.com/kb/815146/en-us/ )
???? ??? ?????? | ????? ???????

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

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