How to install and configure Microsoft Dynamics NAV 2009 R2

Chowdary

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

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

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

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

Can you show your Customsettings file..

also check firewalls in server..

Chowdary

mohana_cse06 wrote:

Can you show your Customsettings file..

also check firewalls in server..

Hi Mohana

please see my customsettings file

<appSettings>
<!--
The network protocol used to access the database.
Valid options: Default, NamedPipes, Sockets
-->
<add key="NetType" value="Default"></add>
<!--
Name of the database server to connect to.
-->
<add key="DatabaseServer" value="NAVSERV2"></add>
<!--
Name of the database instance to connect to.
-->
<add key="DatabaseInstance" value="NAVSERV2"></add>
<!--
Name of the database to connect to.
-->
<add key="DatabaseName" value="RTCTest"></add>
<!--
Name of the Microsoft Dynamics NAV Server instance to connect
to (for client) or listen on (for server).
-->
<add key="ServerInstance" value="DynamicsNAV"></add>
<!--
The listening TCP port for the Microsoft Dynamics NAV Server.
This is part of the server's URL.
Valid range: 1-65535
-->
<add key="ServerPort" value="7046"></add>
<!--
The listening HTTP port for the Microsoft Dynamics NAV
Business Web Services.
This is part of the web service's URL.
Valid range: 1-65535
-->
<add key="WebServicePort" value="7047"></add>
<!--
Turns on or off the https for Web Services
-->
<add key="WebServiceSSLEnabled" value="false"></add>
<!--
Maximum permitted size of a Web Services request, in kilobytes
-->
<add key="WebServicesMaxMsgSize" value="512"></add>
<!--
Turns on or off NTLM authentication protocol for Web Services
false: Use SPNEGO (recommended)
true: Use NTLM only
-->
<add key="WebServicesUseNTLMAuthentication" value="false"></add>
<!--
The default time zone in which web service calls are run.
Supported values "UTC" (the default), "Server Time Zone"
(the time zone of the server), or the ID of a Windows
time zone defined in the system registry under
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows NT\CurrentVersion\Time Zones,
for example "Romance Standard Time"
-->
<add key="WebServicesDefaultTimeZone" value="Arabian Standard Time"></add>
<!--
Maximum time in seconds a call from the client to the server
may take to return.
Time span format: [dd.]hh:mm:ss[.ff]
dd: days
hh: hours
mm: minutes
ss: seconds
ff: fractions of a second
Or "MaxValue" to indicate there is no timeout.
-->
<add key="OperationTimeout" value="MaxValue"></add>
<!--
The security services used to protect the client/server data stream.
Valid options: EncryptAndSign, Sign, None
-->
<add key="ProtectionLevel" value="EncryptAndSign"></add>
<!--
Maximum number of concurrent client calls that can be active on the
Microsoft Dynamics NAV Server. To disable this setting set the value
to "MaxValue".
-->
<add key="MaxConcurrentCalls" value="40"></add>
<!--
The maximum number of concurrent client connection that the service
will accept. To disable this setting set the value to "MaxValue".
-->
<add key="MaxConcurrentConnections" value="150"></add>
<!--
Sets the grace period within which the client can reconnect to a
running session.
Time span format: [dd.]hh:mm:ss[.ff]
dd: days
hh: hours
mm: minutes
ss: seconds
ff: fractions of a second
Or "MaxValue" to indicate there is no timeout.
-->
<add key="ClientReconnectPeriod" value="00:10:00"></add>
<!--
Sets the maximum number of orphaned connections to be kept alive
simultaneouly for a maximum time specified by the
ClientReconnectPeriod setting. A connection becomes an orphan when
the client becomes involuntarily disconnected from the server.
-->
<add key="MaxNumberOfOrphanedConnections" value="20"></add>
<!--
Threshold for when to start compressing data sets to avoid that they
consume prohibitive amounts of memory.
-->
<add key="CompressionThreshold" value="64"></add>
<!--
Sets the Metadata Provider cache size (in number in objects cached).
Set to 0 to disable cache.
-->
<add key="MetadataProviderCacheSize" value="150"></add>
<!--
Limits the size of files that can be uploaded in order to avoid out of memory errors. This value is in megabytes.
-->
<add key="MaxUploadSize" value="5"></add>
<!--
With the EnableDebugging flag set to true the Microsoft Dynamics NAV Server
will start with debugging mode enabled. This mode has three main functions:
1) Upon first connection by a RoleTailored Client all C# for that application
will be generated.
2) C# files will be persisted between server restarts.
3) Application Objects will be compiled with debug information.
-->
<add key="EnableDebugging" value="false"></add>
<!--
Sets the maximum number of items to serialize or deserialize, in KB
-->
<add key="MaxItemsInObjectGraph" value="128"></add>
<!--
Sets the default size of a chunk, in KB. Should be a value between 4 and 80.
-->
<add key="ChunkSize" value="28"></add>
<!--
The type of client credential used for authentication. (Values are Windows/UserName)
-->
<add key="ClientCredentialType" value="Windows"></add>
<!--
The CertificateThumbprint, for the x509 certificate that is going to be used for authentication
-->
<add key="CertificateThumbprint" value=""></add>
</appSettings>

and my Firewall on the server computer is turned off !

plz guide me further

Thanks
Chowdary

mohana_cse06

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

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

Chowdary

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

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

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

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

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

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

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

Chowdary

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

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

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

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

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

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

postsaurav wrote:

[ReplaceWithNAVServerAccount]

Hi

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

Thanks
Chowdary

kine

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

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

Computer name only

Chowdary

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

Are you sure your domain name also NAVSERV2?

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

Chowdary

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

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

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

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..