Unable to connect framework 8.5 with MSSQL

[Django]

Thanks.

[cavagnaro]

Fixed?

Enviado de meu SM-N9600 usando o Tapatalk

[cavagnaro]

[quote author=Janis link=topic=11542.msg52541#msg52541 date=1582182605]
I'd recommend to use Wireshark on port 1433. You will see more information about your problem.
[/quote]SQL is encrypted... You can't see the negotiation using standard Wireshark

Enviado de meu SM-N9600 usando o Tapatalk

[Janis]

I was able to get the error from there when password was wrong in the .cfg file.

[cavagnaro]

Wasn't SQL Profiler?

Enviado de meu SM-N9600 usando o Tapatalk

[Janis]

No. But you are very likely right in case when login was successful but later do not have some internal rights in MSSQL like it was in this case. Checking MSSQL logs would be more universal method.

[cavagnaro]

Not because rights, it is because sql natively encrypts all communications even before login... So... Kinda hard to imagine how you could catch a wrong password using Wireshark. Because of the protocol, not because of the negotiation.


Enviado de meu SM-N9600 usando o Tapatalk

[Janis]

Made a quick test. Here is the content of captured packet received from MSSQL server:


[code]H*~
)CT%E\@:_C9 jPhmTHLogin failed for user 'sa'. MSSQL2012[/code]

[cavagnaro]

[emoji102] Welp... Hehe what a surprise
Thanks for taking the time to show me! Appreciate it
Thanks!

Enviado de meu SM-N9600 usando o Tapatalk