This is bazillionth time that I’ve encountered this issue, so I’ve decided to post a solution to it. If you live in a country which doesn’t have Microsoft Dynamics NAV 2009 localized version yet, you might have tried installing the W1 (worldwide, English, non-localized) version. Did it work out?
If you install the NAV 2009 W1 version on a system with regional settings not matching the demo database code page (in W1 it’s Latin_1_General_CS_AS) the installation goes smoothly, but the attempt at running the RoleTailored client fails.
When you run the RoleTailored client, after the splash screen this is what you get:
What the fuss, the message explains everything. Yes, except you can’t do Alter Database or come anywhere near the Validate Code Page setting before you open the database, and you can’t open it precisely because of this error message.
The only option you have is to awaken the hax0r inside you and do a little database hack.
This is what you do in order to run the RoleTailored client if your code page doesn’t match the system code page:
- Start SQL Server Management Studio.
- Connect to your server. Make sure to specify Database Engine under Server type. Server name should contain the name of the SQL Server database server instance. In most cases it is simply the host name or IP address of the server where you installed the SQL Server; sometimes it’s the named instance of the SQL Server. If you are unsure about your server name, simply go to C:Program FilesMicrosoft Dynamics NAV60Service (or wherever you installed the NAV 2009 Service Tier), open file CustomSettings.config, and search for key DatabaseServer—it’s value contains the server name to which you need to connect.
- Expand Databases.
- Locate the NAV 2009 database and expand it. If you installed the demo, it should be called Demo Database (6-0). If it isn’t, or you aren’t sure, just check the same file from step 2, and search for key DatabaseName—that’s the database you are looking for.
- Expand Tables.
- Locate table dbo.$ndo$dbproperty. Right-click it, click Open (or Edit Top 200 Rows, if you are using SQL Server 2008).
- Locate column named checkcodepage. It contains value 1. Change it to 0.
That’s it. Now go, restart your Microsoft Dynamics NAV 2009 RoleTailored client, and enjoy the show.