|
Home > Archive > MS SQL Server > October 2006 > The SQL Server collation on SQL Server instance 'xx\yy' is not sup
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
The SQL Server collation on SQL Server instance 'xx\yy' is not sup
|
|
| Shine Achuthan 2006-10-24, 6:38 pm |
| SQL server on a cluster server environment, and when I access SQL server
instance and right click properties I could see right collation that I want,
but MOSS(sharepoint 2007) installation throws an error in event log. Any one
knows what settings this installation may be looking or can I ignore this
error and move ahead, installation went successful. Again when I tried to
connect index server (where MOSS search and index services are running) it
throws error into event log again but process went successful.
Any ideas?
Error thrown to event log
---------------------------------------
The SQL Server collation on SQL Server instance 'MachineName\Instanc
e name’
is not supported. Windows SharePoint Services requires a Latin1 General
dictionary order, case insensitive, accent sensitive, kana sensitive, and
width sensitive collation (SQL_Latin1_General_
*_CI_AS).
Thanks!!
Shine
| |
| John Bell 2006-10-24, 6:38 pm |
| Hi
As the error message says your collation is not supported I would change it
even if it seems to work.
John
"Shine Achuthan" wrote:
> SQL server on a cluster server environment, and when I access SQL server
> instance and right click properties I could see right collation that I want,
> but MOSS(sharepoint 2007) installation throws an error in event log. Any one
> knows what settings this installation may be looking or can I ignore this
> error and move ahead, installation went successful. Again when I tried to
> connect index server (where MOSS search and index services are running) it
> throws error into event log again but process went successful.
>
> Any ideas?
>
> Error thrown to event log
> ---------------------------------------
> The SQL Server collation on SQL Server instance 'MachineName\Instanc
e name’
> is not supported. Windows SharePoint Services requires a Latin1 General
> dictionary order, case insensitive, accent sensitive, kana sensitive, and
> width sensitive collation (SQL_Latin1_General_
*_CI_AS).
>
>
> Thanks!!
> Shine
|
|
|
|
|