Window Server 2008 & SQL server 2008

Did you know that when you add a new Active directory user as a  Windows Login in Dynamics NAV 2009 SP1 in an environment where Windows server 2008  and SQL server 2008 are installed , the new user is automatically created in SQL server Login? This means that we do not have the issue of manually creating SQL login  for Active directory (AD) users. All that is required appears to be logging  into Dynamics NAV as a Super user and then adding a new AD user to Windows Login and synchronise permissions.

Note: I used Windows server 2008 Enterprise and SQL server 2008 – latest service pack installed on the same box in my test.

SQL Attachments – Access to object tracking table denied

The Classic client allows attaching a SQL Server database from an .mdf file. When a database is attached this way, permissions to the object tracking table are not set correctly. The user under which the Microsoft Dynamics NAV Server service is executed needs permissions to this table. The service stops responding when you try to start the RoleTailored client, and the event log reports that access to the object tracking table was denied.

Resolution – Workaround

  1. Stop the Microsoft Dynamics NAV Server service.
  2. Stop the SQL Server service.
  3. Open a command prompt.
  4. At the command prompt, type the following command:
    Sqlcmd -d “Demo Database NAV (6-0)” -q “GRANT SELECT ON [dbo].[Object Tracking] TO [NT AUTHORITY\NETWORK SERVICE]”
  5. Start the SQL Server service.
  6. Start the Microsoft Dynamics NAV Server service.

Firewall: Microsoft SQL Server 2008

When attempting to connect to SQL server database using Dynamics NAV SQL client, you may recieve the following message:

The Server cannot be found. Try again later or contact your system administrator.

System Environment:

Server: Windows Server 2008 (any edition)

SQL Server: Microsoft SQL Server 2008 (any edition)

Dynamics NAV: 2009 SP1

A solution on how to open the firwall port can be obtained fromthe following  Microsoft Knowledge base article:

http://support.microsoft.com/kb/968872

Hope you find this helpful

Error: Installing Database Component

When installing NAV 2009 database component on window server 2008 that has SQL server 2008 installed, the following error may occur:

Failed to connect to SQL database (-2147467259 master)

This error is typically triggered because when the local database was installed and then subsequently uninstalled, the SQL Server not available during the uninstallation. It is possible that SQL server was either uninstalled or was not running during the uninstallation.

This issue can be resolved by performing one of the following tasks:

1. Run the following command:

msiexec /x {B4222DEE-71BD-11DC-8BA7-C1C855D89593} SKIPUNINSTALLSQLDATA=1

2.  Install/start SQL Server and manually drop MantisSQLDB or MantisSQLDBEval database after

the uninstallation.

Source: http://msdn.microsoft.com/en-us/library/bb521687(WinEmbedded.51).aspx