Home » Remote Investing Insights » Test Connection Failed in Ssis

Test Connection Failed in Ssis

Chloe Bennett • • 2 min read
Test Connection Failed in Ssis

I have access to server (SQL Server 2008R2) in database in MS, but I don't have it in SSIS. When I created Connection Manager (Native OLE DB), put server name and clicked "Test Connection", I gave:

TITLE: Connection Manager

Test connection failed because of an error in initializing provider. Login failed for user 'xxxxxxxxxxx'.

------------------------------ BUTTONS:

OK

I have access to other servers and databases in SSIS. What could cause the problem?

1
Chloe Bennett
Author

Chloe Bennett

Chloe Bennett explores the intersection of pop culture, streaming entertainment, digital trends, and contemporary lifestyle. Her weekly commentary reaches thousands of culture enthusiasts.