Re: cannot acees two databases as owner

Thanks for replying (again).

You're right: Buitlin\administrators has gone ...
But i don't understand that "myaccount", which is present and which is
member of the built-in group Administrators, is not sysadmin.
Now i tried several things, but all failed:
1) login with 'sa': i don't now the password. And i cant' change it in
Studio Management because of "not enough permissions..."
2) create in Studio Management Built-in\Administrators: "not enough
permissions..."
3) make "myaccount" sysadmin: still "not enough permissions..."

So there is nothing i can do with "myaccount" .. and i can't log in with
'sa'.
Hopeless?

"Ekrem Önsoy" <ekrem@xxxxxxxxxxxx> schreef in bericht
news:8880F628-D025-4CA5-86F6-ED21FF56D6CD@xxxxxxxxxxxxxxxx
There is a Login created when you were installing SQL Server. It's name is
BUILTIN\Administrators. It lets members of Local Administrators login to
SQL Server
as a member of sysadmin fixed server role. Which makes you System
Administrator of SQL Server.

I think, your web application uses "sa" account to connect to your SQL
Server. As you probably know "sa" account is a builtin account and it's
also a member of the sysadmin fixed server role.

I think, someone removed BUILTIN\Administrators from the sysadmin fixed
server role. Or deleted it and you are connecting your SQL Server as a
public user (in this case I assume there is another Login which lets you
login to your SQL Server)

Try to connect to your SQL Server using your "sa" account and investigate
your Login if possible.

--
Ekrem Önsoy



"David" <dav@xxxxxxxxxxxx> wrote in message
news:eCUQdSMRIHA.536@xxxxxxxxxxxxxxxxxxxxxxx
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







.

Relevant Pages

  • Re: SQL Login
    ... The sa login account is a member of that role as well. ... Dejan Sarka, SQL Server MVP ... > But how do we add the User X to the sysadmin / ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server 7 Permissions!
    ... Yes it matters if the user is a member of the Windows ... there is a group added to SQL Server called ... So a member of the administrators group ...
    (microsoft.public.sqlserver.security)
  • Re: Cant edit logins or server roles
    ... A windows local admin may have sysadmin access for a SQL Server ... don't seem to be a member of sysadmins. ...
    (microsoft.public.sqlserver.security)
  • Re: permissions not working
    ... at the windows NT level they have sysadmin rights because I did not ... It is likely that the user in question is a member of the Windows Administrators group on the SQL Server. ... Administrators group members access the SQL Server via membership of the BUILTIN\Administrators login are sysadmin role members by default in SQL 2000. ...
    (microsoft.public.sqlserver.security)
  • Re: XP_CMDSHELL
    ... When master..xp_cmdshell is called by a user who is a member of the sysadmin ... fixedserver role, master..xp_cmdshell will be executed under the account's ... security context in which the SQL Server service is running. ...
    (microsoft.public.sqlserver.programming)