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...
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:
Must Read
OK
I have access to other servers and databases in SSIS. What could cause the problem?