Welcome to SqlServer-QA.net Sign in | Join | Help

SQL Server Storage Engine & Tools (SSQA.net)

SQL Server Tools includes storage engine that includes a complete set of graphical tools and command prompt utilities that allow users, programmers, and administrators. SSMS, SSRS, SSIS & SSAS are most commonly used tools.

Browse by Tags

All Tags » service » sql server   (RSS)
The SQL server specified in SSIS service configuration is not present or is not available. This might occur where there is no default instance of SQL Server on the computer
Multiple versions of SQL Server installation is quite common when your enterprise is looking forward to upgrade to latest versions of SQL Server, in this regard recently one of the Application user reported a problem with regard to SSIS & DTS services Read More...
Posted: Monday, March 03, 2008 1:02 AM by SQL Master | 3 Comments
Filed under: , , , , , , , , ,
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."
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 issues and Read More...
Posted: Wednesday, September 26, 2007 3:27 AM by SQL Master | 2 Comments
Filed under: , , , , , , , ,
Alert when a specific SQL instance service has been started
One of the IT support team member asked me the question " Is there a way to have SQL Server 2005 send some sort of email notification when it starts up? " The solution is straight forward and yes you can have such alerts or notifications based upon the Read More...
Posted: Monday, June 11, 2007 2:55 AM by SQL Master | 1 Comments
Filed under: , , , ,
Best practices for Domain Account for SQL Server services
For every DBA this is a big question about performing or following best practices to apply on domain account for SQL Server services. I've done some searching, but have found no definite answer yet. We have a various setup of SQL farm with in our environment Read More...
Posted: Wednesday, March 28, 2007 1:52 AM by SQL Master | 3 Comments
Filed under: , , ,