Home Forums SQL Server 2005 Administering "Database 'COMMON' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details." RE: "Database 'COMMON' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details."

  • I believe mine is the memory issue, see below:

    How do you change memory settings if you can't even connect to the server.

    When connecting through SQLcmd I get the same error. Any help will do.

    also when trying to do a repair of the installation same error apprears.

    "

    TITLE: Connect to Server

    ------------------------------

    Cannot connect to ..

    ------------------------------

    ADDITIONAL INFORMATION:

    A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=233&LinkId=20476

    "

    What you don't know won't hurt you but what you know will make you plan to know better