Skip to main content

Posts

NAV 2009, 2009 SP1 and 2009 R2 in Same Machine Continued...

Hi all, As promised in earlier post    that I will try to figure out the way to run classic report from Role Tailored client which is not installed on my machine. One of my post  I explained that from where Role Tailored client find the path of classic client, I am just using that. My machines have NAV 2009 SP1 Installed. I went to registry editor (regedit.exe) to find the key where the information of classic client in stored. As you can see in the screen shot above (FOR WIN 7) that the information about classic client is stored in Computer\HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\WINDOWS\CurrentVersion\App Paths\finsql.exe Go to File & select Export and save the registry file on desktop with Name say NAV Classic for NAV 2009 SP1. Now open the file in notepad. The selected line shows the path of finsql that need to start when we execute a report whose RTC Layout is not created. Let’s change the file and make changes for other

NAV 2009, 2009 SP1 and 2009 R2 in Same Machine

Hi all, After Microsoft Released NAV 2009 Three Tier Architecture, we find issues while testing RTC on a version which is not installed. Most of us uninstall current version and install the required version just for testing purpose. I thought of creating multiple services for NAV 2009, NAV 2009 SP1 and NAV 2009 R2 in same machine with diffrent port numbers, so that we can run RTC also whenever required. My Machine have NAV 2009 SP1 installed and i copied the Classic, Service and RoleTailored Client folder on my C Drive for Other two Versions. I have created two Folders NAV2009 & NAV2009R2 inside "C:\Program Files\Microsoft Dynamics NAV\60". For Creating Service for NAV 2009 i used the command- SC CREATE MicrosoftDynamicsNAV2009 binpath= "C:\Program Files\Microsoft Dynamics NAV\60\NAV2009\Service\Microsoft.Dynamics.Nav.Server.exe" start= auto obj= "NT Authority\NetworkService" type= own For Creating Service for NAV 2009

Create File encountered operating system error 5(Access is denied.) while attempting to open or create the physical file

Hi all, Most of time while trying to attach a database in SQL Server We face a issue. ERROR Message - TITLE: Microsoft SQL Server Management Studio ------------------------------ Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc) ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'D:Databasefilepath.mdf'. (Microsoft SQL Server, Error: 5123) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.4000&EvtSrc=MSSQLServer&EvtID=5123&LinkId=20476 ------------------------------ Resolution - While starting SQL Server Managment Studio, dont just double click the icon, Right Click it and select Run As Administrator. Thanks & Regards, Saurav Dhyani

JET Reports In Navision

Hi all, Navision have introduced new type of Reports Jet Reports. Lets see some details about the product. As of today Jet Reports Express for Microsoft Dynamics NAV is available for download at PartnerSource and CustomerSource for customers on an active Business Ready Enhancement Plan. Partner Source  JET Reports For Navision Customer Source  Jet Reports For Navision

TransHeader & TransFooter in RTC Reports

Hi all, While Trying to figure out something new features in Navision RoleTailored Client, I figured out a blog which I find useful to share with you all. Most of the time customer ask for Transheaders and Transfooters in Role Tailored Client(RTC) Reports and we say that it cannot be done as read in Microsoft documents. I tested by creating a report as suggested in the Blog and it worked as expected. Its is done by using the Hash Table in the Report Code Section. Please read the complete blog at here . Thanks & Regards Saurav Dhyani www.sauravdhyani.com

Database Backup from SQL Server Managment Studio

Hi all, Some Client requires to take database backup on daily basis but due to increasing size of data its is tedious and time consuming if we suggest to go for Navision Backup.At this point the best solution to suggest is to take backup from SQL Server.So lets discuss how to take backup of a database from SQL Server Managment Studio. For taking Backup from SQL Server there are certain steps -

Problem In Dynamics NAV 2009 R2...

Hi all, While browsing over web about new features of Dynamics NAV 2009 R2, i find some information about same in Waldo Blog. The title of the Blog is Dynamics NAV 2009 R2 is not a "normal" release ... beware!.  After reading the Blog i was surprised and thought that every partner and customer should know about the same. So before upgrading to Dynamics NAV 2009 R2, please read the article at Waldo Blog. You can read the post here .        Thanks & Regards, Saurav Dhyani http://saurav-nav.blogspot.com/