Solved

Microsoft Sharepoint Install Error - Latin1_General_BIN

Posted on 2011-03-08
2
1,207 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
  • 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Work Over Net is a new and very powerful collaboration product. With its new easy interface it is becoming very competitive to other similar products like webex and office interactive. WON 2010 have the standard business tools needed for multi-offic…
If you create your solutions on SharePoint sooner or later you will come upon a request to set  permissions of the item depending on some of the item's meta-data - the author, people assigned as approvers, divisions, categories etc. The most natu…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

821 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