cannot acees two databases as owner
- From: "David" <dav@xxxxxxxxxxxx>
- Date: Sat, 22 Dec 2007 19:01:01 +0100
Hi,
i have already posted this in other forums but so far nobody could tell me
how to solve this.
i log in to Sql server with Studio Management with Windows Authentification.
My account ("myaccount") is local 'administrator' on this computer. There
are several databases and "myaccount" is owner of all databases.
On one day, as far as i know nothing changed to the configuration of sql
server, two databases were no longer accessible: when trying to expand them:
error: "this database is not accessible" and when trying to rightclick on
them in order to see the properties:
Cannot show requested dialog. (Microsoft.SqlServer.Express.SqlMgmt)
------------------------------
An exception occurred while executing a Transact-SQL statement or batch.
(Microsoft.SqlServer.Express.ConnectionInfo)
------------------------------
The server principal "SERVERNAME\myaccount" is not able to access the
database
"sales" under the current security context. (Microsoft SQL Server, Error:
916)
But the webapplication still runs: i can insert records, update, delete ...
from asp.net.
Any attempt to grant myself privileges or make me sysadmin gives the error:
"user does no have permission for performing ..."
I also tried "reconfigure with override" with the same error. Same thing
when trying to remove a login ...
So i have the idea that the account "myaccount" has lost its owner
privileges because of unknown reason.
Can somebody tell me the right steps to do for recovering the two databases?
Thanks
David
.
- Follow-Ups:
- Re: cannot acees two databases as owner
- From: Ekrem Önsoy
- Re: cannot acees two databases as owner
- Prev by Date: Re: Run SQL Server as domain user
- Next by Date: Re: cannot acees two databases as owner
- Previous by thread: Re: Setting Max Server Memory in 64 bit machine
- Next by thread: Re: cannot acees two databases as owner
- Index(es):
Relevant Pages
|
Loading
