Hot answers tagged

6

The resolution to this issue was enabling service broker on the database as so. ALTER DATABASE [Database_name] SET NEW_BROKER WITH ROLLBACK IMMEDIATE; After enabling service broker for the database, drop users were practically instantaneous. Kin asked if the service broker was enabled in a previous comment which sent me searching in the right direction.


3

this is not an answer to the question but an argument to dismiss it altogether. If I understand correctly your comment: Within the context of refreshing DEV databases from production, I have to drop and recreate all database users. So yes dropping the database users and recreating them is necessary. your goal is to copy production data onto a dev ...


1

For best practices on SQL Server security there are hundreds of pages of documentation from the DoD ("Security Installation Checklist" and "Security Checklist") and CIS ("SQL Server Security Benchmark"). This aside a more realistic approach is rooted in common sense. Your firewall should only allow access from the specific IPs in the DMZ only directly to ...



Only top voted, non community-wiki answers of a minimum length are eligible