I posted this to the TechNet forum as well, but I thought I would see if anyone
on this list has encountered this. . .
When setting up the migration job, the initial data gathering returns an error
related to finding the SQL instance:
ERROR: [MigrationManager]:
Microsoft.ConfigurationManagement.Migration.MigrationException: Error occurred
when trying to make sql connection to SERVER. Contact product support for help.
Error Information -2146232060, A network-related or instance-specific error
occurred while establishing a connection to SQL Server. The server was not
found or was not accessible. Verify that the instance name is correct and that
SQL Server is configured to allow remote connections. (provider: SQL Network
Interfaces, error: 26 - Error Locating Server/Instance Specified)
The ConfigMgr 2007 database is hosted remotely on an SQL Server cluster. The
DBA configured the migration account to have both read and execute permissions
on the COnfigMgr 2007 database.
The 2007 environment uses a remote SQL cluster to host the database. I worked
with the DBA to assign read and execute permissions on the 2007 database for
the account I am using to migrate the data. Even after the permission changes,
we still get the error.
Has anyone experienced this or have any suggestions?
Thanks,
Jeff
