Login failed for user 'XXXX'. 4060,"42000",[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot open database XXXXXX requested by the login. The login failed.

The below error occurs when we try to convert the database from NAV2009 to NAV2013.


The following SQL Server error or errors occurred:

18456,"28000",[Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'XXXXXX' 4060,"42000",[Microsoft][SQL Server Native Client 10.0][SQL Server]Cannot open database "XXXXXX'" requested by the login. The login failed.

Solution:

In this case ,please follow the below steps

1. We have to restore the NAV2009 backup again 

2. Open the database In NAV2009 and remove all tables which have property “LinkedObject“ Yes 

Note: Please also check the tables which are having LinkedObject=No.

It should be like below 

3. Try to convert the database in NAV20013.
4. Delete all temp windows logins\SID's

Now It will convert it in to NAV2013.

I hope this will help you.

Thanks!

How to Block Direct posting in NAV

Sometimes General Ledger (G/L) and sub ledgers (Customer,Vendor,Bank...) values won’t get tally, when users directly post transaction entries to these accounts using journals. 

To avoid these mistakes, Microsoft Dynamics NAV has a simple method to control this. This functionality called as Block for Direct Posting.

In order to block an account from direct posting, you need to go to particular G/L Account Card and uncheck  the "Direct Posting" check box. 
Once tick mark is removed, Microsoft Dynamics NAV will not allow any user to post journal entries directly to the particular G/L account. (At any given time you can put the tick mark back and allow to post directly).

Error:TableData 2000000001 does not exist.

We get the below error when we try to connect the database

To resolve this error,we need to set the below permission in Sql server

I hope it will help you.

Error while opening NAV2013 R2 database

Some times we used to get the below error while opening NAV2013 R2 database

Error :

---------------------------
Microsoft Dynamics NAV Development Environment
---------------------------
The Object table contains a Microsoft Dynamics NAV Development Environment field data type that is not compatible with the SQL Server data type:

Field: Version List
Type: Text248
SQL type: VARCHAR(80)
---------------------------
OK  
---------------------------

to resolve this error ,Simply run the below command in SQL Server

ALTER TABLE [dbo].[Object]

ALTER COLUMN [Version List] VARCHAR(248) NOT NULL

I hope this will help some one.

Thank you.

Error while running Power shell

Some times we may get the below error while import module in like power shell

'Run only scripts that you while scripts from the internet can be useful ,this script can potentially harm your computer. If you trust this script, use the unblock-file cmdlet to allow to run without this warning message. Do you want to run c:\program files (x86)\microsoft dynamics NAV\90\Role Tailored Client\Microsoft Dynamics.nav.Apps.Tools.Format.ps1xml?'

as shown below

Solutions                                                                                                                                                     

   To resolve this issue,please foollow the below steps,

1.             Right-click on the .ps1 file in question, and select Properties

2.              Click Unblock in the file properties

  3.        OK.

Cumulative Update 1&2 for Microsoft Dynamics NAV 2016 has been released

Cumulative Update 2 includes all application and platform hotfixes and regulatory features that have been released for Microsoft Dynamics NAV 2016.

The cumulative update includes hotfixes that apply to all countries and hotfixes specific to the following local versions:

•   AU – Australia
•   AT – Austria
•   BE – Belgium
•   CH – Switzerland
•   CZ – Czech Republic
•   DE – Germany
•   DK – Denmark
•   ES – Spain
•   FI  – Finland
•   FR – France
•   IS – Iceland
•   IT – Italy
•   NA – North America
•   NL – Netherlands
•   NO – Norway
•   NZ – New Zealand
•   RU – Russia
•   SE – Sweden
•   UK – United Kingdom

Download here
NAV2016-CU3

NAV2016 CU2

NAV2016 CU1

How to Set filters on factbox through code

I would like to set filter on my fact box which is not able to do through page link.

Steps are shown below

I have added below the function in my factbox page and

Set the name for the factbox in our main page.
Now we need to call as shown below in onaftergetRecord trigger