Solved

Error while setting up the Server Farm Account

Posted on 2016-10-10
8
40 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:DPatel
  • 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 6

Author Comment

by:DPatel
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
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 
LVL 6

Author Comment

by:DPatel
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 6

Author Comment

by:DPatel
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 6

Author Comment

by:DPatel
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 6

Author Closing Comment

by:DPatel
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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

I thought I'd write this up for anyone who has a request to create an anonymous whistle-blower-type submission form created using SharePoint 2010 (this would probably work the same for 2013). It's not 100% fool-proof but it's as close as you can get…
Restoring deleted objects in Active Directory has been a standard feature in Active Directory for many years, yet some admins may not know what is available.
This tutorial will show how to push an installation of Backup Exec to an additional server in both 2012 and 2014 versions of the software. Click on the Backup Exec button in the upper left corner. From here, select Installation and Licensing, then I…
This tutorial will walk an individual through configuring a drive on a Windows Server 2008 to perform shadow copies in order to quickly recover deleted files and folders. Click on Start and then select Computer to view the available drives on the se…

786 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