 | |
Sql7 Collation in Sql2000 cluster enviroment
microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Sql7 Collation in Sql2000 cluster enviroment -
06-29-2004
, 06:50 AM
#2
| |||
| |||
|
|
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...). |
location of the program and the datafiles.
--
Hans de Bruin
http://eratosthenes.xs4all.nl
#3
| |||
| |||
|
|
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 |
#4
| |||
| |||
|
|
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. |
--
Hans de Bruin
http://eratosthenes.xs4all.nl
#5
| ||||
| ||||
|
|
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 |
What collation do you use in sql7?
--
Hans de Bruin
http://eratosthenes.xs4all.nl
From: "=?Utf-8?B?Sm9oYW5TcWw=?=" <JohanSql (AT) discussions (DOT) 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:
Quote:
|
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 |
Quote:
|
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 |
Quote:
|
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 |
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
#6
| |||
| |||
|
|
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 (AT) nl (DOT) 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 (AT) microsoft (DOT) com 40e1a50c$0$36169$e4fe514c (AT) news (DOT) xs4all.nl BEC61845-22F3-4C3C-BA31-1F1682A99180...soft (DOT) com In-Reply-To: <BEC61845-22F3-4C3C-BA31-1F1682A99180 (AT) microsoft (DOT) com Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Lines: 10 Message-ID: <40e2f355$0$36861$e4fe514c (AT) news (DOT) 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 (AT) xs4all (DOT) nl Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA06.phx.gbl!TK2MSFT NGXA07.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.MIS MATCH!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 (AT) discussions (DOT) 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 (AT) discussions (DOT) 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 |
#7
| |||
| |||
|
|
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 (AT) nl (DOT) 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 (AT) microsoft (DOT) com 40e1a50c$0$36169$e4fe514c (AT) news (DOT) xs4all.nl BEC61845-22F3-4C3C-BA31-1F1682A99180...soft (DOT) com In-Reply-To: <BEC61845-22F3-4C3C-BA31-1F1682A99180 (AT) microsoft (DOT) com Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Lines: 10 Message-ID: <40e2f355$0$36861$e4fe514c (AT) news (DOT) 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 (AT) xs4all (DOT) nl Path: cpmsftngxa06.phx.gbl!TK2MSFTNGXA06.phx.gbl!TK2MSFT NGXA07.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.MIS MATCH!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 (AT) discussions (DOT) 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 (AT) discussions (DOT) 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 |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.