unable to connect to server with classic client 2009 R2

aldarion

hello,
On a pc when I try to connect to my DB with the classic client SQL it does not find the server (the xxx server cannot be found. try...)
with the RTC it works fine
When I am on the server it works
Navision server is 2009 R2, SQL server 2008 R2, OS server windows 2008 R2 standard, PC XP SP3.
any indication are welcome
thanks in advance

mohana_cse06

Did you try with IP address?

Sog

You do connect to the sql-instance instead of the nav service?
look in your CustomSettings.config for the instance: <add key="DatabaseServer" value="CopyThisValue"></add>.

mohana_cse06

Sog wrote:

You do connect to the sql-instance instead of the nav service?
look in your CustomSettings.config for the instance: <add key="DatabaseServer" value="CopyThisValue"></add>.

why do we require Custom Settings file for Classic?

Sog

Not at all, but there he'll find the value of the sql server.
And he did mention that the RTC works fine

mohana_cse06

Sog wrote:

not at all, but there he'll find the value of the sql server.

ahh..right..

@aldarion, is your SQL Server and NAV Service Installed in one system?

aldarion

yes with ip address and with server name and SQL and Navision server are on the same system.
However as Sog says the server name is different from the CustomSettings. Sadly I try to connect with that server name but I cannot see any Database.
In fact, my question come because when printing a report on RTC it launch the classic client (when not done with the new layout) and there it cannot connect to the server.
is it possible that the server install is not correctly done?
thank you in advance.

mohana_cse06

I have faced similar problem recently by adding the IP address and server name in Host file the problem resolved.

aldarion

hello,
the problem was the firewall that blocked the sql port for classic navision.
thank you all for your answer

Prajeesh_Nair

Hi All ,

I have a similar problem with the Classic connection with the server(Nav 2009 R2).
I have two Sql 2005 and SQL express 2008 r2 installed in the server.
Both has Demo DB in it.
The sql 2005 was created during the demo installation. After that i have installed Sql 2008 and created a DB in 2008 and restored the Chronus backup.
I am able to connect to both DB's(Sql2005 &2008) from the server(Classic & RTC).
I have created an instance for the sql 2008 in the server.
I am able to connect to the Sql 2005 DB both classic and RTC from a client machine.
I not able to connect to Sql 2008 DB (Server not found). But i am able to connect through RTC using the instance i have created.
I have turned of the Firewall still the issue is existing.
Please let me know a Walkthrough the issue i am facing :-k .