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

Problem connecting to database Sharepoint 2010 server farm (no active directory)

When configuring Sharepoint 2010 and trying to connect to SQL Server 2008 database ;
executing PowerShell command (New-SPConfigurationDatabase) as admin

I get the following error:
Cannot connect to database master at SQL server at {ServerName}. The database might not exist, or the current user does not have permission to connect to it.

SQL Server 2008 R2  (separate box)
SharePoint 2008        (separate box)

Windows Server 2008 R2
ActiveDirectory: NONE

Confirmed and verified the following;
- Checked roles are set for spfarm (dbcreator, public, securityadmin)
- Enabled SQLBrowser Service
- Verified TCP/IP is enabled
- Verified mapping to Master database
  • 4
1 Solution
Justin SmithSr. System EngineerCommented:
I'm assuming spfarm is the account running the SharePoint Timer Service.

Did you verify the account you are logged in as has access in SQL as well?
lorgnettesolutionsAuthor Commented:
ACH1LLES, correct.
Yes we did verify our account has access in SQL.

Part of our problem is that since we can't use active directory, we have to create the same admin user on both servers,

In example:
Server1 has SQL Server and a local user called server1\admin (which also has db access)
Server2 has Sharepoint and a local user called server2\admin
Rainer JeschorCommented:
can you please post the complete command you have used?
Did you create the farm credentials the right way?

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

lorgnettesolutionsAuthor Commented:
We resolved this issue some time ago.  Even though we did not have Active Directory the following worked:
spfarm account created in windows on both servers (sharepoint server and database server)
spfarm was granted database access (high level permissions)
executed the following line in Powershell: NewSp-ConfigurationDatabase
then entered the name of the new db, the server and the user credentials using the local account and domain (i.e. server1\spfarm)
once the database was created and connected, opened configuration wizard and step through the rest of the sharepoint configuration.
lorgnettesolutionsAuthor Commented:
resolved issue before getting a comprehensive response
lorgnettesolutionsAuthor Commented:
resolved issue before getting a comprehensive response.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

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