Actually, yeah. I forgot to include that they have SQL on a non-standard port. Sorry, I hurriedly sent the initial email.
Is there a way to specify the SQL port when configuring the source hierarchy? Thanks, Jeff Sent from my Windows Phone ________________________________ From: Andreas Hammarskjöld<mailto:[email protected]> Sent: 1/28/2015 5:29 PM To: [email protected]<mailto:[email protected]> Subject: RE: [mssms] CM07 - CM12 Migration Error Rings a bell... I would say it's the binding/port info, weird SQL port or TCP/IP net pipe issue with a non-default instance name? Can you connect with SQL Admin studio? //A From: [email protected] [mailto:[email protected]] On Behalf Of Jeff Poling Sent: den 28 januari 2015 23:57 To: [email protected] Subject: [mssms] CM07 - CM12 Migration Error 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
