Skip to main content
Database Administrators

Return to Answer

deleted 7 characters in body
Source Link
Colin 't Hart
Colin 't Hart
  • 9.4k
  • 15
  • 36
  • 44

The error Failed to acquire connection "Local server connection". Connection may not be configured correctly or you may not have the right permissions on this connection. may be telling the truth.

Open the dtsx file in Notepad and check the DTS:ConnectionManager node for the correct connection string.

For me it turned out the connection string was wrong and was pointing at the wrong data source. I updated mine to LOCALHOST and that fixed my problem.

Hth

The error Failed to acquire connection "Local server connection". Connection may not be configured correctly or you may not have the right permissions on this connection. may be telling the truth.

Open the dtsx file in Notepad and check the DTS:ConnectionManager node for the correct connection string.

For me it turned out the connection string was wrong and was pointing at the wrong data source. I updated mine to LOCALHOST and that fixed my problem.

Hth

The error Failed to acquire connection "Local server connection". Connection may not be configured correctly or you may not have the right permissions on this connection. may be telling the truth.

Open the dtsx file in Notepad and check the DTS:ConnectionManager node for the correct connection string.

For me it turned out the connection string was wrong and was pointing at the wrong data source. I updated mine to LOCALHOST and that fixed my problem.

Source Link
Steady
Steady
  • 1

The error Failed to acquire connection "Local server connection". Connection may not be configured correctly or you may not have the right permissions on this connection. may be telling the truth.

Open the dtsx file in Notepad and check the DTS:ConnectionManager node for the correct connection string.

For me it turned out the connection string was wrong and was pointing at the wrong data source. I updated mine to LOCALHOST and that fixed my problem.

Hth