MSDE Reached Max Size. Cannot Login for Maintenance?

I can no longer access my MSDE database for maintenance purposes. It will not
allow a login:

[Shared Memory]SQL Server does not exist or access denied.
[Shared Memory]ConnectionOpen (Connect()).

and I cannot run any maintenance to shrink the Db.

Regards,

Steve Zatkoff
szatkoff.TakeThisOut@rb-llp.com

hi Steve,
Steve Zatkoff wrote:
> I can no longer access my MSDE database for maintenance purposes. It
> will not allow a login:
>
> [Shared Memory]SQL Server does not exist or access denied.
> [Shared Memory]ConnectionOpen (Connect()).

even if a particular database has exceeded the file size limitation, you
should be able to connect to that instance.. the "typical" causes of such an
exception are listed in
http://support.microsoft.com/default.aspx?scid=kb;en-us;328306&Product=sql

> and I cannot run any maintenance to shrink the Db.

if you succesfully connected to the instance, you should be able to "delete"
from the database... what exception are you reported with, accessing the db?
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz http://www.hotelsole.com
DbaMgr2k ver 0.21.1 - DbaMgr ver 0.65.1 and further SQL Tools
--------- remove DMO to reply