Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Error while setting up the Server Farm Account

Posted on 2016-10-10
8
Medium Priority
?
53 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 17

Accepted Solution

by:
Ivan earned 2000 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 17

Assisted Solution

by:Ivan
Ivan earned 2000 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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 17

Assisted Solution

by:Ivan
Ivan earned 2000 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

A procedure for exporting installed hotfix details of remote computers using powershell
In case you ever have to remove a faulty web part from a page , add the following to the end of the page url ?contents=1
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will show how to configure a single USB drive with a separate folder for each day of the week. This will allow each of the backups to be kept separate preventing the previous day’s backup from being overwritten. The USB drive must be s…

577 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