JeremyE (10/21/2010)

---

Was the Windows server renamed prior to changing the SQL server name?

Can you connect to the server remotely from SSMS?

What network protocols are enabled for SQL server?

Have you tried...

Yep, restarted the service and when that didn't seem to help decided to reboot the entire server for good measure. No change for the "localhost" issue.

Thanks for your response. If I try and change it to "local" even doing a Test Connection fails. We are trying to avoid putting the servername in the SSIS packages...

And if I run the SSIS Package we get the following error.

[OLE DB Destination [676]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager...

Everything is being run under the SA user. The test environment uses the same user account as the production environment and its all on the same server. The SA user...