jeudi 9 avril 2015

MySQL Connector/NET error when using Windows integrated security on Windows Server 2008

I am getting a MySqlException when creating a connection using Windows integrated security via MySQL Connector/NET 6.9.6.0, but only on Windows Server 2008 (64-bit). Other operating systems on which my code is working without any errors are: Windows 7 (64-bit), Windows Server 2008 R2 (64-bit).


The details of the exception from Connector/NET on Windows Server 2008 are:



MySql.Data.MySqlClient.MySqlException (0x80004005): Authentication to host 'localhost' for user 'username' using method 'authentication_windows_client' failed with message: Reading from the stream has failed. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Reading from the stream has failed. ---> System.IO.EndOfStreamException: Attempted to read past the end of the stream. at MySql.Data.MySqlClient.MySqlStream.ReadFully(Stream stream, Byte[] buffer, Int32 offset, Int32 count) at MySql.Data.MySqlClient.MySqlStream.LoadPacket() at MySql.Data.MySqlClient.MySqlStream.LoadPacket() at MySql.Data.MySqlClient.MySqlStream.ReadPacket() at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.ReadPacket() at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.AuthenticationFailed(Exception ex) at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.ReadPacket() at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.AuthenticationChange() at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.HandleAuthChange(MySqlPacket packet) at MySql.Data.MySqlClient.Authentication.MySqlAuthenticationPlugin.Authenticate(Boolean reset) at MySql.Data.MySqlClient.NativeDriver.Authenticate(String authMethod, Boolean reset) at MySql.Data.MySqlClient.NativeDriver.Open() at MySql.Data.MySqlClient.Driver.Open() at MySql.Data.MySqlClient.Driver.Create(MySqlConnectionStringBuilder settings) at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection() at MySql.Data.MySqlClient.MySqlPool.TryToGetDriver() at MySql.Data.MySqlClient.MySqlPool.GetConnection() at MySql.Data.MySqlClient.MySqlConnection.Open()



The connection string is:



database=<database_name>;server=localhost;port=<port>;defaultcommandtimeout=0;allowuservariables=True;Integrated Security=True;user id=<username>


Has anyone run into this issue before?


Aucun commentaire:

Enregistrer un commentaire