Link to home
Start Free TrialLog in
Avatar of jsyers
jsyers

asked on

Drop failed for User 'VRN\kaluk'. (Microsoft.SqlServer.Smo)

How do you drop this user, 'VRN\kaluk'?

Error list below:



Drop failed for User 'VRN\kaluk'.  (Microsoft.SqlServer.Smo)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Drop+User&LinkId=20476

------------------------------
Program Location:

   at Microsoft.SqlServer.Management.Smo.SqlSmoObject.DropImpl()
   at Microsoft.SqlServer.Management.Smo.User.Drop()
   at Microsoft.SqlServer.Management.SqlManagerUI.DropObjects.DoDropObject(Int32 objectRowIndex)
   at Microsoft.SqlServer.Management.SqlManagerUI.DropObjects.DropAllObjects(Boolean stopOnError)

===================================
TITLE: Microsoft SQL Server Management Studio
------------------------------

Drop failed for User 'VRN\kaluk'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Drop+User&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

The database principal owns an assembly and cannot be dropped. (Microsoft SQL Server, Error: 15154)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3068&EvtSrc=MSSQLServer&EvtID=15154&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------







An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------
Program Location:

   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
   at Microsoft.SqlServer.Management.Smo.ExecutionManager.ExecuteNonQuery(StringCollection queries)
   at Microsoft.SqlServer.Management.Smo.SqlSmoObject.ExecuteNonQuery(StringCollection queries, Boolean includeDbContext)
   at Microsoft.SqlServer.Management.Smo.SqlSmoObject.DropImplWorker(Urn& urn)
   at Microsoft.SqlServer.Management.Smo.SqlSmoObject.DropImpl()

===================================

The database principal owns an assembly and cannot be dropped. (.Net SqlClient Data Provider)

------------------------------
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3068&EvtSrc=MSSQLServer&EvtID=15154&LinkId=20476

------------------------------
Server Name: dv01
Error Number: 15154
Severity: 16
State: 1
Line Number: 2


------------------------------
Program Location:

   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)
   at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
   at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
   at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
ASKER CERTIFIED SOLUTION
Avatar of inter
inter
Flag of Türkiye image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jsyers
jsyers

ASKER

Hello:
Here is what I get:
SchemaName       SchemaName
dbo                            dbo
guest                            guest
INFORMATION_SCHEMA       INFORMATION_SCHEMA
sys                            sys
PowerCerv                            PowerCerv
VRN\saines                            VRN\aines
VRN\web                            VRN\web
VRN\fman                            VRN\fman
VRN\kaluk                            VRN\kaluk
VRN\nsky                           VRN\nsky
VRN\csek                           VRN\csek
db_owner                           db_owner
db_accessadmin      db_accessadmin
db_securityadmin      db_securityadmin
db_ddladmin                           db_ddladmin
db_backupoperator      db_backupoperator
db_datareader      db_datareader
db_datawriter      db_datawriter
db_denydatareader      db_denydatareader
db_denydatawriter      db_denydatawriter
Standard User      Standard User