November 5, 2008 at 1:24 pm
Hi,
I Have a user btsqadmin need sysadmin privileges for installing biztalk.After installation I need to change the sysadmin role security admin and give the dbroles
db_accessadmin, db_securityadmin for database 'BizTalkMgmtDb'
db_accessadmin, db_securityadmin for 'database 'BizTalkRuleEngineDb'
The database SSODB has db_owner role by default?
can I change it to above roles db_accessadmin n db_security admin?
when I tryied that Iam getting the following error:
TITLE: Microsoft SQL Server Management Studio
------------------------------
Add member failed for DatabaseRole 'db_accessadmin'. (Microsoft.SqlServer.Smo)
------------------------------
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
------------------------------
Cannot use the special principal 'dbo'. (Microsoft SQL Server, Error: 15405)
and there are some jobs created by default when biztalk is installed with the owner btsqadmin. As per biztalk document They need sysadmin privileges for btsqadmin to run a particulat backup job in one instance.In other 2 instances btsqadmin does not require sysadmin role just security admin fine.
So went I changed the owner of the job to my login abc\sqladmin(boxadmin). Can we change the owner like this or the onwer of the jobs will be the sqlservice like abc\sqlservice?
plz advice me
November 17, 2008 at 8:49 pm
Did you find a solution to the CANNOT USE THE SPECIAL PRINCIPAL error yet?? Thank You Russ
January 6, 2009 at 4:53 pm
can any body plz advice on this issue
January 8, 2009 at 6:04 am
You can change the permissions whenever you want.
just remove the db_owner database role and add the other two roles. It gives the error still it creates the user.
and you can change th owner of the job and if the user has enough permissions, job works fine.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply