Comatibility of NAV with SQL Server 2008

MS has released an article saying that the following are compatible with SQL Server 2008
-NAV 4.0 SP3
-NAV 5.0
-NAV 2009

For further details you go through the following link

https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?SMNWUKNTMMYSZRRNOTTUKOOSTLLQWZYKKWSKRLPNMRUWVVUYLUPXPMVQRNR
https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;940718

MS Dynamics NAV with Clustering services

After a long time back with osme new and good things. Recently I was involved in an implementation where we have used MS Clustering services with MS SQL Server 2005. I did had some findings with respect to this you can find the views in this link

http://groups.google.com/group/MSDynamics-arena/web/ms-cluster-with-sql-server

 

Windows Server 2008 Compatibility with NAV

Microsoft Dyanmics NAV is compatibile with Windows Server 2008. People who are using Business Gateway and Comerce gateway need to update the solution with article
KB Article 56161.

Developing Solutions in NAV 2009

The release of the new NAV 2009 is not yet declared yet you can grab the CTP3 and take a sneak peek of the same. If you would like to know about developing solutions in NAV 2009. Here it goes

https://mbs.microsoft.com/partnersource/documentation/whitepapers/whatsnew_nav2009.htm?printpage=false

Overview of the Platform RollUp Updates

To get hold of the overview of platform rollup updates that are available for Microsoft Business Solutions - Navision 3.7 through Microsoft Dynamics NAV 5.0 you can follow this link

https://mbs.microsoft.com/knowledgebase/KBDisplay.aspx?scid=kb;en-us;940807

MS Dynamics NAV 2009

If you want to have a sneak preview of the same then use the following link.

https://mbs.microsoft.com/partnersource/products/navision/2009.htm

Super Roles In SQL Server 2005 WITH MS Dynamics NAV SP3

The Super role of Microsft Dyanmics NAV contains all the permissions for the objects and system related activities in Microsft Dyanmics NAV. But when the same super role is being alloted to a user is SQL Server 2005 then you will notice the following scenarios:
Case -1:
The database is being restored and users are defined in the SQL Server 2005, and the same users are defined in the database logins in MS Dynamics NAV and the security is synchronized. Lets take two users user A and User B where user A is the dbo owner/sysadmin in SQL Server 2005 and in Navision the role assigned to the both the user A & B is SUPER. After the roles are assigned and the security is synchornized you wioll noticve that both the user/s A and B are able to acess all the object in NAV SP3(includes customized objects). Well till now you will feel that the super role in MS Dynamics NAV SP3 proprietory database is same as that of the NAV database in SP3.

Case-2:
Create a new object (table in which the client license permits to access the table say the obhect id is 50,000). Now import the object into the NAV Dtabase in SQL Server 2005. Now login to the system using the User A. You will notice that the user is able to access the table 50000. After you have verfied with the permission to the table of 50000 with the User-A, login using the user -B. Go tO the Object designer and try to run the object. The system will say that you donot have permission to the Object 50000.

Now you can see that both the users have been assigned the SUPER role but one of the user which not the dbo owner in SQL Server 2005 will not be able to have the acess. In SQL Server 2005 with NAV SP3 everytime you import a object ensure you run a Security Synchronize, as even the SUPER role (which is not the dbo owner/sysadmin in SQL SERVER 2005)will not be able to gain access to the objects.