Can't login to specific database with user sa, all others okay

Hi,
I'm hoping someone can shed some light on this. We're using sql
server express edition, and our server has a couple of databases (in
addition to the built in ones). We've been using user sa, with a
password set (non-blank) to access the databases. Suddenly, we can't
access the one of them. Unfortunately, we have no other users
configured with access to it either. Logging in with windows
authentication (as administrator) does not grant us access to the
database either. What can cause this? How can we fix it?
Thanks,
AerikWhat error message are you getting when you try to query the database?
Linchi
"Aerik" wrote:
> Hi,
> I'm hoping someone can shed some light on this. We're using sql
> server express edition, and our server has a couple of databases (in
> addition to the built in ones). We've been using user sa, with a
> password set (non-blank) to access the databases. Suddenly, we can't
> access the one of them. Unfortunately, we have no other users
> configured with access to it either. Logging in with windows
> authentication (as administrator) does not grant us access to the
> database either. What can cause this? How can we fix it?
> Thanks,
> Aerik
>