DataBase - SQL Server Sort Order for Business Portal

Asked By L

29-Sep-08 03:40 PM

Hi all,

Our existing SQL Server database for GP uses a Binary sort order. We are
trying to install Business Portal (using Windows Share Point Services) but
the the install instructions says it can only be installed on SQL Server with
sort order 52 (Dictionary Order, Case Insensitive). If we create a new SQL
Server instance using sort order 52 for Business Portal, are there any issues
we may run into in the future regarding data exchange with GP?

Thank you.
LR

29-Sep-08 04:08 PM

You can either create a new SQL Server instance using DOCI or you can let the
system install SQL Express which will automatically use DOCI (dictionary
order case insensitive).

I'm working with a client today doing a BP install and we went with the
latter approach due to their small needs. The SQL Server instance stores the
content. Unless you're going to have a lot of content, excluding the data
people are going to BP to view, you could probably do just fine with SQL
Express.

--
Charles Allen, MVP

29-Sep-08 04:19 PM

Could there be any conflict between the 2 instances down the road. Are you
saying BP will communicate well with GP, even when GP SQL server sort order
is Binary?

Thank you.
LR

29-Sep-08 05:13 PM

Nope
--
Charles Allen, MVP