I have to Virtual Machines, one with Windows XP and the other with Windows Server 2008. In my XP VM I have SQL Server 2000 with a database that is my datasource. In WS 2008 I have SQL Server 2008 R2 with an SSIS package to pull data from SQL Server 2000.
My problem: I can not connect to SQL Server 2000, I can not create a connection in my SSIS package. The error says "The connection faild because of an error in initializing provider. Login file for user sa" I am using sa user for the connection and of course this user has access to the database.
Things I have done:
-Both VM do ping between each other.
-I am using Native OLE DB\ Microsoft OLE DB Provider for SQL Server
-Did this configuration from this tutorial: https://msdn.microsoft.com/en-us/library/dd327979.aspx
I continue with the problem, I need to use Sql Server Authentication. Please if any one has another suggestion, please help.