Solved

Error while setting up the Server Farm Account

Posted on 2016-10-10
8
33 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
  • 5
  • 3
8 Comments
 
LVL 15

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 5

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 15

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
 
LVL 5

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
Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

 
LVL 5

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 15

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 5

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 5

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

Get up to 2TB FREE CLOUD per backup license!

An exclusive Black Friday offer just for Expert Exchange audience! Buy any of our top-rated backup solutions & get up to 2TB free cloud per system! Perform local & cloud backup in the same step, and restore instantly—anytime, anywhere. Grab this deal now before it disappears!

Join & Write a Comment

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
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 give a short introduction and overview of Backup Exec 2012 and how to navigate and perform basic functions. Click on the Backup Exec button in the upper left corner. From here, are global settings for the application such as conne…
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…

758 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now