NAV 2013 R2 - Install database components in a SQL Cluster

Comments

• Options

  vremeni4 Member Posts: 323

  2014-12-11

  Hi,
  
  Good thing about NAV 2013 R2 is that you do not need to install Database components.
  During installation of Database components, I think ,only the backup is restored on the SQL Server, that is all.
  In previous versions e.g. NAV 2009 it was necessary to create Extended procedures, to set up Trace-flag and so on, so installing database components was useful. In NAV 2013 R2 you can skip that.
  
  On the installation DVD for NAV 2013 R2 go to
  ..\NAV 2013 R2 W1 Install\SQLDemoDatabase\CommonAppData\Microsoft\Microsoft Dynamics NAV\71\Database
  In this folder you will find the backup "Demo Database NAV (7-1).bak" of the Demo database.
  Restore this backup on you SQL cluster and you are ready to go.
  
  After that change the configuration file of the NAV Server to point to this database and add the user which is used to run NAV Server on the SQL machine as a DB_owner for the database.
  
  I hope this helps.
  Thanks.

  0
• Options

  hafedh Member Posts: 12

  2014-12-11

  Hello Vremeni4
  
  thanks a lot for your response,
  this is a great idea, i will check this solution and i will send you a feedback tomorrow if it's ok or no.
  
  Best regards,
  Guiga Hafedh

  0
• Options

  hafedh Member Posts: 12

  2015-01-12

  Hello and i sorry to be late in response,
  I have correctly installed a cluster SQL and mout the demo database like you said.
  I don't install the NAV SQL Component and i have installed the NAV Server component with the IP of cluster SQL.
  It's ok at this point, but when i open the client i have different error message like:
  
  "The Microsoft Dynamics NAV server is currently not ready to serve requests. Try again later or contact your system administrator."
  "the microsoft dynamics nav server is currently not ready to serve requests"
  
  I already cheked the privilege in SQL as shown in this image:
  http://www.casimages.com/i/150112030659423905.png
  
  
  Best regards
  Guiga Hafedh

  0
• Options

  vremeni4 Member Posts: 323

  2015-01-13

  Hi,
  
  This error message usually means that the settings for the NAV Server Service to which SQL Server needs to connect are wrong.
  By Default "Database Instance" is set to NAVDEMO and "Database Server" to localhost.
  Check in the configurantion file for NAV Server Service whether you have correct values here.
  
  I hope this helps.
  Thanks.

  0
• Options

  hafedh Member Posts: 12

  2015-01-14

  Thanks for your response,
  I will check the settings of Nav Server Service.
  if not, would it be possible to screen sharing my to help me solve this problem?
  
  Best regards
  Guiga Hafedh

  0
• Options

  hafedh Member Posts: 12

  2015-01-15

  Hello vremeni4,
  Really, thanks a lot for your assistance and your help,
  I finally have installed the cluster SQL and configure the NAV Server correctly.
  
  About the last error: I have deleted the old database and restore a new databse from the install folder and all works fine
  
  Thanksssss
  
  Best regards
  Guiga Hafedh

  0