SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Server 2012 Upgrade Advisor: The network path was not found


SQL Server 2012 Upgrade Advisor: The network path was not found

Author
Message
shew
shew
SSC Eights!
SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)

Group: General Forum Members
Points: 853 Visits: 950
We installed the SQL Server 2012 GUI tools, including "Upgrade Advisor," on a new virtual machine. We can connect to the old SQL Server 2008 R2 clustered databases just fine over port 1433 using SQL Server Management Studio 2012, but Upgrade Advisor is a mixed bag. Here are the steps we are taking:

- Click on "Start," "All Programs," "Microsoft SQL Server 2012," "SQL Server 2012 Upgrade Advisor"

- Fill in the server name with a valid SQL Server Network Name

- Select "SQL Server" as the only component to be analyzed

- Fill in the instance name with a valid named instance

- Use Windows Authentication (the default)

- The "SQL Server Parameters" window displays valid database names, meaning that we have a successful connection to the desired SQL Server instance at this point

- Leave all of the databased selected (the default)

- Click the "Run" button

- The "Upgrade Advisor Progress" window spins for a while and eventually generates the following error:


TITLE: mscorlib
------------------------------

The network path was not found.


------------------------------
BUTTONS:

OK
------------------------------


Why would Upgrade Advisor be able to display the database names after making a successful connection only to fail later saying that it cannot find the network path?

I have seen Google references that mentioned the creation of an alias as a work around, but I have not found the right permutation. (For example, http://social.msdn.microsoft.com/Forums/sqlserver/en-US/f6d1d9d4-c07f-460f-a8f4-c6f66839578a/sql-2012-upgrade-advisor-the-network-path-was-not-found .)

I opened a support call with Microsoft, and I was told flatly that Upgrade Advisor is *NOT A SUPPORTED PRODUCT*. Go figure... Yeah, I am disappointed in the response, but it's not worthwhile to chase Microsoft on this one.

Does anyone have any ideas?



shew
shew
SSC Eights!
SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)

Group: General Forum Members
Points: 853 Visits: 950
I tried using SQL Server Configuration Manager to define an alias with the same name as the SQL Server Network Name, pointing to the clustered instance's IP address, but that does not work. I also tried defining an alias with the same name as the SQL Server Network Name, pointing to the SQL Server Network Name itself, but that does not work.



shew
shew
SSC Eights!
SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)

Group: General Forum Members
Points: 853 Visits: 950
I'm still looking for an answer. Any ideas?

Thanks in advance.



Zalim Murga
Zalim Murga
Grasshopper
Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)

Group: General Forum Members
Points: 22 Visits: 345
I am getting the exact same issue.
Can we get some help please
shew
shew
SSC Eights!
SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)SSC Eights! (853 reputation)

Group: General Forum Members
Points: 853 Visits: 950
We never go it to work. We opened a call with Microsoft, and, to my dismay, Microsoft told me that this is unsupported software. Way to listen to your customers, Microsoft. Sigh...



Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search