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.
Regards, Anabel
Best Answer
Finally I had no problems to connect to SQL 2000 from SQL 2008 R2 is perfectly posible. My problem was a configuration problem between my two virtual machines. I tried to do the connection in a normal enviroment and it worked perfectly.
Thanks to all for the comments.
Anabel