sbs 2008 Sharepoint 3.0 Central Administration error: cannot connect to the configuration database

Discussion in 'Windows Small Business Server' started by john doe, Feb 8, 2010.

  1. john doe

    john doe Guest

    On sbs 2008, I'm trying to connect to the SharePoint 3.0 Central
    administration and it's not working. It gives this error:
    Cannot connect to the conguration databse.
    This is a test environment.
    Please advise and thanks
     
    john doe, Feb 8, 2010
    #1
    1. Advertisements

  2. Russ SBITS.Biz [SBS-MVP], Feb 8, 2010
    #2
    1. Advertisements

  3. john doe

    john doe Guest

    Russ, that didn't help. Here's what the event viewer says:

    SQL Database 'SharePoint_Config_29c26fca-17b8-48c1-9704-b869932abcb6' on SQL
    Server instance 'np:\\.\pipe\MSSQL$Microsoft##SSEE\sql\query' not found.
    Additional error information from SQL Server is included below.
    Cannot open database
    "SharePoint_Config_29c26fca-17b8-48c1-9704-b869932abcb6" requested by the
    login. The login failed.
    Login failed for user 'NT AUTHORITY\NETWORK SERVICE'.




     
    john doe, Feb 8, 2010
    #3
  4. Try this
    http://msdn.microsoft.com/en-us/library/aa952804(BTS.20).aspx
    Russ

    --
    Russell Grover - SBITS.Biz [SBS-MVP]
    Microsoft Gold Certified Partner
    Microsoft Certified Small Business Specialist
    24hr SBS Remote Support - www.SBITS.Biz
    Question or Second Opinion - www.PersonalITConsultant.com
    Free Trial Microsoft Online Services - www.Microsoft-Online-Services.com


     
    Russ SBITS.Biz [SBS-MVP], Feb 8, 2010
    #4
  5. john doe

    john doe Guest

    I think the below resolution will fix my problem. How do I grant the
    NETWORK SERVICE account "Database Creation" rights in SQL Server?
    Resolution
    To resolve this issue, do one of the following:

    a.. Grant the NETWORK SERVICE account "Database Creation" rights in SQL
    Server.


    b.. Change the application pool identity account to an account that has
    "Database Creation" rights in SQL Server.

     
    john doe, Feb 8, 2010
    #5
  6. I can't find the instructions for the first one.

    second one
    http://support.microsoft.com/kb/832770


    --
    Russell Grover - SBITS.Biz [SBS-MVP]
    Microsoft Gold Certified Partner
    Microsoft Certified Small Business Specialist
    24hr SBS Remote Support - www.SBITS.Biz
    Question or Second Opinion - www.PersonalITConsultant.com
    Free Trial Microsoft Online Services - www.Microsoft-Online-Services.com


     
    Russ SBITS.Biz [SBS-MVP], Feb 8, 2010
    #6
  7. Are you sure you need to do this? Have you installed a SBS rollup
    patch? If not, try that first.
     
    Susan Bradley, Feb 9, 2010
    #7
  8. john doe

    john doe Guest

    I tried the second one and I get this error message:

    TITLE: Microsoft SQL Server Management Studio Express
    ------------------------------
    Create failed for Login 'SERVER\NETWORK SERVICE'.
    (Microsoft.SqlServer.Express.Smo)
    For help, click:
    http://go.microsoft.com/fwlink?Prod...in&LinkId=20476------------------------------
    ADDITIONAL INFORMATION:
    An exception occurred while executing a Transact-SQL statement or batch.
    (Microsoft.SqlServer.Express.ConnectionInfo)
    ------------------------------
    User does not have permission to perform this action. (Microsoft SQL Server,
    Error: 15247)
    For help, click:
    http://go.microsoft.com/fwlink?Prod...2&EvtSrc=MSSQLServer&EvtID=15247&LinkId=20476
    ------------------------------

    I tried to check out the links from Microsoft but they didn't have any info.
    Thanks



     
    john doe, Feb 9, 2010
    #8
  9. john doe

    john doe Guest

    Well, I can't get the Sharepoint 3.0 Central Administration to work on
    SBS2008. When I click on it, the webpage comes up and says, "Cannot connect
    to the configuration database."

    I never heard of a SBS rollup patch.

    I can't believe how hard this stuff is. SBS2003 was a whole lot easier.



    Are you sure you need to do this? Have you installed a SBS rollup
    patch? If not, try that first.
     
    john doe, Feb 9, 2010
    #9
  10. SBS 2003 has/had it's moments too where it broke Sharepoint.

    Step one, flip the box over to Microsoft update and ensure you install
    SBS update rollup 3 and get this box patched up to snuff before messing
    with Sharepoint.
     
    Susan Bradley, Feb 10, 2010
    #10
  11. john doe

    john doe Guest

    Will do. I'll get back with you. Thanks for your help.
     
    john doe, Feb 10, 2010
    #11
  12. john doe

    john doe Guest

    Susan, I went to download the rollup from Microsofts web page but they said
    to use update.microsoft.com which brings up Windows Update on SBS2008 and it
    says that "There are no updates available for your computer" and that's for
    online updates also.
    Please advise.
    Thanks
     
    john doe, Feb 10, 2010
    #12
  13. http://update.microsoft.com/microsoftupdate/v6/default.aspx?ln=en-US

    Click there.
    Ensure that it launches that you are going to Microsoft update.
     
    Susan Bradley, Feb 10, 2010
    #13
  14. john doe

    john doe Guest

    It still takes me to the Windows Update on the computer and says Windows is
    up to date.
     
    john doe, Feb 11, 2010
    #14
  15. Are you positive it says Windows update and doesn't say Microsoft update
    and has a button asking you to flip over to Microsoft update?

    Can you email me a screen shot at ?

    That should take you to a screen that asks if you want to change Windows
    update over to Microsoft update. Are you using IE?

    Can you run www.sbsbpa.com and let me know what it says you are missing
    in patches.

    In the meantime read these as I think this is your issue:

    The Official SBS Blog : Companyweb Inaccessible After Sharepoint 3.0
    Service Pack 2:
    http://blogs.technet.com/sbs/archiv...ible-after-sharepoint-3-0-service-pack-2.aspx

    The Official SBS Blog : Authentication Issues Accessing Companyweb from
    the Server Itself after 963027 or Windows 2008 SP 2:
    http://blogs.technet.com/sbs/archiv...yweb-from-the-server-itself-after-963027.aspx
     
    Susan Bradley, Feb 12, 2010
    #15
  16. john doe

    john doe Guest

    It finally came through. I think Microsoft was down for a minute.
    I'll let you know how it goes with Sharepoint 3.0 Central Administration
     
    john doe, Feb 12, 2010
    #16
  17. john doe

    john doe Guest

    Well, I get an error installing it. I'll send the picture to your email.
     
    john doe, Feb 12, 2010
    #17
  18. john doe

    john doe Guest

    Well I couldn't get the fix working for SBS2008 so I reformatted and started
    over again.
    Thanks for helping me out.
     
    john doe, Feb 16, 2010
    #18
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.