How to install and configure Microsoft Dynamics NAV 2009 R2

Chowdary · 2011-10-15

mohana_cse06 wrote:

Chowdary wrote:

Hi

I found this error when I scan Best Practice Analyzer:

The Best Practices Analyzer for Microsoft Dynamics NAV could not read the Microsoft Dynamics NAV Server configuration file (CustomSettings.config). This could be because the file is corrupted, missing, or misnamed. Check also 'Other Reports', for detailed descriptions. Filename = 'C:\Program Files (x86)\Microsoft Dynamics NAV\60\Service\CustomSettings.config' .

what should I do ?

Thanks
Chowdary

it clearly mentioned that your file is corrupted, missing, or misnamed..

make sure that name is same in path C:\Program Files (x86)\Microsoft Dynamics NAV\60\Service\CustomSettings.config

check the < and > inside the file..

It is not missing or misnamed. As well < and > are good
The only thing left(I guess) is corrupted. In that case is there any other chance to recover except uninstall and install ?

thanks
Chowdary

Chowdary · 2011-10-15

mohana_cse06 wrote:

Chowdary wrote:

Hi

I found this error when I scan Best Practice Analyzer:

The Best Practices Analyzer for Microsoft Dynamics NAV could not read the Microsoft Dynamics NAV Server configuration file (CustomSettings.config). This could be because the file is corrupted, missing, or misnamed. Check also 'Other Reports', for detailed descriptions. Filename = 'C:\Program Files (x86)\Microsoft Dynamics NAV\60\Service\CustomSettings.config' .

what should I do ?

Thanks
Chowdary

it clearly mentioned that your file is corrupted, missing, or misnamed..

make sure that name is same in path C:\Program Files (x86)\Microsoft Dynamics NAV\60\Service\CustomSettings.config

check the < and > inside the file..

You are great boss =D>
Finally my NAV Server started

(customsettings file had / symbol extra, took 1 hr to find it out)
what a relief

thanks a lot
Chowdary

mohana_cse06 · 2011-10-15

Chowdary wrote:

mohana_cse06 wrote:

Chowdary wrote:

Hi

I found this error when I scan Best Practice Analyzer:

The Best Practices Analyzer for Microsoft Dynamics NAV could not read the Microsoft Dynamics NAV Server configuration file (CustomSettings.config). This could be because the file is corrupted, missing, or misnamed. Check also 'Other Reports', for detailed descriptions. Filename = 'C:\Program Files (x86)\Microsoft Dynamics NAV\60\Service\CustomSettings.config' .

what should I do ?

Thanks
Chowdary

it clearly mentioned that your file is corrupted, missing, or misnamed..

make sure that name is same in path C:\Program Files (x86)\Microsoft Dynamics NAV\60\Service\CustomSettings.config

check the < and > inside the file..

You are great boss =D>
Finally my NAV Server started
(customsettings file had / symbol extra, took 1 hr to find it out)
what a relief

thanks a lot
Chowdary

Welcome

Chowdary · 2011-10-15

Hi Mohana

One more help !
Hope don't mind

I couldn't connect to RTC. I have checked forums but didn't get answer :thumbsdown:
when I run best practice I got this info:

The Best Practices Analyzer for Microsoft Dynamics NAV 2009 tries to connect to SQL Server using the DatabaseServer, DatabaseName, ServerInstance, and ServerPort parameters that are specified in the CustomSettings.config file, which is the Microsoft Dynamics NAV Server configuration file. If it cannot connect using these parameters, then it reports an issue and provides information about which parameter was invalid.

To correct this issue
Check the values in the CustomSettings.config file. Also check firewall setting on the computer running SQL Server and verify that SQL Server is listening for remote connections using TCP/IP.

can you give me the correct Server Address syntax to connect to RTC (i.e., Server Address syntax. i got this screen after error message:
the program could not create a connection to the server. Do you want to try again?)

