"Bart Duncan [MSFT]" wrote:

> What collation are you trying to install with? There's a fix for
> rebuildm.exe that exposes SQL_Danish_Pref_CP1_CI_AS and
> Danish_Norwegian_CS_AS (see 312990 FIX: Rebuildm and Setup Do Not
Expose
> All the SQL Collations). For the other collations listed in that
article
> you only have two options that I am aware of:
>
> - Do unattended install (as you noted, this isn't available for
> clustered instances)
> - Install SQL 7.0 with the desired collation, then upgrade the
instance
> to SQL 2000.
>
> Bart
> ------------
> Bart Duncan
> Microsoft SQL Server Support
>
> Please reply to the newsgroup only - thanks.
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
>
> --------------------
> Date: Wed, 30 Jun 2004 19:07:33 +0200
> From: Hans de Bruin <hans@nl.invalid>
> User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4)
> Gecko/20030624 Netscape/7.1
> X-Accept-Language: en-us, en
> MIME-Version: 1.0
> Newsgroups: microsoft.public.sqlserver.clustering
> Subject: Re: Sql7 Collation in Sql2000 cluster enviroment
> References: <6AE5A969-B4C7-4F63-8BC3-3F4E11158678@microsoft.com>
> <40e1a50c$0$36169$e4fe514c@news.xs4all.nl>
> <BEC61845-22F3-4C3C-BA31-1F1682A99180@microsoft.com>
> In-Reply-To: <BEC61845-22F3-4C3C-BA31-1F1682A99180@microsoft.com>
> Content-Type: text/plain; charset=us-ascii; format=flowed
> Content-Transfer-Encoding: 7bit
> Lines: 10
> Message-ID: <40e2f355$0$36861$e4fe514c@news.xs4all.nl>
> NNTP-Posting-Date: 30 Jun 2004 19:07:33 CEST
> NNTP-Posting-Host: 80.127.23.245
> X-Trace: 1088615253 news.xs4all.nl 36861 [::ffff:80.127.23.245]:14276
> X-Complaints-To: abuse@xs4all.nl
> Path:
>
cpmsftngxa06.phx.gbl!TK2MSFTNGXA06.phx.gbl!TK2MSFTNGXA07.phx.gbl!cpmsftngx
>
a10.phx.gbl!TK2MSFTFEED01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-on
>
line.de!t-online.de!fr.ip.ndsoftware.net!216.196.110.149.MISMATCH!border2.
>
nntp.ams.giganews.com!nntp.giganews.com!news2.euro.net!newsgate.cistron.nl
> !transit.news.xs4all.nl!not-for-mail
> Xref: cpmsftngxa06.phx.gbl microsoft.public.sqlserver.clustering:14274
> X-Tomcat-NG: microsoft.public.sqlserver.clustering
>
> JohanSql wrote:
> > Yes, I know that. The problem is that the collation I want does not
> exist in Sql2k, only in Sql7 and before. Thats why I had to run the
> unattended setup before.
>
> What collation do you use in sql7?
>
> --
> Hans de Bruin
>
> http://eratosthenes.xs4all.nl
>
>
>
> From: "=?Utf-8?B?Sm9oYW5TcWw=?=" <JohanSql@discussions.microsoft.com>
> Subject: Re: Sql7 Collation in Sql2000 cluster enviroment
> Date: Wed, 30 Jun 2004 01:09:01 -0700
> Newsgroups: microsoft.public.sqlserver.clustering
>
> Yes, I know that. The problem is that the collation I want does not
exist
> in Sql2k, only in Sql7 and before. Thats why I had to run the
unattended
> setup before.
> --
> Regards
> Johan
>
>
> "Hans de Bruin" wrote:
>
> > JohanSql wrote:
> > > Hi!
> > > I'm about to install Sql2k in a cluster enviroment. The problem is
> the collation.
> > > In my other Sql2k database servers (non cluster) i did an
unattended
> setup, in the unattended file I wrote the collation I wanted because it
> cant be chosen in the installation of Sql2k.
> > > Sql2k installation in cluster does not support unattended
> installation.
> > > Does anyone know how I can get the colllation I want???
> > > I've tried to restore the model db from another sql-server with
"my"
> collation and then restart sql and then the temp-db has the same as the
> model, but I've heard this is not supported by MS (but it works...).
> >
> > Try the custom installation button. Its on the window where you set
the
> > location of the program and the datafiles.
> >
> > --
> > Hans de Bruin
> >
> > http://eratosthenes.xs4all.nl
> >
> >
>
> From: "=?Utf-8?B?Sm9oYW5TcWw=?=" <JohanSql@discussions.microsoft.com>
> Subject: Sql7 Collation in Sql2000 cluster enviroment
> Date: Tue, 29 Jun 2004 04:50:01 -0700
> Newsgroups: microsoft.public.sqlserver.clustering
>
> Hi!
> I'm about to install Sql2k in a cluster enviroment. The problem is the
> collation.
> In my other Sql2k database servers (non cluster) i did an unattended
> setup, in the unattended file I wrote the collation I wanted because it
> cant be chosen in the installation of Sql2k.
> Sql2k installation in cluster does not support unattended installation.
> Does anyone know how I can get the colllation I want???
> I've tried to restore the model db from another sql-server with "my"
> collation and then restart sql and then the temp-db has the same as the
> model, but I've heard this is not supported by MS (but it works...).
> --
> Regards
> Johan
>
>