Wss 3.0 SP1 install using SQL 2005: collation problem?

I am trying to install SharePoint Services 3.0 SP1 to use our SQL 2005 server
but SharePoint complains about the collation. I cannot reinstall SQL and
change the server's collation since the server has other applications using
it in production

If I run the configuration wizard it has an error:
The SQL Server collation on SQL Server instance 'sqlserverX' 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)

If I follow the DBA created databases instructions from page 42 in this MS
document (http://go.microsoft.com/fwlink/?LinkID=115666) and create the db's
with the proper collation, when I run the psconfig command it fails with a
similiar message:
Command:
"psconfig.exe -cmd configdb -create -server sqlserverX\instanceY -database
sp_config user sharepoint_services -password sharepointpass
-admincontentdatabase sp_admin"

Error:
"An exception of type Microsoft.SharePoint.SPException was thrown.
Additional exception information: The specified SQL server instance has
invalid sort order Latin1_General_BIN. Choose a server instance that
performs case-insensitive and non-binary comparisons."

Is there a way to tell Sharepoint to use the db we have already created or
some other way to fix this?

spconsultant
Tue Apr 22 09:49:11 CDT 2008

I had a client with what sounds like the same scenario.
We installed another INSTANCE on the same server with the
correct collation. Everything went well once we got that done.


On Apr 21, 8:13=A0pm, mikes1p <mike...@discussions.microsoft.com> wrote:
> I am trying to install SharePoint Services 3.0 SP1 to use our SQL 2005 ser=
ver
> but SharePoint complains about the collation. I cannot reinstall SQL and
> change the server's collation since the server has other applications usin=
g
> it in production
>
> If I run the configuration wizard it has an error:
> The SQL Server collation on SQL Server instance 'sqlserverX' is not
> supported. =A0Windows SharePoint Services requires a Latin1 General dictio=
nary
> order, case insensitive, accent sensitive, kana sensitive, and width
> sensitive collation (SQL_Latin1_General_*_CI_AS)
>
> If I follow the DBA created databases instructions from page 42 in this MS=

> document (http://go.microsoft.com/fwlink/?LinkID=3D115666) and create the =
db's
> with the proper collation, when I run the psconfig command it fails with a=

> similiar message:
> Command:
> "psconfig.exe -cmd configdb -create -server sqlserverX\instanceY -database=

> sp_config user sharepoint_services -password sharepointpass
> -admincontentdatabase sp_admin"
>
> Error:
> "An exception of type Microsoft.SharePoint.SPException was thrown. =A0
> Additional exception information: The specified SQL server instance has
> invalid sort order Latin1_General_BIN. =A0Choose a server instance that
> performs case-insensitive and non-binary comparisons."
>
> Is there a way to tell Sharepoint to use the db we have already created or=

> some other way to fix this?