Проект, в котором вы можете поучаствовать: SQL Server Authentication Troubleshooter

???? ??????!

? ????????? ?? ???????? ?????? ?????, ? ???????? ???????, ??????? ?????? ?????? ??????????????? ??? ?????? ???????? ??????? ?????? ???? ‘Login Failed’.

??????? ? ???????? ??? ???????? ??? ?????????? ?? CodePlex: https://ssat.codeplex.com/

??? ??? ??? ???????????? ??? Microsoft Public License ?? ?? ????? ????????????, ? ??? ?? ???????????? ? ????????????? ???????? ???.

? ??????, ???? ?? ???????, ???? ?? ??????? ???????? ????????????? ? ??????? (????????? ??????????? ?? CodePlex) ? ????????????????? ??? ???????.

?????? ??? ???????? ?????? ???????? – ?? ????? UI (????????? ??????), ? ???????? ????????? ????????? connection string, ????? ???????????.

? ?????, ???? ???? ???????? – ??????? ??????.

????????? ? ??????? ????????????????.

?????????? SQL Server Authentication Troubleshooter.

??????? ?? C# (.Net 2.0 – ?? ????? ???????????? ????? ??????? ??????, ?.?. ??? ??????????? ?????????? ??? SQL Server 2008)?

?????????? xEvents (?????????????? ?????? ??????????? – ????? ???????? ?????? ? SQL Server 2008) ? ?????? ????????? ???? ?????? (sys.dm_os_ring_buffers) .

??? ????????????? ??????????, ????? ????????????? (??? ???????????? ? ?????? Control Server) ??? ??????? ???????????? , ?.?. (???????????? ???????????) – ??? ?? Connectivity troubleshooter, ????????? ?????? ???????????????, ??????? ???????? ????? ??????? ??????? ?????? ?? ??????? SQL ???????.

???????? ? ???? ??????? – ?????????? ? ??????. ? ?????? ??????????? ?????? ???????? ?????????? ?? ??????? ???? ‘Login Failed’ ? ?????????? ?? ??????? ??????, ???????, ?????????? ? ?.?.

? ?????? ??????? – ??????????? ??????? ?????????? (?????) ?????? ???? ‘Login Failed’.

?????????????:

ATSDriver.exe connection_string [-M ]

connection _ string?????????? connection string ?????????????? ??? ???????????? ? ??????? Control Server, ??????? ??????????? ????????.

- M ???????????? ???????? ???????? ????? ???????????.

????? ???????? (??-?????????) ????? ???????? ?? ????? https://ssat.codeplex.com/documentation

??? ?? ???????? ?? ?????? ????????? J ? ???, ??? ?? ????? ???? ???????? ?????????: https://ssat.codeplex.com/Thread/List.aspx

? ?????, ???????????????, ???? ???? ??????? ? ?????. ? ????????? ???????, ???? ? ???-?? ????????? ???????? (??? ?????? ????? J).