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   (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: , , , , , , , ,
Page number issue in the Reporting Services
I have been pestered by the Developers asking about feature of Page Numbering in Reporting Services. So far there is not direct way to accomplish this, because reports are not physically paginated until you use print preview (or export to a physical page Read More...
Posted: Wednesday, June 13, 2007 7:24 AM by SQL Master | 0 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: , , ,
SQL Server 2005 Service Pack 2a?
With the latest release of SP2 Update release it has been a rumour in the community that it is a SP2a release, which I believe not as it is intended to fix a particular issue with cleanup tasks and maintenance plans. As the remaining tasks with Service Read More...
Posted: Saturday, March 17, 2007 9:40 AM by SQL Master | 0 Comments
Filed under: , , , ,
Server Virtualization, is this a part of consolidation?
Well this was my first question when my manager asked me about shall we look at Server Virtualization. When evaluating file virtualization solutions, you must consider how you plan to use virtualization initially, as well as how it fits into the infrastructure Read More...
Posted: Sunday, March 11, 2007 10:38 AM by SQL Master | 0 Comments
Filed under: , ,