Solved

Microsoft Sharepoint Install Error - Latin1_General_BIN

Posted on 2011-03-08
2
1,227 Views
Last Modified: 2012-06-22


When installing sharepoint services 3.0 I run into the below error when selection of my server and database has been input.  I am running Microsoft Server 2005.

I found some information on the web which points to a SQL Server re install but I am hoping this is not true.

The specified SQL server instance has invalid sort order Latin1_General_BIN.  Choose a server instance that performs case-insensitive and non-binary comparisons.

Any help appreciated.   Richard
0
Comment
Question by:RichardH1976
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
2 Comments
 
LVL 6

Expert Comment

by:ThatSharepointGuy
ID: 35073338
You could do one of two things.

You could reconfigure your SQL server (the instance that you are trying to connect to) to have the correct Collation (which is where I think your problem lies).  

If this cannot be done, you could create a new instance and set the correct collation on that, and then have SharePoint try to connect back.

This should work.  I ran into this error sometime last year and used this tip from a friend of mine to have everything working nicely.
0
 
LVL 6

Accepted Solution

by:
ThatSharepointGuy earned 500 total points
ID: 35073370
Also just a thought after asking my DBA friend (sitting in the cube next to me ^-^):
She seems to think that collation cannot be changed on system databases, thus if you are trying to connect back to them for some reason you will have to uninstall/reinstall SQL on that server.

Of course, SharePoint creates all of the databases it needs, so I don't think that's an issue...just thought I'd post it as a tip.
0

Featured Post

SharePoint Admin?

Enable Your Employees To Focus On The Core With Intuitive Onscreen Guidance That is With You At The Moment of Need.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
Summary In SharePoint 2010 it is easy to create custom color themes to jazz up a site. Theme colors can also be created in PowerPoint 2010 with a few clicks. But how do the chosen colors actually look in the SharePoint site? The attached PowerPoint…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

624 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question