Analysis Database Installation Fails When SQL Server Is Configured with CP 850 (220655)

The information in this article applies to:

Microsoft Site Server 3.0

This article was previously published under Q220655

SYMPTOMS

When the French version of Site Server version 3.0 is installed, the Analysis Database Wizard (Assistant Configuration de base de donnes) may fail with the following error:

Impossible d'achiver la creation de la structure de la base de donnees Analysis. Raisons possibles: - Le serveur SQL Server est en pause, arrete ou deconnecte. - La base de donnes Analysis non valides ou une colonne non valide qui n'appartient pas a la structure de la base de donnes Analysis.

This error appears in front of a window titled:

Creation de tables d'importation Definition de table: Cookies.

CAUSE

SQL Server was installed with the Code Page 850 instead of ISO.

RESOLUTION

You can either reinstall SQL Server and leave the default Code Page of ISO or you can rebuild the master database, which will cause you to lose any databases currently installed, so you will need to export them to another server first. To change the code page, follow these steps:

In the Microsoft SQL Server 6.5 folder, on the Start menu, choose SQL Setup.
Click Continue twice, and then choose "Rebuild Master Database."
Click Continue, and then Resume to get to the "Microsoft SQL Server 6.5 Rebuild Options" window.
Click Sets... and choose ISO Character Set (Defaults).
Click OK, and then continue to click Continue until you start rebuilding.

WORKAROUND

To work around this problem, you can use the English version of Site Server 3.0. The English version of Site Server 3.0 supports Code Page 850.

STATUS

Microsoft has confirmed this to be a problem in the French version of Site Server 3.0.

MORE INFORMATION

When the code page is changed from the default ISO Character Set, a conversion is performed on all data. Each query is translated between ANSI (ISO Character Set = Code Page 1252 on Windows NT) and code page 850. For more information, see the following article in the Microsoft Knowledge Base:

153449 INF: SQL Server Code Pages and AutoAnsiToOem Behavior

The creation of the Analysis database fails on the tblImportCookie CREATE TABLE when a single quote is encountered in the query. The apostrophe is in the "DN_de_l'utilisateur" default value of the UserDN column. For more information on apostrophes in translated SQL Server queries, see the following article in the Microsoft Knowledge Base:

175127 BUG: Character Translation Causes 105, Unclosed Quote Error

Modification Type:	Major	Last Reviewed:	10/28/2002
Keywords:	kbbug KB220655