[Mono-bugs] [Bug 49415][Wis] New - mono C# fails to login to MS SQL Server 2000

[bugzilla-daemon@bugzilla.ximian.com]

Please do not reply to this email- if you want to comment on the bug, go to the
URL shown below and enter your comments there.

Changed by miguel@ximian.com.

http://bugzilla.ximian.com/show_bug.cgi?id=49415

--- shadow/49415	2004-04-28 20:04:04.000000000 -0400
+++ shadow/49415.tmp.14091	2004-04-28 20:04:04.000000000 -0400
@@ -0,0 +1,139 @@
+Bug#: 49415
+Product: Mono: Class Libraries
+Version: unspecified
+OS: unknown
+OS Details: Debian Stable -> Linux dev1 2.4.18-bf2.4 #1 Son Apr 14 09:53:28 CEST 2002 i686 unknown
+Status: NEW   
+Resolution: 
+Severity: Unknown
+Priority: Wishlist
+Component: Sys.Data.SqlClient
+AssignedTo: rodrigo@ximian.com                            
+ReportedBy: zopemonkey@yahoo.com               
+QAContact: mono-bugs@ximian.com
+TargetMilestone: ---
+URL: 
+Summary: mono C# fails to login to MS SQL Server 2000
+BugsThisDependsOn: 50918[FIXED]
+
+Please fill in this template when reporting a bug, unless you know what you
+are doing.
+Description of Problem:
+
+Using mono's C# SqlConnection class to connect and login to a MS SQL Server
+2000 that has encryption enabled fails with this error:
+
+Error: 17832, Severity: 20, State: 9 
+Connection opened but invalid login packet(s) sent.  Connection closed. 
+
+
+Steps to reproduce the problem:
+1.  SqlConnection conn = new SqlConnection("Integrated
+Security='SSPI';Initial Catalog='dbname';Data Source='1.2.3.4,1433';Network
+Library='DBMSSOCN';User ID='username';Password='password';Connect
+Timeout=30;"); // obvious values changed for example.
+2.  conn.Open()
+3.  the above error happens. the ip, database, username, and password are
+all correct.
+
+Actual Results:
+
+Error: 17832, Severity: 20, State: 9 
+Connection opened but invalid login packet(s) sent.  Connection closed. 
+
+
+Expected Results:
+
+to login to sql server
+
+
+How often does this happen? 
+
+Every time.
+
+
+Additional Information:
+
+freetds and perl modules have the same problem, maybe this is something
+that has existed before, yet couldnt find anything in the bug database when
+searching for the error.
+
+you can email me at chris@burst.net and i can provide more details and code
+i use if need be. i just downloaded and compiled mono yesterday (the source
+on the release page 0.28).
+
+------- Additional Comments From zopemonkey@yahoo.com  2003-10-08 09:29 -------
+oops, from reading the source of TdsClient, seems that Integrated
+Security isnt even supported, the api params exist, but the code
+doesnt do anything with them. 
+
+is there a time frame for this to get done or people working on it?
+this is kinda important for communicating with win2k sql server with
+ssl enforced (which it should have by default anyways).
+
+thanks,
+chris
+
+------- Additional Comments From gonzalo@ximian.com  2003-10-09 23:43 -------
+Can't you use stunnel?
+
+------- Additional Comments From danielmorgan@verizon.net  2003-10-27 22:56 -------
+FreeTDS actually has Integrated Security (Windows NT Authentication) 
+now.  FreeTDS calls this Domain Authentication.  
+
+http://www.freetds.org/userguide/x1358.htm
+
+TDS Protocol
+http://www.freetds.org/tds.html
+
+Info on NTLM.  Look at the references at the bottom of this page.
+http://www.innovation.ch/java/ntlm.html
+
+Do a search on the web for NTLMSSP.
+
+http://www.opengroup.org/comsource/techref2/NCH1222X.HTM
+
+Imlementation of NTLMSSP in Java.
+http://jcifs.samba.org/src/docs/api/jcifs/http/NtlmSsp.html
+
+
+
+
+------- Additional Comments From danielmorgan@verizon.net  2003-12-06 13:00 -------
+An implementation of NTLM has been added to Mono as
+Mono.Security.Protocol.Ntlm thanks to Sebastien Pouliot.
+
+NTLM should work on Linux, but I have not tested it.
+NTLM does not work for me on Windows due to bug 50918.
+
+I have some patches for Integrated Security aka Domain Login support.
+The NTLM message handling came from Sebastien Pouliot.
+
+I will post the patches here later.
+
+
+
+
+------- Additional Comments From danielmorgan@verizon.net  2003-12-06 14:09 -------
+Created an attachment (id=6132)
+Patch for NT Authentication in Mono.Data.Tds
+
+
+------- Additional Comments From danielmorgan@verizon.net  2003-12-06 14:10 -------
+Created an attachment (id=6133)
+Patch for NT Authentication in System.Data.SqlClient
+
+
+------- Additional Comments From danielmorgan@verizon.net  2003-12-06 14:12 -------
+Will need regression testing to make sure that SQL Server 
+authentication still works correctly.
+
+------- Additional Comments From spouliot@videotron.ca  2003-12-17 23:06 -------
+Commited the first patch into CVS (from danmorg) as it works for me 
+(but not from him). I can't apply the second patch without having 
+lots of CR/LF and tabs issues (leading to a much larger diff with 
+CVS than normal).
+
+------- Additional Comments From miguel@ximian.com  2004-04-28 20:04 -------
+What is the status on this bug, are there any patches that need
+to be commited?