I'm facing problem with nav 2016 installation. I've just installed new SQL Server and next I wanted to install NAV 2016 on that. The question is about Server Instance, I don't want NAV to install Sql 2014 express just use that server which I installed previously (2016). I'm leaving the Sql Server Instance field empty to use the default instance (MSSQLSERVER) but after pressing Apply I'm getting an error:
Can you guys help me somehow? I don't want to install 2014 because I'm facing some .NET 3.5 issues and I can't even install that; 2016 and the 4x framework works correctly.
1. Can you connect to your SQL server using SQL Server Management Studio?
2. What is your SQL Server port? Maybe, it's different from default?
1. Yes I can connect to Management Studio, I've checked Security logins, roles for both:
- my user (set to public/ sysadmin
- Authority System (set on public only)
Probably this is default once (1433)
Next step - is your NAV installation on the same PC where SQL installed? If not, have you checked the firewall rules?
Anyway can I install NAV without having the .NET (2 /3.5)? That's why I'm forcing that to use SQL 2016
Dynamics NAV, MS SQL Server, Wherescape RED;
PRINCE2 Practitioner - License GR657010572SG
GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03
I'm not sure about skipping .NET installation as it's prerequisite. Maybe, someone else who is more experienced in NAV installations can sey in more confidentally.
But as I see, NAV 2016 system requirements don't include SQL Server 2016 (https://msdn.microsoft.com/en-us/library/dd301054(v=nav.90).aspx#SQLReq) so, maybe, installation just doesn't recognize it.
No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
I tried your configuration when Microsoft launched SQL Server 2016 and I got the same error. It seems that NAV 2016 does not recognize SQL Server 2016 instance.
Notice that I did this test last year. I don't know if NAV 2016 supports SQL Server 2016 now!
then right-click your server and select restart, now try installing again and it should work