iNECTA - Microsoft Navision
Home Portfolio of Products & Services Media Kit About Us Contact Us Blog Go To Meeting Worldwide Partner Portal

Jon - Navision Corner


Posted by : Jon in (Networking)

Public vs private IP addresses

Tagged Under : , ,

People can use private IP addresses inside companies or inside your home. They are not published to the internet. They are used for private use.

Public IP addresses are used for public use and they are published to the internet.  For example the public IP address of www.yahoo.com is 69.147.76.15

Posted by : Jon in (Technical)

installing NAV 4.0 on windows vista and connecting to microsoft sql 2005 database

Tagged Under : , , , , , ,

Applies to NAV 4.0 and microsoft sql server 2005.  SQL server 2008 has not been tested yet

There’s a problem when you try to connect to a SQL Server database due to a wrong MDAC detection.

The cause of this problem is the unified versioning of all DLL in Vista.

 Navision is detecting MDAC version through File version of SQL ODBC driver (sqlsrv32.dll). On Windows XP you can see version like 2000.85.1117.0 etc, but on Vista the file has version 6.0.5600.16384 and this is “less” than the requested version. Changing MDAC detection in Navision is no way.

The trick to run Dynamics NAV 4.x on Vista is this:

  1. You need some resource editor tool, for example the Resource Hacker application
  2. Copy the file sqlsrv32.dll from your Vista system32 folder to another place.
  3. Open this copy in the resource editor
  4. Change FILEVERSION value to new value e.g. 2000.85.1117.0 (in the header of Version info ressource)
  5. Compile the resource
  6. Save the file (backup original file!)

Now you need to copy the file back into system32 folder. But under Vista, this is not easy task. The file cannot be changed because just installer has enough rights.

Replacing original file with modified one:

  1. Open properties of the original file
  2. On the Security tab click Advanced
  3. On the Owner tab click Edit
  4. Select new owner of the file, for example your account
  5. Commit all changes
  6. Change permissions for your account to have all rights
  7. Commit all changes
  8. Now you are able to delete the file – delete it
  9. Copy the modified file into system32 folder

Posted by : Jon in (Internet Explorer)

When Internet Explorer doesn’t show any graphics just text

Tagged Under : , ,

Applies to IE 7.0

Sometimes when you are visiting a web page then it opens very slow and finally when it opens up it just displays text but no graphics. This happens when the keepalive-time out expires. The reason can be a slow server or a slow internet connection. The easiest way to solve this problem is to try again later. But if you like you can adjust the keepalive - timeout parameters. Microsoft has an article on how to do this

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

It is tested for IE 7.0 but I have not seen any testing for newer versions yet.

Posted by : Jon in (Internet Explorer)

Internet explorer is continuously asking for username and password

Tagged Under : ,

Applies to IE 8.0 and earlier

Somtimes you experience that IE asks for username and password. This can be annoyng. You can do the following to prevent this:

Goto - tools - internet options - security - internet - custom level… -  scroll down to user authentication - select anonymous logon - click on ok

Posted by : Jon in (Internet Explorer)

Internet explorer shows old information

Tagged Under : , , , ,

Applies to IE 8.0 and earlier versions

Somtimes your IE shows old infirmation and doesn’t follow up when a webpage is changed.

The fix:

 Go to tools - Internet options - in Browsing History click on delete… -  select temporary internet files and deselect anything below - click on ok.

This will delete old cache in your browser and IE will be forced to get the new information from the web page.

Posted by : Jon in (SQL)

Create Database permission denied in DB master in sql 2008

Tagged Under : ,

This happens in Vista when you try to create a database in microsoft sql 2008. The reason is that by default the administrator account does not have enough rights.

The solution is to grant rights to the administrator

Step 1: Go to Start > All Programs > Microsoft SQL Server 2005 > Configuration Tools > SQL Server Surface Area Configuration.

Step 2: Click on ‘Add New Administrator’.

Step 3: In the ‘SQL Server User Provisioning on Vista’ dialog box, look out for the ‘Member of the SqlServer SysAdmin role ‘ in the ‘Available Privileges’ box. Transfer it to the ‘Privileges that will be granted to’ box. Click Ok.

and at last

Control Panel->User Accounts->Turn User Account Control on or off. turn it off and try again

Posted by : Jon in (Technical)

how to troubleshoot corruption of outlook .ost file

Tagged Under : , , ,

There is a good article from microsoft on how to do this

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

But sometimes the tools above don’t solve the problem. This can happen when the .ost file is corrupt beyond repairing.

What you can do in this situation is to look at the .ost file usually in the location %userprofile%Local SettingsApplication DataMicrosoftOutlook folder and rename the outlook.ost to outlookold.ost.
Start outlook again and let it create the .ost file again. It can take upto few hours. depends on the size of your inbox.

Posted by : Jon in (SQL)

To permanently set the trace flag for NAV in SQL

Tagged Under : , ,

To set the trace flag

Step 1.     Open SQL Server Configuration Manger.

Step 2.     In the left pane, click SQL Server 2005 Services.

Step 3.     In the right pane, right-click SQL Server (MSSQLSERVER), and on the shortcut menu, click Properties.

Step 4.     In the Properties window, click the Advanced tab.

Step 5.     Click the Startup Parameters property, and open the drop-down list.

Step 6.     Type ;-T4616 at the end of the line in the drop-down list and click OK.

Step 7.     In the right pane, right-click SQL Server (MSSQLSERVER), and on the shortcut menu, click Restart..