• Skip to main content
  • Skip to primary sidebar
  • Skip to footer
  • Technology
    • Development
    • Hardware
    • Intune
    • Microsoft
    • Office
    • Office 365
    • Security
    • SharePoint
    • Software
    • SQL server
  • Personal development
    • Blog
    • Career
    • Freelancer
    • Knowledge
    • NEWS
    • Private
    • Thoughts
  • Consulting services
  • Contact me

Not only IT

About life, IT and other things...

Home » Technology » Development » Cannot connect to the configuration database.

Cannot connect to the configuration database.

November 8, 2010 By Tomasz Szulczewski Leave a Comment

Today I’ve faced strange problem and I spent a few hours to solve it. I’ve installed my new SharePoint 2010 sever for development – nothing special. But when I created first top level site and try to display it http://ServerName I get error: ”Cannot connect to the configuration database”. What’s up? I’ve tried different things: reset passwords, delete and create managed account and site, without result. Finally I’ve tried to check SQL Server 2008 R2 logs and strange I don’t have access as local administrator? How it’s possible? Well I’ve read somewhere (don’t remember where) that when install SQL Server with windows domain account this account will have granted all necessary right and then it’ will also fine for SharePoint installation. Bullshit!

SharePoint Installation account (System account) needs SQL Server role: “SYSADMIN”! Without that this account will create all stuffs but I will not be able to grant all necessary settings for new application poll and managed account! And exacly what happened in my case. My SQL Sever and SharePoint system account hasn’t role sysadmin…

image

And then you will get error: “Cannot connect to the configuration database”.  You need to grant this role and recreate website and web application from the begging and all works fine.
[adblockingdetector id=”5770e6ed85560″]

Related

Filed Under: Development, SharePoint, SQL server Tagged With: SharePoint

About Tomasz Szulczewski

I've got more than 20 years of IT experience. IT is my passion and I am still increasing my skills. I work as a SharePoint, Office 365 and Azure architect.

Reader Interactions

Leave a Reply Cancel reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Primary Sidebar

Join the Newsletter

Social media

  • Facebook
  • Instagram
  • LinkedIn
  • Twitter
  • YouTube

Search this site

Sign up for Wise accounts

Signup and earn $25

payoneer
payoneer

My latest achievement

Microsoft 365 Certified: Enterprise Administrator Expert
Microsoft 365 Certified: Enterprise Administrator Expert

Tags

Azure Azure Active Directory BizSpark Blog career Certification cloud conference edge freelance Freelancer Hardware home office InfoPath Intune Knowledge licensing Microsoft Microsoft 365 News Office Office 365 Personal development Power virtual agent Private security SharePoint SharePoint designer SharePoint online Software SQL server upwork Windows Windows 365 yammer

Footer

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

Copyright © 2022 Tomasz Szulczewski