How to install and configure Microsoft Dynamics NAV 2009 R2

2

Comments

  • ChowdaryChowdary Member Posts: 148
    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
    Pleasure in the job puts perfection in the work
  • ChowdaryChowdary Member Posts: 148
    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 :D
    (customsettings file had / symbol extra, took 1 hr to find it out)
    what a relief :D

    thanks a lot
    Chowdary
    Pleasure in the job puts perfection in the work
  • mohana_cse06mohana_cse06 Member Posts: 5,503
    Chowdary 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 :D
    (customsettings file had / symbol extra, took 1 hr to find it out)
    what a relief :D

    thanks a lot
    Chowdary

    Welcome :D
  • ChowdaryChowdary Member Posts: 148
    edited 2011-10-17
    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
    Pleasure in the job puts perfection in the work
  • mohana_cse06mohana_cse06 Member Posts: 5,503
    Can you show your Customsettings file..

    also check firewalls in server..
  • ChowdaryChowdary Member Posts: 148
    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
    Pleasure in the job puts perfection in the work
  • mohana_cse06mohana_cse06 Member Posts: 5,503
    Set "DatabaseInstance" to blank ("") and try
    <add key="DatabaseInstance" value=""></add>
  • ChowdaryChowdary Member Posts: 148
    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
    Pleasure in the job puts perfection in the work
  • mohana_cse06mohana_cse06 Member Posts: 5,503
    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?
  • ChowdaryChowdary Member Posts: 148
    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
    Pleasure in the job puts perfection in the work
  • mohana_cse06mohana_cse06 Member Posts: 5,503
    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
  • ChowdaryChowdary Member Posts: 148
    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
    Pleasure in the job puts perfection in the work
  • ChowdaryChowdary Member Posts: 148
    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
    Pleasure in the job puts perfection in the work
  • kinekine Member Posts: 12,562
    Check that TCP/IP protocol is enabled inthe SQL server configuration. Express editions are not accessible from outside by default.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • ChowdaryChowdary Member Posts: 148
    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
    Pleasure in the job puts perfection in the work
  • kinekine Member Posts: 12,562
    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...
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • ChowdaryChowdary Member Posts: 148
    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
    Pleasure in the job puts perfection in the work
  • ChowdaryChowdary Member Posts: 148
    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
    Pleasure in the job puts perfection in the work
  • ChowdaryChowdary Member Posts: 148
    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
    Pleasure in the job puts perfection in the work
  • mohana_cse06mohana_cse06 Member Posts: 5,503
    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
  • ChowdaryChowdary Member Posts: 148
    postsaurav wrote:
    [ReplaceWithNAVServerAccount]

    Hi

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

    Thanks
    Chowdary
    Pleasure in the job puts perfection in the work
  • kinekine Member Posts: 12,562
    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.
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • ChowdaryChowdary Member Posts: 148
    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
    Pleasure in the job puts perfection in the work
  • ChowdaryChowdary Member Posts: 148
    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
    Pleasure in the job puts perfection in the work
  • mohana_cse06mohana_cse06 Member Posts: 5,503
    Are you sure your domain name also NAVSERV2?

    Right click on MyComputer and properties and check in Computer name tab..
  • ChowdaryChowdary Member Posts: 148
    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
    Pleasure in the job puts perfection in the work
  • mohana_cse06mohana_cse06 Member Posts: 5,503
    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..
  • ChowdaryChowdary Member Posts: 148
    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
    Pleasure in the job puts perfection in the work
  • mohana_cse06mohana_cse06 Member Posts: 5,503
    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..
Sign In or Register to comment.