Solved

Cannot connect to database

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

There is one common problem that all we SharePoint developers share: custom solution deployment. This topic can't be covered fully in this short article, so all I want to do in this one is to review it from a development-to-operations perspectiv…
The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
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…

785 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