CFF KB - Carrz-Fox-Fire Promotions Knowledge Base

CFF KB is all about 1 thing: The Sharing of Knowledge and the Power we gain from it.
  • Breadrumbs:
  • Microsoft OLE DB Provider for SQL Server (0x80004005) Cannot open database

  • CFF Knowledge Base - Share With Facebook CFF Knowledge Base - Share on Twitter CFF Knowledge Base - Share on Reddit CFF Knowledge Base - Share on Digg It CFF Knowledge Base - Share on Stumble Upon It CFF Knowledge Base - Share on Delicious
    Share With Friends (Updated 6-8-2010)
  • Article ID:
    39
  • Date Created
    Tuesday, November 16, 2010
  • Last Updated
    Wednesday, June 20, 2012
  • This Article Has been Viewed
    2073 times
  • Short Desc
    If your SQL Server Database login fails, you might have one of several different issues to attend to the problem.
  • Details
    This error can happen for several different reasons, we will cover the some of them here.

     
    Microsoft OLE DB Provider for SQL Server (0x80004005)
    Cannot open database "DatabaseName" requested by the login. The login failed.
    /ACN.asp, line 4
  • Recreate Issue
    If the Database within your SQL Server is either:
    #1: Misspelled
    #2: Not created
    #3: The connection string is to another SQL Server.
  • Resolve Issue
    3 Scenarios to work with.

    Make sure that you have
    #1: Spelled the name of your Database correctly.

    #2: Make sure that you provide the correct login credentials such as the correct Username and Password for your database.

    #3: If your have several different database's within your project, make sure that you have the correct IP address (or) Server Name for the right database.