Browse by Tags

Could not connect because the maximum number of '1' user connections has already been reached. The system administrator can use sp_configure to increase the maximum value. The connection has been closed."

Published 26 September 7 5:27 AM | SSQA.net

The above error is obvious when you have setup the SQL Server instance to accept only 1 connection. The default setting for number of user connections is '0' which accepts unlimited connections. With similar settings one of my friend have had...

Filed under: sql server, anti-virus, connections, service, recovery, tcp, restart, maximum, sp_configure

SQL Server 2005 Maintenance Plan not deleting old backups

Published 7 September 7 3:21 AM | SSQA.net

If you take into account of most Frequently Asked Questions in any SQL community forums, you will get to see problems against database maintenance plans by the users. Personally I don't like them to use (by default) and professionally always depend...

Filed under: sql server, backup, maintenance plan, database, anti-virus, service pack2, directory, exclude

Anti-virus tool on SQL Server

Published 18 May 7 9:33 AM | SSQA.net

Another common question in the forums asking about what are the best practices for using antivirus software on servers running SQL Server. In my experience if your SQL Server is not a internet-faced one then no need to have one installed on a SQL Server...

Filed under: sql server, management, microsoft, ssis, security, ssas, ssms, ssrs, search, anti-virus, kba