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.

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:

Hope you find this helpful