Solved

Cannot connect to database

Posted on 2011-03-24
5
746 Views
Last Modified: 2012-05-11
Hi Experts,
I now have no hair left and I have exhausted every trick that worked for others...
My environment is 64bit system with exchange. SQL is installed on a hyper-V.
Everything works fine.
This means that Sharepoint is installed, I can ping database from core server and from remote server.
I can log onto the database using ODBC from core server and from remote pc.
I have created the users as recommended BUT when running Sharepoint Products Configuration wizard I get the error:
Cannot connect to database master at SQL Server. I use the same credentials that allows me to access the DB from other apps like VS 2010. I have googled and found many similar issues from others but just cannot get past this point.
Please help
regards
0
Comment
Question by:esps
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
5 Comments
 
LVL 14

Accepted Solution

by:
KoenVosters earned 500 total points
ID: 35214955
Did you configure the firewall on your SharePoint box to allow outbound traffic over port port 1433 on TCP and UDP? Or if you are using a non standard SQL port, are you allowing traffic over that one?
0
 

Assisted Solution

by:esps
esps earned 0 total points
ID: 35225748
In addition to KoenVorsters comment, the following worked.
I create an admin user on the SharePoint host, I then added this users as an Admin user on the Database server. I then added this user on the SQL DB and important to note, Windows authentication, not SQL and lastley logged onto the SP host machine with the SP Admin user.
When I then ran the config wizard it worked.
0
 
LVL 14

Expert Comment

by:KoenVosters
ID: 35225847
Objecting as my answer was a solution to the problem. There was no acces to the sql. That then afterwards you figured out that there were also problems on your sql configuration to get everything working isnt the question you asked initially and neither did u ask for further assistance here.
0
 

Expert Comment

by:nysupport
ID: 35762453
I had the same issue.  To get around it I had to add the SharePoint Installer account (the one I'm running PSCONFIG under) as a local admin on the SQL server.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Back in July, I blogged about how Microsoft's new server pricing model, combined with the end of the Small Business Server package, would result in significant cost increases for many small businesses (see SBS End of Life: Microsoft Punishes Small B…
Microsoft has released remote PowerShell capabilities to all commercial Office 365 customers. So you can be controlled via PowerShell and not from the Office 365 admin center Download Windows PowerShell Module for Lync Online http://www.micros…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

756 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