Granting dbo ASSEMBLY EXTERNAL_ACCESS permissions

[coosa]

Hi all,

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?

Best regards

[Jens]

Try to set the property with TSQL:

ALTER DATABASE <Database> SET TRUSTWORTHY ON

dbo is a database role, yo you can grant the dbo sysadmin rights.
Sysadmin rights have to be granted on the server basis.
HTH, Jens Suessmeyer.

[Erland Sommarskog]

coosa (co*****@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, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx

[coosa]

no i didn't, but the script Jens worked finally