Category: SQL
Apr
03
New SQL management pack released
SCOM, SQL, System Center, Active Directory, SCOM 2012 Send feedback »Yesterday a new version of the SQL management pack for SCOM was released. Yes we are now on a roll with releasing new stuff! The fresh version of the SQL mp is now 6.3.173.0.
The new version supports also monitoring of SQL 2012 now and will work for SC… more »
Sep
30
ReportServer application pool stopped with unspecified error and keeps crashing giving 1057 and 1059 errors
SCOM, SQL, Active Directory Send feedback »Today ran into a SCOM Report Server that would not load correctly on a Windows 2003 with SQL 2005 version.
This also gives an error in SCOM console as follows:
Data Warehouse failed to request a list of management packs from SQL RS server..
And in t… more »
Sep
08
This is an old one as well, but we still see it happening (including in my case). Actually these are two cases.
First had an 404 error when I opened the SCOM Web Console for the first time. Well this links back directly to my previous post where the… more »
Sep
08
Had a small issue with SQL 2005 Reporting Services on Windows 2003 R2 in a quick quick test environment I was setting up for SCOM. When trying to open http://servername/reports I got an error "HTTP Error 404 - File or Directory not found". I knew I had… more »
Dec
20
One nice gem from Steve Rachui's blog is a trick on how to simply troubleshoot remote SQL connections.
Just create an empty txt file anywhere on the disk and give it an UDL extension and click it. You will see a tool popping up with several tabs. on t… more »
Dec
20
SQL Server 2005 Service Pack 4 has just been released a few days ago.
You can download files here:
The SQL 2005 SP4 Readme file
Download SQLServer2005SP4-KB2463332-x64-ENU.exe for X64
Download SQLServer2005SP4-KB2463332-x86-ENU.exe for X86
Downloa… more »
Nov
28
I get asked a lot for performance reporting for large groups of servers (with changing memberships). The problem that people face with this is that it usually involves an initial very big list of machines and it takes a lot of time to build this. Also if… more »
Jun
22
The SQL 2008 R2 Best Practises Analyzer (BPA) has been released and can be downloaded follwing this link:
http://www.microsoft.com/downloads/details.aspx?displaylang=en&FamilyID=0fd439d7-4bff-4df7-a52f-9a1be8725591
This BPA works with both SQL 20… more »
Apr
21
Microsoft just announced the RTM of SQL Server 2008 R2.
Read more about it over here at the MS press pass.
We will be able to use it in a few weeks time. more »
Mar
22
While installing a SQL 2005 Reporting Services on a Windows 2003 machine today I got the following error:--------------------------------------------------------------------------------The XML page cannot be displayed Cannot view XML… more »
XML Feeds
