Проект, в котором вы можете поучаствовать: 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).