Tell me more ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

Can't connect my Sharepoint 2010 to my SQL 2008 server during setup configuration.

Named Pipes and TCP/IP are enabled on 1433. Firewalls are off. I've verified that I can telnet from my Sharepoint server to my SQL server on 1433.

I put in my server name (have also tried IP address), and my domain\username and password, and get the message..

"Cannot connect to database master at SQL Server at . The database might not exist, or the current user does not have permission to connect to it."

I've tried using various users ranging from the custom users I've set up for this (via whitepaper instructions), and also tried using my domain administrator credentials, all of which end in the same result.

Is there any way to troubleshoot this further to determine the problem?

share|improve this question
Nevermind, I figured it out. The restricted user that I was using on the sharepoint machine didn't have database privileges. I incorrectly assumed that the credentials being used against the database were the credentials it was asking for in the form. – Joel M Sep 29 '11 at 14:26
go ahead and move your comment to the answer box and mark it as the answer. Thanks. – Jesus Shelby Sep 29 '11 at 16:03

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.