Hi,
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.
Mario Santos
Date
Votes
2 comments
-
Jet Reports Historic Posts Hello Mario,
When you are entering the SQL Server and Instance which syntax are you utilizing?
SERVER02/SODISHOES
or
SERVER02\SODISHOES
If you are using SERVER02/SODISHOES then you need to switch to SERVER02\SODISHOES which is the correct syntax.
You also may need to enable TCP/IP and Named Pipes for your instance in the SQL Server Configuration manager.
I have attached a screenshot for your reference.
Best regards,
MWilson
-
Jet Reports Historic Posts Hi MWilson,
Thanks a lot for your reply.
The server instance is correct. My mistake was when I wrote the post. Sorry.
I´m going to check the TCP and Named Pipes.
Thanks, one more time.
Best regards,
Mario Santos
Please sign in to leave a comment.