January 27, 2010 at 4:22 pm
Hi,
We are installing SQL Server 2005 to store share point databases. Could you please tell me what are the collation settings I need to select while installing SQL Server, on the collations settings page?
Thanks
January 27, 2010 at 5:32 pm
I've got my server collation set to Latin1_General_CI_AS (I'm in New Zealand). Sharepoint didn't have a problem with this. It sets a different collation on the databases it installs anyway (in our case, Latin1_General_CI_AS_KS_WS).
Not sure if it bases it on the Windows Regional Settings or the SQL Server collation.
MARCUS. Why dost thou laugh? It fits not with this hour.
TITUS. Why, I have not another tear to shed;
--Titus Andronicus, William Shakespeare
January 27, 2010 at 7:37 pm
Scott Duncan-251680 (1/27/2010)
I've got my server collation set to Latin1_General_CI_AS (I'm in New Zealand). Sharepoint didn't have a problem with this. It sets a different collation on the databases it installs anyway (in our case, Latin1_General_CI_AS_KS_WS).Not sure if it bases it on the Windows Regional Settings or the SQL Server collation.
The above collation is actually SharePoint predefined collation check the support article below for details.
http://support.microsoft.com/kb/843578
Kind regards,
Gift Peddie
January 27, 2010 at 7:53 pm
The above collation is actually SharePoint predefined collation check the support article below for details.
http://support.microsoft.com/kb/843578%5B/quote%5D
From the above link, I understand that share point databases will be created with the collation settings Latin1_General_CI_AS_KS_WS when share point is installed. But my concern is whether we need to select the same collation settings, i.e Latin1_General_CI_AS_KS_WS when we install SQL Server 2005 (on the, collation settings page of SQL Server setup) ?
Because I just installed SQL Server 2005 with the default collation settings, SQL_Latin1_General_CP1_CI_AS (on the, collation settings page of SQL Server setup)
thanks
January 27, 2010 at 7:56 pm
rambilla4 (1/27/2010)
The above collation is actually SharePoint predefined collation check the support article below for details.
http://support.microsoft.com/kb/843578%5B/quote%5D
From the above link, I understand that share point databases will be created with the collation settings Latin1_General_CI_AS_KS_WS when share point is installed. But my concern is whether we need to select the same collation settings, i.e Latin1_General_CI_AS_KS_WS when we install SQL Server 2005 (on the, collation settings page of SQL Server setup) ?
Because I just installed SQL Server 2005 with the default collation settings, SQL_Latin1_General_CP1_CI_AS (on the, collation settings page of SQL Server setup)
thanks
I should have explained better SharePoint and SSRS databases installs with their collation, the server collation is not relevant.
Kind regards,
Gift Peddie
January 27, 2010 at 8:24 pm
Thank you very much..I'm clear now
January 27, 2010 at 10:30 pm
rambilla4 (1/27/2010)
Thank you very much..I'm clear now
I am glad I could help.
🙂
Kind regards,
Gift Peddie
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply