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

Question

Post reply

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

Viewing 4 posts - 31 through 35 (of 35 total)

You must be logged in to reply to this topic. Login to reply

Manvendra SSC-Addicted Points: 442 More actions · Answer 1

Manvendra

SSC-Addicted

Points: 442

June 30, 2009 at 1:37 am

#1017403

run below cmd:

ALTER DATABASE SET ONLINE

BudaCli Hall of Fame Points: 3404 More actions · Answer 2

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

homebrew01 SSC Guru Points: 55566 More actions · Answer 3

It's annoying and not practical to dig up an old thread, especially one with 4 pages, and then put your own problem at the end. I started to rant more, but deleted that part.

ganesh.migbui Newbie Points: 5 More actions · Answer 4

Here's the solution to ur problem....

Check this link : http://sqltrends.blogspot.in/2013/03/database-cannot-be-opened-due-to.html