?
Solved

Microsoft Sharepoint Install Error - Latin1_General_BIN

Posted on 2011-03-08
2
Medium Priority
?
1,242 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 2000 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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

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…
Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

719 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