Nav 2016 - Installation problem (SQL Server instance exists but....)

Kermii

Hello,

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.

logger

Hi @Kermii ,
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?

Kermii

@logger thanks for your response

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)

2.
Probably this is default once (1433)

logger

@Kermii ,
Next step - is your NAV installation on the same PC where SQL installed? If not, have you checked the firewall rules?

Kermii

@logger I made some changes in firewall/ restart the system and finally I was able to start installation but I don't know why NAV was still installing sql 2014 - few errors has appeared, mainly about .NET framework 3.5 /2.0 - which is not installed on my machine and it cannot be (having the 4x version).... SQL Server Instance name field was empty (default was connected to SQL 2016)....arrrr...

Anyway can I install NAV without having the .NET (2 /3.5)? That's why I'm forcing that to use SQL 2016

Slawek_Guzek

Untick the demo database in your setup, and create it manully by restoring backup which can be found on installation DVD

logger

@Kermii ,
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.

Kermii

I will try to install .NET first, let see. I will give you info about the progress, thank you guys!

kriki

[Topic moved from 'NAV/Navision Classic Client' forum to 'NAV Three Tier' forum]

NavNab

@Kermii

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!

RocheT

In case someone encountered this again, just search for SQL Server Configuration Manager then enable the TCP/IP


then right-click your server and select restart, now try installing again and it should work