Sql-server – way remove SQL Server listener IP on maintenance

clusteringsql serversql server 2014windows

Is there a any way to stop listening listener on the SQL Server on production server. I want to be sure nobody is trying to connect my production server when it is maintenance mode.

I disabled all users when they have permissions to connect any database. I am sure nobodys can connect any database on that server. But i don't want to be busy my network traffic from any services or application or user while it is on maintenance. So i want to delete Listeners IP to that server.

My possible actions are listed

  1. I can delete listener on SQL Server or Listener resource on WSFC.
  2. I can delete Ip of listener on the listener on SQL Server.

Best Answer

better approach than deactivating all listeners is to set your instance in single user mode. Single user mode is recommended for maintenance work and dont allow normal users to connect to the instance. you do not need to change any listeners and permissions on your database. Check this msdn page.