1,307
Hi All,
I got the below error while clicking test data connection in NAV upgrade step 2.
(Upgradation from NAV 2009 SP1 to NAV 2013 R2).
SQL server is in same machine only.
Microsoft Dynamics NAV
---------------------------
A call to System.Data.SqlClient.SqlConnection.Open failed with this message: The network path was not found
---------------------------
OK
---------------------------
Regards,
Sathish
*This post is locked for comments
Hi Satish,
Great to hear that you were able to resolve the issue.
Thanks for the update this will help someone in future.
Please mark the Forum Question as resolved.
Hi Saurav,
Thanks for the reply and ur suggestions.
I find out what is the issue.
Server name contains Underscore '_'.
They written a coding in Status log table in Server Name - OnValidate() :
"SQL Server Name" := UPPERCASE(DELCHR("SQL Server Name",'=',' ,~:!@#$%^&(){}_'));
In the above code they have removed the special characters if any.
Hey Satish,
When you start the step 2 of data migration upgrade. You get a window where you Test the connection.
** Conman Issues-
> Either the SQL Server and NST are on different machine then Step 2 of Upgrade shows NST Name in SQL Server Name. [NOT YOUR CASE]
> Or your database is on a SQL Named instance like NAVDemo, but your step 2 window shows only SQL name not the instance Name.
In that window check the information related to SQL Server is correct or not.
It seems either you are using a instance in SQL Server and your Upgrade step 2 Shows only server name not the instance name in the window.
In the field "SQL Server Name" you have to type <Hostname>\<NameOfSqlServerInstace>
Correct that and it should be working fine.
Let us know how it goes.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,269
Super User 2024 Season 2
#2
Martin Dráb
230,198
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (