I’m trying to connect to my customer database via JET Essentials 2015 Update 1.
In the Data source I’m using:Dynamics NAV 2013 or later (Connection Type)
Direct SQL Server (Connection Method)
In the authentication Tab I selected: Windows authentication (current user) for both authentications.
On the Connection tab I wrote the server with the instance.
When I write only the server (SERVER02) I can see all the databases.
When I write the server with the instance where the NAV database is installed (SERVER02/SODISHOES) I can’t see no databases, and the Teste Connection gives me the message:
“A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)”
I have the “allow remote connection on this server” enabled on SQL SERVER.
It seems that the JET can't reach the instance.
Can anyone give some tip on this matter?
Thanks in advance.
Connection SQL NAV database instance issues