Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Cannot connect to database

Posted on 2011-03-24
5
Medium Priority
?
750 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
  • 2
4 Comments
 
LVL 14

Accepted Solution

by:
KoenVosters earned 1500 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

Independent Software Vendors: 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

The vision: A MegaMenu for a SharePoint portal home page The mission: Make it easy to maintain. Allow rich content and sub headers as well as standard links. Factor in frequent changes without involving developers or a lengthy Dev/Test/Prod rel…
Introduction: Sometimes when I receive a call from my users to solve their problems it is very difficult for me to found their computer IP address. Even finding their computer Host to provide remote support can be a problem.  So I resorted to Goo…
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…

877 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