No announcements
Found 3027275 threads
-
0 VotesThe database principal owns a service in the database, and cannot be dropped.
could create it again, but deleting User didn't succeeded. I'm gettin error "The database principal owns a service in the ...Answered | 2 Replies | 3949 Views | Created by milax - Wednesday, March 7, 2012 4:35 PM | Last reply by milax - Wednesday, March 7, 2012 5:08 PM
-
0 Votes
The database principal owns a service in the database, and cannot be dropped.
I try to drop a user from the database, but the system said the user own some service and cannot drop it. I have deleted all ...Answered | 1 Replies | 9826 Views | Created by char2000hk - Monday, November 8, 2010 4:24 AM | Last reply by Balmukund - Monday, November 8, 2010 6:14 AM -
1 Votes
The database principal owns a schema in the database, and cannot be dropped.
Hi Friends, I am unable to drop the user and i am getting below error mesage, i just restored the DB from different ...Answered | 2 Replies | 10286 Views | Created by maddy28 - Saturday, March 3, 2012 8:56 PM | Last reply by maddy28 - Monday, March 5, 2012 12:52 PM -
2 Votes
Error: 15138 The database principal owns a schema in the database, and cannot be dropped.
thread. SELECT ' IF EXISTS (SELECTAnswered | 10 Replies | 24831 Views | Created by Satishs1206 - Thursday, February 11, 2016 10:21 AM | Last reply by Luis_Fernando19 - Tuesday, November 20, 2018 10:58 AM -
26 Votes
The database principal owns a schema in the database, and cannot be dropped.
::[db_datareader] TO [db_datareader] After this, you can attempt to drop the role. You cannot drop a database principal that ...Answered | 11 Replies | 127988 Views | Created by Ken Grissom - Wednesday, February 15, 2006 3:44 PM | Last reply by ziaullah75 - Saturday, March 22, 2014 7:56 AM -
1 Votes
Error: 15138 The database principal owns a schema in the database, and cannot be dropped.
from the above, and if prints something that catalog view may be worth looking into a little more. Change "youruser" to the correct username - ...Answered | 16 Replies | 18625 Views | Created by joeller - Tuesday, June 19, 2012 6:33 PM | Last reply by mebv - Friday, May 31, 2013 9:25 PM -
0 Votes
The database principal owns objects in the database and cannot be dropped
The database principal owns objects in the database and cannot be dropped.Answered | 2 Replies | 3713 Views | Created by 查查 - Friday, May 3, 2013 7:53 AM | Last reply by Maggie Luo - Tuesday, May 7, 2013 9:35 AM -
1 Votes
"The database principal owns a symmetric key in the database, and cannot be dropped."
I am trying to drop a User from our sql 2008 DB and I get the above error message. How can I determine what symmetric key is owned by ...Answered | 2 Replies | 3062 Views | Created by edm2 - Thursday, July 31, 2014 8:38 PM | Last reply by edm2 - Thursday, July 31, 2014 9:51 PM -
5 Votes
The database principal owns a database role and cannot be dropped.
Hi Experts, While trying to remove a login and associated user from respective database. Getting following ...Answered | 3 Replies | 28427 Views | Created by Nadvi1 - Wednesday, January 2, 2013 4:36 PM | Last reply by Mariano Asturias - Thursday, May 26, 2016 8:58 PM -
0 Votes
The database principal owns a schema in the database
Error: 15138 the database principal owns a schema in the database, and cannot be ...Answered | 3 Replies | 1146 Views | Created by mito access - Thursday, December 14, 2017 2:14 AM | Last reply by Erland Sommarskog - Thursday, December 14, 2017 8:22 AM -
2 Votes
DB role unable to delete-The database principal owns a schema in the database, and cannot be dropped.
principal owns a schema in the database, and cannot be dropped. Any one can help me on . ...Answered | 2 Replies | 2066 Views | Created by ashwan - Monday, May 28, 2018 3:44 AM | Last reply by Pirlo Zhang - Monday, May 28, 2018 7:57 AM -
0 Votes
Error encountered The database principal owns objects in the database and cannot be dropped whilst trying to drop user
objects in the database and cannot be dropped. I have done the usual thing such as cheecking that ...Answered | 8 Replies | 7993 Views | Created by MrFlinstone - Friday, December 30, 2011 7:21 PM | Last reply by MrFlinstone - Thursday, January 5, 2012 10:39 AM -
2 Votes
the database principal owns a service in the database -- can't drop a user
Thanks Nimit, I tried this, and the service name is SqlQueryNotificationService, with a guid at the end of the name. I ...Answered | 9 Replies | 22547 Views | Created by jhcorey - Monday, June 21, 2010 7:10 PM | Last reply by Erland Sommarskog - Tuesday, August 6, 2019 9:26 PM -
0 Votes
SQL 2008 R2 restored DB to new server: "The database principal owns a schema in the database, and cannot be dropped. (.Net SqlClient Data Provider)"
For 'SQL Login' you may have to create both the login if it is missing @ Server Security and run the SID mismatch script against each database that has ...Answered | 5 Replies | 1593 Views | Created by scogordo - Wednesday, September 3, 2014 9:36 PM | Last reply by bhanu_nz - Thursday, September 4, 2014 10:16 PM -
0 Votes
SQL Express 2008 (the database principal owns a schema in the database, and cannot be dropped (microsoft sql server error 15138))
the database, and cannot be dropped. (.Net SqlClient Data Provider) ------------------------------ For help, click:Answered | 1 Replies | 10034 Views | Created by armtav newbie - Friday, February 12, 2010 3:26 PM | Last reply by VS Patel - Friday, February 12, 2010 3:44 PM -
0 Votes
Can't Drop User - "The server principal owns one or more endpoints and cannot be dropped"
Endpoints>Service Broker and I see ConfigMgrEndpoint. Right click ConfigMgrEndpoint>Answered | 4 Replies | 9068 Views | Created by John Marcum - Tuesday, April 30, 2013 12:50 PM | Last reply by Andrew Bainbridge - Tuesday, April 30, 2013 4:01 PM -
0 Votes
The database principal has granted or denied permissions to objects in the database and cannot be dropped
Hi All, I'm having an issue removing an account from a database. I get the following error: The ...Answered | 2 Replies | 1148 Views | Created by maksoy2099 - Thursday, September 14, 2017 2:48 PM | Last reply by Erland Sommarskog - Thursday, September 14, 2017 9:26 PM -
2 Votes
Msg 15138, Level 16, State 1, Line 4 The database principal owns a schema in the database, and cannot be dropped.
Msg 15023, Level 16, State 1, Line 1 User, group, or role 'mgr' already exists in the current database. I cannot drop the user ...Answered | 6 Replies | 11278 Views | Created by mwelizeb - Tuesday, January 3, 2012 11:11 PM | Last reply by mwelizeb - Wednesday, February 22, 2012 8:34 PM -
0 Votes
Cannot execute as the database principal
& pwd and you get the same "Cannot execute as the database principal because the principal does not exist, ...Answered | 3 Replies | 754 Views | Created by TogaRudy - Tuesday, October 4, 2016 1:20 PM | Last reply by TogaRudy - Wednesday, October 5, 2016 1:22 PM -
0 Votes
Cannot execute as the database principal
" does not exist, this type of principal cannot be impersonated, or you do not have permission. We have two different instances of MSSQL. Each ...Answered | 2 Replies | 2007 Views | Created by CPU Hound - Friday, November 15, 2013 5:57 AM | Last reply by CPU Hound - Friday, November 15, 2013 3:49 PM - Items 1 to 20 of 3027275 Next ›
No announcements
