Project Server 2003 setup problem: Windows locale settings; support code page 850

[Jack Kohn]

I am installing Project 2003 Server on a Windows 2003 server.

Our DBA has manually created the MS Project databases on a separate
SQL 2000/Win2000 server.

When I get to the MS Project Server 2003 Setup screen titled "Enter
database account information," (see the "MS Office Project Server 2003
Installation Guide" p 90), I input the logins and passwords that the
DBA defined on the SQL server. Setup then gives me the following
dialog box:

"The Windows locale settings on this computer prohibit a
connection to the database. Change the locale settings to
support code page 850 before attempting to connect to
database <OurDBName>."

Our DBA tells me that our SQL servers use code page 850 for historical
reasons. What's got us stumped, though, is that Windows Server 2003
seems to have code page 850 (and many others) enabled by default. In
the Regional and Language Options control panel, you can't even
disable code page 850 - it's checked on AND gray.

I've been hunting for info on this for a while. I'd love to find a
clue if anyone has an extra one to spare.

Thanks.

-jmk

 

[OlegK]

MS Project Server and Pro are very critical to locale settings.
As for me, I reinstalled SQL Server, I didn't find any other solutions.

Oleg K

 

[OlegK]

All locale settings must be set up by default, not just listed.

But I think there is a solution, search on the Internet

 

[Jack Kohn]

Thanks for the response, Oleg.

What do you mean by "All locale settings must be set up by default,
not just listed?"

At any rate, I took your advice and searched (some more) on the
Internet. I thought I was getting close, but -- no. I've opened a call
with MS now.

If anyone has additional advice, I'd just as soon fix this problem
before MS gets back to me.

TIA.

-jmk

 

[Jack Kohn]

<snip>

A call to MS Tech support finally provided the answer to this one.

On the Project Server, we needed to change the following registry key:

HKLM\System\CurrentControlSet\Control\Nls\CodePage
Value ACP
Change Data value for ACP to 850 from the default (1252).

I expect others might run into this if they've migrated SQL data from
Sybase and/or SQL 6 and kept the default collation order (which was
850 on those earlier systems).

-jmk