Post reply

Using Data Reader in SSIS Packages to Connect to MYSQL

  • March 27, 2008 at 1:46 pm

    #120653

    hi,

    I am doing migration project.i need to connect to the MYSQL database using the Data Reader.

    It worked fine for some time there after i am getting the error

    MySql.Data.MySqlClient.MySqlException: Access denied for user ' xxx '@' 11.2.102.123' (using password: NO)

    at MySql.Data.MySqlClient.MySqlStream.OpenPacket()

    at MySql.Data.MySqlClient.NativeDriver.Authenticate411()

    at MySql.Data.MySqlClient.NativeDriver.Authenticate()

    at MySql.Data.MySqlClient.NativeDriver.Open()

    at MySql.Data.MySqlClient.MySqlPool.GetPooledConnection()

    at MySql.Data.MySqlClient.MySqlPool.GetConnection()

    at MySql.Data.MySqlClient.MySqlConnection.Open()

    at Microsoft.SqlServer.Dts.Runtime.ManagedHelper.GetManagedConnection(String assemblyQualifiedName, String connStr, Object transaction)

    at Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSConnectionManager90.AcquireConnection(Object pTransaction)

    at Microsoft.SqlServer.Dts.Pipeline.DataReaderSourceAdapter.AcquireConnections(Object transaction)

    at Microsoft.SqlServer.Dts.Pipeline.ManagedComponentHost.HostAcquireConnections(IDTSManagedComponentWrapper90 wrapper, Object transaction)

    Please let me know if anybody has come across this problem & solution for overcomming it.

  • March 28, 2008 at 4:25 am

    #795054

    Does the user 'xxx' exist and have the correct password and permission to log on from the host specified? I see from the error message that no password is being supplied for the logon - is this correct? Check that the credentials you're supplying from SSIS are correct and check on the user table on the mysql database to see what priviledges you have.

    Kindest Regards,

    Frank Bazan

  • May 28, 2008 at 1:45 am

    #821012

    Hi,

    I have exactly the same problem: the user account exists and has permissions, when test the connnection in "Connection Managers" then the test result is OK (here there are two text boxes, one for the user name, one for the password and there is one "Save my password").

    The interesting thing is that the error message is about "username"@"localhost" and not the previously give account.

  • May 28, 2008 at 3:17 am

    #821037

    If you have all the required permissions in your mysql database, then check your package encryption.

    Remember that encrypting sensitive with UserKey (this is the default I think) means that other accounts trying to run the package won't be able to. In other words the developer running it on BIDS will be able to run it, but the SQL Agent account will not.

    If you've set the package encryption to DontSaveSensitive, then you will have to set the password via a configuration at runtime. Remember if you're using an XML configuration, that each time you save the package, the password will lost.

    HTH

    Kindest Regards,

    Frank Bazan

  • May 28, 2008 at 8:35 am

    #821213

    Hi,

    thank you for the reply, the solution was easier :(, I had to delete all of the connections and rebuild them and it works.

    PS: I relized that sometimes the connection will be wrong without any modification )and I have to "restart" the project).

    Thanks a lot.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply