Posted by Erland Sommarskog on 12/31/05 00:31

coosa (coosa76@gmail.com) writes:
> I have tried to create an asembly with PERMISSION_SET = EXTERNAL_ACCESS
> under SQL Server 2005 but i failed so far.
> I also see the TRUSTWORTHY Property for the database as disabled and
> can't enable it.
> I know that the sysadmin has the full authority for all activities, but
> i'm logged in as the system xp admin account and i tried to add a
> server role to grant the dbo sysadmin rights, but i also failed.
> Can some one please help?

And the error messages are for the various things that fail are?

If you are logged into Windows with admin privs, and connect to SQL Server
with Windows authentication, you will have sysadmin rights in SQL Server,
unless you've removed BUILTIN\Administrator


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]