SQL Server 2019 user is dropped from database but error log says couldn't remove

sai prabhu 0 Reputation points
2023-05-05T13:20:16.8433333+00:00

Hello All, I have SQL Server 2019. I have dropped an user from the database but there was below message in error log.

"Couldn't remove the user (n) from database (n) from the external libraries folder, error: 0x80070003".

I haven't seen this earlier. Appreciate your help. Thank you n advance.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,677 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 100.9K Reputation points MVP
    2023-05-05T21:41:22.88+00:00

    Fir the error message suggest that you have been using the command CREATE EXTERNAL LIBRARY in the database. I wold expect the statement SELECT *FROM sys.external_libraries to return at least one row.

    But this external library may not be in best shape, since the error code 0x80070003 is the error The system cannot find the path specified. Then again, if the folder is gone, the error is sort of benign. (Although, if you actually try to use the external languages, you are likely to get problems.)