Plz help [-o<

Thanks
Chowdary

mohana_cse06 · 2011-10-15

Can you show your Customsettings file..

also check firewalls in server..

Chowdary · 2011-10-17

mohana_cse06 wrote:

Can you show your Customsettings file..

also check firewalls in server..

Hi Mohana

please see my customsettings file

<appSettings>

<add key="NetType" value="Default"></add>

<add key="DatabaseServer" value="NAVSERV2"></add>

<add key="DatabaseInstance" value="NAVSERV2"></add>

<add key="DatabaseName" value="RTCTest"></add>

<add key="ServerInstance" value="DynamicsNAV"></add>

<add key="ServerPort" value="7046"></add>

<add key="WebServicePort" value="7047"></add>

<add key="WebServiceSSLEnabled" value="false"></add>

<add key="WebServicesMaxMsgSize" value="512"></add>

<add key="WebServicesUseNTLMAuthentication" value="false"></add>

<add key="WebServicesDefaultTimeZone" value="Arabian Standard Time"></add>

<add key="OperationTimeout" value="MaxValue"></add>

<add key="ProtectionLevel" value="EncryptAndSign"></add>

<add key="MaxConcurrentCalls" value="40"></add>

<add key="MaxConcurrentConnections" value="150"></add>

<add key="ClientReconnectPeriod" value="00:10:00"></add>

<add key="MaxNumberOfOrphanedConnections" value="20"></add>

<add key="CompressionThreshold" value="64"></add>

<add key="MetadataProviderCacheSize" value="150"></add>

<add key="MaxUploadSize" value="5"></add>

<add key="EnableDebugging" value="false"></add>

<add key="MaxItemsInObjectGraph" value="128"></add>

<add key="ChunkSize" value="28"></add>

<add key="ClientCredentialType" value="Windows"></add>

<add key="CertificateThumbprint" value=""></add>
</appSettings>

and my Firewall on the server computer is turned off !

plz guide me further

Thanks
Chowdary

mohana_cse06 · 2011-10-17

Set "DatabaseInstance" to blank ("") and try

<add key="DatabaseInstance" value=""></add>

Chowdary · 2011-10-17

still the same error with best practice analyzer:

Could not connect to 'RTCTest' database on database server 'NAVSERV2'. Verify that this database server is running and that you have network access to the database. Check the firewall on the database server.

and I tried to run RTC also, its giving the same message:
the program could not create connection to the server. Do you want to try again?

and then asking for Change connection:
Server Address:__________

Thanks
Chowdary

mohana_cse06 · 2011-10-17

Chowdary wrote:

Could not connect to 'RTCTest' database on database server 'NAVSERV2'. Verify that this database server is running and that you have network access to the database. Check the firewall on the database server.

Server Address:__________

Is your service running?

Are you sure your server name is NAVSERV2 (SQL and NAV Service installed on same system?)
Drill down on server address and What is the value there?

Chowdary · 2011-10-17

Is your service running?

Yes, both SQL Server and NAV Server running
I can see then on the task manager like:
Microsoft.Dynamics.Nav.Server.exe*32
sqlservr.exe.*32

Are you sure your server name is NAVSERV2 (SQL and NAV Service installed on same system?)
I can server name in the properties of the server in management studio like:
Server:
NAVSERV2\SQLEXPRESS
in the name property also: NAVSERV2\SQLEXPRESS

Drill down on server address and What is the value there?
when I drilldown its blank, I tried to enter like:
NAVSERV2:7046/DynamicsNav (not working)
localhost:7046/DynamicsNav (not working)

Also, I can see some info on Informational Items tab of Best Practice Analyzer:

Delegation should work correctly.
A Microsoft Dynamics NAV database is installed on the server computer.

Thanks
Chowdary

mohana_cse06 · 2011-10-17

Did you try by setting

<add key="DatabaseServer" value="NAVSERV2\SQLEXPRESS"></add>

And check this link for Delegation
http://msdn.microsoft.com/en-us/library/dd568720.aspx

Chowdary · 2011-10-17

when I'm trying this commend:

telnet 172.16.107.101 1433
am getting error:
could not open connection to the host, on port 1433: Connect failed

Thanks
Chowdary

Chowdary · 2011-10-17

mohana_cse06 wrote:

Did you try by setting

<add key="DatabaseServer" value="NAVSERV2\SQLEXPRESS"></add>

yes, I did check this too, but no luck ](*,)

I guess there is problem wid 1433 port, its not connecting as I said in previous post.

Is there anyway to resolve this issue?

Thanks
Chowadry

kine · 2011-10-17

Check that TCP/IP protocol is enabled inthe SQL server configuration. Express editions are not accessible from outside by default.

Chowdary · 2011-10-17

kine wrote:

Check that TCP/IP protocol is enabled inthe SQL server configuration. Express editions are not accessible from outside by default.

Hi Kine thanks for the response

yes, TCP/IP port on the following path:
SQL Native client 10.0 Configuration (32bit) -> client protocols is enabled

but, TCP/IP port on the following path:
SQL Server network configuration (32bit) -> Protocols for SQLEXPRESS is disabled

I have checked by enabling

