November 9, 2017 at 2:27 am
Hi everybody,
today i run into a strange problem.
Create a simple package which transfers only data from a mysql-Table to a MSSQL-Db.
When i run the package in my Visual Studio its all okay.
Deployed to the server the package runs into the error:
ADO NET Source has failed to acquire the connection {478F280C-DC10-49A4-AF71-D0AB85BF606A} with the following error message: "Reading from the stream has failed.".
Basics:
-> SQL-Server 2012
-> MySQL Connector 6.8.3
-> MySQL innodb_version 5.6.34-79.1, version: 10.1.20-MariaDB-1~jessie'
Does anybody knows the reason for this error - i dont find something like this with google 🙁
November 9, 2017 at 2:36 am
When you run a package in Visual Studio, it runs under the account you're logged in as. When you run it on the server, assuming you're running it as a SQL Server Agent job, it runs as the SQL Server Agent account, or whatever proxy you have configured. Therefore in situations like these, it's usually permissions that are the issue. Does the SQL Server Agent account have the necessary access to all resources involved in the transfer? Is the server on which the job is running the same server to which you are transferring data?
John
November 9, 2017 at 2:47 am
Our admins says the agent account has the correct rights.
It works also with other mysql Dbs without problems
November 9, 2017 at 2:59 am
Well, something's not right, is it? You may need to speak to your admins, whoever they are, and ask them to be a little more specific and tell you what rights the account has. You say it's a simple package that only moves data from a MySQL server to a SQL Server server, yet you have three connection managers. What is the third one for? Which connection manager does the error message refer to? Have you checked on the server mentioned in that connection manager for failed connection attempts? Is the server on which the job is running the same server to which you are transferring data?
John
November 9, 2017 at 3:07 am
Is it possible to get more infos about the error? The ssis-log shows only these error:
ADO NET Source has failed to acquire the connection {478F280C-DC10-49A4-AF71-D0AB85BF606A} with the following error message: "Reading from the stream has failed.".
Or maybe is it possible to test the connection on another way?
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply