http://blogs.msdn.com/b/sqlserverfaq/archive/2012/12/18/how-to-limit-connections-to-sql-server-until-all-databases-are-online.aspxStrange requirement, right? Recently, I got a peculiar case wherein the demand made by the customer was to make sure no application should be able to connect to SQL Server unless and until all the databases are ONLINE. The business requirement of thisen-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/sqlserverfaq/archive/2012/12/18/how-to-limit-connections-to-sql-server-until-all-databases-are-online.aspx#10379727Thu, 20 Dec 2012 11:49:14 GMT91d46819-8472-40ad-a661-2c78acb4018c:10379727Sumit Sarabhai<p>Thanks for your comments. </p> <p>@Stisse: I haven&#39;t tested it on Win 2012\SQL 2012. However, I will check this out and let you know.</p> <p>@Szymon: I didnt&#39;t thought of this scenario. Obviously, you need to make relevant modifications to the trigger code to exclude Mirror database.</p> <p>@Pedro: There is no reason for not using the code that you have provided :) I just used a simplest scenario to write this blog. You may want to change the code as per your requirement.</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10379727" width="1" height="1">http://blogs.msdn.com/b/sqlserverfaq/archive/2012/12/18/how-to-limit-connections-to-sql-server-until-all-databases-are-online.aspx#10379445Wed, 19 Dec 2012 14:48:46 GMT91d46819-8472-40ad-a661-2c78acb4018c:10379445Pedro Lopes<p>Correction: I meant (...) WHERE state = 2 OR state = 3 (...)</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10379445" width="1" height="1">http://blogs.msdn.com/b/sqlserverfaq/archive/2012/12/18/how-to-limit-connections-to-sql-server-until-all-databases-are-online.aspx#10379385Wed, 19 Dec 2012 11:15:30 GMT91d46819-8472-40ad-a661-2c78acb4018c:10379385Pedro Lopes<p>Hi Sumit,</p> <p>Good post. Any reason you didn&#39;t validate just something like (...) WHERE state != 2 OR state != 3 (...)?</p> <p>Thanks</p> <p>PL</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10379385" width="1" height="1">http://blogs.msdn.com/b/sqlserverfaq/archive/2012/12/18/how-to-limit-connections-to-sql-server-until-all-databases-are-online.aspx#10379373Wed, 19 Dec 2012 10:35:14 GMT91d46819-8472-40ad-a661-2c78acb4018c:10379373Szymon Wojcik<p>What about databases which are mirrored? They have state = 1 in sys.databases, so in this example you won&#39;t be able to log in if your server contains a mirror database.</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10379373" width="1" height="1">http://blogs.msdn.com/b/sqlserverfaq/archive/2012/12/18/how-to-limit-connections-to-sql-server-until-all-databases-are-online.aspx#10379004Tue, 18 Dec 2012 12:06:53 GMT91d46819-8472-40ad-a661-2c78acb4018c:10379004Stisse Twardy<p>Hi</p> <p>It is very interesting article, but how I should create such solution using Windows 2012 Cluster and SQL2012 in Cluster?</p> <div style="clear:both;"></div><img src="http://blogs.msdn.com/aggbug.aspx?PostID=10379004" width="1" height="1">