Article ID: 908454 - View products that this article applies to.
BUG #: 408226 (SQLBUDT)
When you try to upgrade a named instance of Microsoft SQL Server 2000 to Microsoft SQL Server 2005 on a computer that is running the 64-bit version of the Intel Itanium-based operating system, you may receive the following error message:
This problem occurs if all the following conditions are true on the computer:
UpgradeAdvisor returned -1 .
Error message:An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections.
(provider: Shared Memory Provider, error: 36 - The Shared Memory dll used to connect to SQL Server 2000 was not found) .
Net SqlClient Data Provider at Microsoft.SqlServer.BestPracticesAnalyzer.Upgrade.BPAUAAnalyzer.
ValidateSQL() at Microsoft.SqlServer.BestPracticesAnalyzer.Upgrade.BPAUAAnalyzer.
ValidateParameters() at Microsoft.SqlServer.BestPracticesAnalyzer.Upgrade.BPAUAAnalyzer.
Execute() at Microsoft.SqlServer.UpgradeAdvisor.AnalyzerEngine.RunAnalyzer(Object analyzerInfo)
This problem occurs because the SQL Server 2005 Upgrade Advisor cannot connect to the named instance of SQL Server 2000.
The SQL Server 2005 Upgrade Advisor uses information that the SQL Server Browser service returns when the SQL Server 2005 Upgrade Advisor tries to connect to an instance of SQL Server 2000. However, the SQL Server Browser service cannot return the correct information about the connection request. Therefore, the connection fails.
To work around this problem, use one of the following methods:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
The third-party products that this article discusses are manufactured by companies that are independent of Microsoft. Microsoft makes no warranty, implied or otherwise, regarding the performance or reliability of these products.