Solved

Cannot connect to database

Posted on 2011-03-24
5
748 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

Microsoft SharePoint Foundation 2010 and Microsoft SharePoint Server 2010 do not offer the option to configure the location of the SharePoint diagnostic trace log files during installation.  This can, however, be configured through Central Administr…
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…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

627 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