September 8, 2008 at 3:48 pm
Hi,
I wanted to run upgrade advisor on sql server 2005. We already upgraded to sql 2005 from sql server 2000, but kept our compatibility level to 80. Now I am trying to upgrade the compatibility upgrade, I wanted to run upgrade advisor on sql server 2005. I am getting following error:
Unable to connect to server. Reason: 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
May be the instance name wrong here I am not sure......
Any advice please...
Thank you,
VG
September 30, 2008 at 2:41 am
So, are remote connections allowed on the instance? You should check that in SQL Server Surface Area Configuration: under Database Engine/Remote Connections. If you're connecting remotely (e.g. through TCP/IP) you should enable the appropriate remote protocol.
ML
---
Matija Lah, SQL Server MVP
http://milambda.blogspot.com
September 30, 2008 at 10:02 am
I think you're getting the error because SQL Server 2005 Upgrade Advisor will only analyze SQL 7.0 and SQL 2000 instances. The compatibility level of the databases doesn't matter.
You can a new version i.e. SQL Server 2008 Upgrade Advisor http://www.microsoft.com/downloads/details.aspx?familyid=F5A6C5E9-4CD9-4E42-A21C-7291E7F0F852&displaylang=en and use it to analyze SQL 2005 instances.
Greg
October 3, 2008 at 10:02 am
Greg, Thanks for sending the link for upgrade advisor for sql server 2008. I am going to try that...
VG
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply