Colocating SharePoint databases on the same SQL Server as 3rd party apps

I’m currently working my way through a deployment for a test environment on one of the projects we are currently engaged with (yes, I’m working on Australia Day – How un-Australian).

Anyway, this particular 3rd party application has some specific requirements around collation settings which means it is impossible to create a SharePoint database on the same Database server instance. This error is thrown every time you attempt to create the database…

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

So what’s the solution? Pretty easy actually… just create a separate instance on the SQL Server and use the default sort order, then install SharePoint to that instance.

Problem solved – back to the BBQ…

Brad

Advertisements

About Brad Saide

I'm a SharePoint consultant. I'm also slowly going bald, seem to have a permanent spare tyre around my waist and enjoy socialising with friends over a beer or 10. The last 2 may possibly be related. Started working with SharePoint when the first version was in limited beta release (participated in the Technology Adoption Program while at Woolworths) and have been committed to the adoption of the technology as a business enabler ever since.
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s