Solved

Error while setting up the Server Farm Account

Posted on 2016-10-10
8
43 Views
Last Modified: 2016-10-20
Hi Experts,

I'm getting an error while setting up the server farm account (Sharepoint 2010).

Sharepoint-2010-Configuration-Error.png
Trying to deploy a single server with SQL Server 2008 R2 Standard. This is not the domain controller.

Any help would be greatly appreciated.
Regards,
D Patel
0
Comment
Question by:D Patel
[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
  • 5
  • 3
8 Comments
 
LVL 16

Accepted Solution

by:
Ivan earned 500 total points
ID: 41836624
Hi,

SP 2010 has to connect to DB that has collation Latin1_General_CI_AS_KS_WS
As per error, you have Latin1_General_BIN on SQL?

Info: https://support.microsoft.com/en-us/kb/2008668

Regards,
Ivan.
0
 
LVL 7

Author Comment

by:D Patel
ID: 41836649
Hi Ivan,

Thanks for your prompt reply.

Can you guide me in resolving the issue as I am new to this?

Is there any possibility to change the Collation?

What will be the side effects if I change the collation in middle?

Thanks in Advance,
Regards,
D Patel
0
 
LVL 16

Assisted Solution

by:Ivan
Ivan earned 500 total points
ID: 41836674
Hi,

is this new SP installation, and most important, is this lab or production?

Thing is, you can easily change collation on DB (Properties --> Options --> Collation) BUT, if that collation was set that way, for some reason, then something can stop working.

Maybe your Server collation is by default Latin1_General_BIN, and that is why it is that collation setup on SP database?.
Can you go to SQL, right click on serer --> Properties --> and in first windows, grayed out, will be server collation. Is it Latin1_General_BIN?
0
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

 
LVL 7

Author Comment

by:D Patel
ID: 41836712
Sharepoint were already installed on the server...
And I just going to setup the Server Farm for the first time...

This is the Production Server...

Server Collation is set to Latin1_General_BIN...
0
 
LVL 7

Author Comment

by:D Patel
ID: 41843385
Hi Ivan,

Can you guide me on How to change the Collation after SQL Server Installation?

Regards,
D Patel
0
 
LVL 16

Assisted Solution

by:Ivan
Ivan earned 500 total points
ID: 41843409
Hi,

Changing server collation after server installation is not easy task. Seams kinda easier to reinstall server, since you would need to drop all databases, rebuild master db, recreate all db...
Not sure if I would want to do all of that. Maybe you should rethink all of this, or find someone to do it for you.

Guide on how to do it can be found here: https://msdn.microsoft.com/en-us/library/ms179254(v=sql.110).aspx

Regards,
Ivan.
0
 
LVL 7

Author Comment

by:D Patel
ID: 41843508
Hi Ivan,

Can you check this link and suggest me whether it is worth or not?

https://www.mssqltips.com/sqlservertip/3519/changing-sql-server-collation-after-installation/

I have not tried this...

Request your help...

Regards,
D Patel
0
 
LVL 7

Author Closing Comment

by:D Patel
ID: 41852051
Hi Ivan,

I have created new named instance and selected the collation as suggested by you in your first comment.

It's worked for me.

Really thanks,
D Patel
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

You might have come across a situation when you have Exchange 2013 server in two different sites (Production and DR). After adding the Database copy in ECP console it displays Database copy status unknown for the DR exchange server. Issue is strange…
A procedure for exporting installed hotfix details of remote computers using powershell
This tutorial will walk an individual through the steps necessary to install and configure the Windows Server Backup Utility. Directly connect an external storage device such as a USB drive, or CD\DVD burner: If the device is a USB drive, ensure i…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

756 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