• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 938
  • Last Modified:

SQL account error in SharePoint configuration

Hi

I'm trying to configuration my SharePoint to use a SQL server as it's database.  When I try to provide it with the user account, it says "The user name is invalid.  The account must be a valid domain account."

The thing is both of the server are not in any domain, they are both in independent work groups.  Do I have to add both server into a specific domain?   Thanks.

Tom
0
pisceswzh2010
Asked:
pisceswzh2010
  • 2
1 Solution
 
pisceswzh2010Author Commented:
Also I'm using SharePoint Server 2010.  The screen shot is attached.  Thanks.

screenshot
Tom
0
 
monicaiCommented:
Yes.  Sharepoint is designed to scale across multiple servers and it is essential that your servers are joined to a domain controller to enforce trusted connections between the servers.  This also means that your SQL account must be a domain account with permissions granted to login and access your SQL server database.
0
 
pisceswzh2010Author Commented:
Good
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now