Solved

Error while setting up the Server Farm Account

Posted on 2016-10-10
8
46 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
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
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

Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Format Date fields 11 64
CTIOS error on Windows 10 3 62
Adding columns to a table which has non null columns 3 43
SQL 2008 - Disappearing Temp Table in Stored Procedure 24 62
This article explains how to install and use the NTBackup utility that comes with Windows Server.
A recent project that involved parsing Tableau Desktop and Server log files to extract reusable user queries for use in other systems. I chose to use PowerShell to gather the data, and SharePoint to present it...
This tutorial will walk an individual through locating and launching the BEUtility application to properly change the service account username and\or password in situation where it may be necessary or where the password has been inadvertently change…
This tutorial will walk an individual through the steps necessary to enable the VMware\Hyper-V licensed feature of Backup Exec 2012. In addition, how to add a VMware server and configure a backup job. The first step is to acquire the necessary licen…

734 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