473,425 Members | 1,888 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,425 software developers and data experts.

uanble to assign a db_owner role to sa for a particular DB

I have a database named as test_db. Iam trying to assign a db_owner role to the test_db. But it won't allow me to assign the role and give the error "CANNOT USE THE SPECIAL PRINCIPAL 'DBO' (MICROSOFT SQL SERVER ERROR 15405)".

Can any one help me in this regard.

Arshad
Jul 27 '10 #1
2 3685
ck9663
2,878 Expert 2GB
If you're trying to assign yourself as dbo on your database, it won't work coz you're already the dbo. You can't add db_owner to it anymore.

Good Luck!!!

~~ CK
Jul 27 '10 #2
Many thanks CK. Actually what i ma trying to do is restore a database from sql server 2000 to sql server 2008 64 bit. After restoration the said database have 0 roles / schemas. we create roles and schemas manually and assign the user mapping to that particular database. when we execute the sql statement "SELECT IS_MEMEBER ('DB_OWNER')" the query returns the value zero. Actually it must return the value 1. because of this we are unable to create publication. Because when we try to create the publisher at the end of wizard it give us an error "YOU DO NOT HAVE THE REQUIRED PERMISSION"

Please help in this regard.
Jul 27 '10 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Tyler Smith Watu | last post by:
I am trying to come up with a stored procedure to grant all users db_owner role (rather than have to manually check the users each time) Thanks in advance for your help TY
0
by: DCount17 | last post by:
I need to create a windows application (using C#) that creates/assigns and retrieves database roles on Analysis Services. While I can get the users from the "Members" table on SQL Server, I am...
1
by: liorhal | last post by:
is there a command that can change a login role to db_owner in all the tables, or do i have to use { USE table_name EXEC sp_adduser 'login name' EXEC sp_addrolemember 'db_owner', 'login name' }...
1
by: db55 | last post by:
I have some users that I need to run stored procedures, but they can't seem to run them unless they are in the db_owner role of the database. How do I give them access to run the stored procs...
4
by: hazz | last post by:
If I successfully run a VS.NET app which includes the following; ************************** APP 1 **************************** m_iIdnt = new...
3
by: Jo | last post by:
Hi, I know how to create membership user and to define role via "Administer website" in design mode of e.g. an ASP.NET login control. My questions are: 1) how to create a membership user...
9
by: teddymeu | last post by:
Hi Guys im still new to all this and im building an app in asp.net 2 vb which will have 4 roles, Admin, Wholesaler, Landscaper, Customer. When the user sets up there account i want a drop down...
7
by: monty | last post by:
Hi All, I am facing a problem while executing a statement through C++ code using OLEDB API of Sql server. There is a problem with DB_OWNER role. If I will enable the DB_OWNER everything is...
5
by: Jonathan Wood | last post by:
Greetings, I'm using ASP.NET membership and I'd like to query the number of users in a particular role. I don't want the overhead of returning a dataset and then getting the number of items...
0
by: ctatvasoft | last post by:
in our application that need to create some tables in tempdb. The user (call it APP) is not sa. Everytime that the server need to be rebooted, the db_owner role on tempdb for user APP disappear....
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.