SQL Server network configuration (32bit) -> Protocols for SQLEXPRESS is disabled

but same result.

I have checked forums and found
telnet 172.16.107.101 1433
giving me :
could not open connection to the host, on port 1433: connect failed

I was checking on google, mibuso, .....
no luck

Thanks
Chowdary

kine · 2011-10-17

And another one from my memory: If I remmember correctly, to be able to connect to named instance on default port, SQL Browser service must be running...

Chowdary · 2011-10-17

kine wrote:

And another one from my memory: If I remmember correctly, to be able to connect to named instance on default port, SQL Browser service must be running...

ohh !

This SQL Browser was disabled, may be this is causing issue here.
But I don't have option to start or enabled as all tasks grayed(disabled).
In the properties its showing log on as :
This Account - Local Service.

Thanks
Chowdary

Chowdary · 2011-10-18

mohana_cse06 wrote:

Did you try by setting

<add key="DatabaseServer" value="NAVSERV2\SQLEXPRESS"></add>

And check this link for Delegation
http://msdn.microsoft.com/en-us/library/dd568720.aspx

Hi,

I finally decided to setup delegation, and try my luck.

Thanks
Chowdary

Chowdary · 2011-10-18

Hi

Can anyone help me to correct setspn syntax:

setspn -A DynamicsNAV/NAVSERV2:7046 administrator

plz correct me. I'm struck here
getting error: Unable to locate account

Thanks
Chowdary

mohana_cse06 · 2011-10-18

syntax is
setspn -A InstanceName/FullyQualifiedDomainNameOfServer:Port Domain \User

FullyQualifiedDomainNameOfServer it should include your system domain also..

Ex : setspn -A MSSQLSvc/myhost.redmond.microsoft.com:1433 accountname

Chowdary · 2011-10-19

postsaurav wrote:

[ReplaceWithNAVServerAccount]

Hi

My NAV Server running under local system account, what should I replace here ?

Thanks
Chowdary

kine · 2011-10-19

If it is local system account, I am not sure, but I am afraid that it will not have access to the network. If it is network service account, you need to use the server account, it means something like domain\servername$ instead.

Chowdary · 2011-10-20

kine wrote:

domain\servername$

Hi Kine

I'm using Network Service Account, now,

I found domain name as: NAVSERV2 (when I'm longing into server computer)
servername means computer name? or any other?

thanks
Chowdary

mohana_cse06 · 2011-10-20

Computer name only

Chowdary · 2011-10-20

mohana_cse06 wrote:

Computer name only

Hi Mohana

I tried this command

USE MASTER
CREATE LOGIN [NAVSERV2\NAVSERV2$] FROM WINDOWS;
GO

on server computer's SSMS, getting error

Msg 15401, Level 16, State 1, Line 2
Windows NT user or group 'NAVSERV2\NAVSERV2$' not found. Check the name again.

correct syntax plz

my main objective is to start RTC from my system, its fine with server !
http://msdn.microsoft.com/en-us/library/dd568739.aspx

Thanks
Chowdary

mohana_cse06 · 2011-10-20

Are you sure your domain name also NAVSERV2?

Right click on MyComputer and properties and check in Computer name tab..

Chowdary · 2011-10-20

mohana_cse06 wrote:

Are you sure your domain name also NAVSERV2?

Right click on MyComputer and properties and check in Computer name tab..

for my server its NAVSERV2 ( I checked when I'm connecting to server)
my desktop its cinf.mu (from here I am trying to connect to RTC)

but if I checked on the server computer (win server 2008 ) I didn't see domain
rather I can see wrokgroup over there, its workgroup only

Thanks
Chowdary

mohana_cse06 · 2011-10-20

Chowdary wrote:

but if I checked on the server computer (win server 2008 ) I didn't see domain
rather I can see wrokgroup over there, its workgroup only

may be this is the problem..

bring the server to domain and try..

Chowdary · 2011-10-20

mohana_cse06 wrote:

Chowdary wrote:

but if I checked on the server computer (win server 2008 ) I didn't see domain
rather I can see wrokgroup over there, its workgroup only

bring the server to domain and try..

Hi Moahana

can you help how to do this ? (plz

)
I didn't get help from forums and from my IT guy also ](*,)

thanks
Chwodary

mohana_cse06 · 2011-10-20

Chowdary wrote:

can you help how to do this ? (plz )
I didn't get help from forums and from my IT guy also ](*,)

This is completely an IT support issue..

How to install and configure Microsoft Dynamics NAV 2009 R2

Comments

Categories