Welcome to MSDN Blogs Sign in | Join | Help

April 2009 - Posts

Monday, April 27, 2009 11:59 AM

Report generation crashes with error code: 0x080004005

Recently we were troubleshooting a Reporting Services 2008 issue. After the report was edited at some point in time, the report was not getting generated and the only clue we had was this error code: 0x080004005. However there was no other recorded incident
Posted by John Daskalakis | 7 Comments
Thursday, April 23, 2009 11:13 AM

SQL Server Reporting Services gives error "Unable to load client print control"

If you deal with SQL Reporting Services in your daily work, there is a big possibility chance that you will encounter this error when you try to print a report. It has more than a few possible causes: 1. At first you should take a look at this KB article:
Posted by John Daskalakis | 11 Comments
Wednesday, April 22, 2009 2:34 PM

How to optimize the Memory configuration of SQL Server 2008

Sometimes configuring the Memory settings of a SQL Server is complicated, especially if you are not familiar with certain terms and abbreviations. So let’s shed some light on memory tuning: - How much memory does the Operating System use by default? By
Posted by John Daskalakis | 4 Comments
Tuesday, April 21, 2009 3:14 PM

Can the “Lock Pages in Memory” privilege create problems in SQL Server?

Under certain circumstances, the “Lock Pages in Memory” privilege can create problems in SQL Server. Usually it is recommended to give this permission to the SQL Server service account, especially if you notice memory trimming error messages in the SQL
Posted by John Daskalakis | 2 Comments
Wednesday, April 15, 2009 9:04 AM

Test connection failed because of an error in setting the window handle property

Consider this scenario: - You have built a SQL Server 2005 Analysis Services 32-bit box. - You then build a SQL Server 2005 Analysis Services 64-bit box. - You create a UDL file to test the connection between the two boxes. - When you test the connection,
Posted by John Daskalakis | 1 Comments
Tuesday, April 14, 2009 12:59 PM

Why can a Windows 2008 cluster see the RAID-1 disks, but not the RAID-5 disks?

Recently I was involved in troubleshooting a Windows 2008 Core cluster using a 3 rd party Storage Area Network (SAN). - The Windows 2008 core cluster was built remotely using the graphical user interface (GUI) of another Windows 2008 machine. - In order
Posted by John Daskalakis | 2 Comments
Monday, April 13, 2009 11:01 AM

Microsoft Office Excel crashes with error 00037efb

Consider this scenario: You have installed Microsoft Office 2003 or 2007. It is working without any problems for some days and then it starts to crash with error offset 00037efb. The crash usually occurs whenever you try to open a file. This specific
Posted by John Daskalakis | 1 Comments
Monday, April 13, 2009 10:26 AM

IIS sites, ports, certificates and SSL?

Consider this scenario: - You have setup more than one IIS sites. - Each of these sites listens to the same IP:Port combination. - You want each of these sites to use a specific certificate, different for each site. - You have enabled SSL for all sites.
Posted by John Daskalakis | 0 Comments
Tuesday, April 07, 2009 11:44 AM

You get error code 0x80090016 whenever you attempt to create a new Scheduled Task on a Windows 2003 machine

Consider this scenario. You get errors like this whenever you attempt to create a new Scheduled Task on a Windows 2003 machine: ERROR 1: “The new task has been created, but may not run because the account information could not be set. The specific error
Posted by John Daskalakis | 1 Comments
Tuesday, April 07, 2009 8:49 AM

Q & A regarding the migration of applications to .NET 3.5

Consider this scenario: - You have setup IIS servers in your environment - You have applications running.Net 1.0 and 2.0 - You are thinking of migrating to .Net 3.5 So some questions that arise are: 1. Will the current running applications be affected
Posted by John Daskalakis | 3 Comments
Monday, April 06, 2009 1:00 PM

How to move the WSUS database to a different SQL Server

· At first ensure that the “nested triggers” option is enabled on the new SQL Server: o Go to “Enterprise Manager”, right click on the new SQL Server and choose “Properties”. o In the “Server settings” tab, the option: “Allow triggers to be fired which
Posted by John Daskalakis | 2 Comments
Monday, April 06, 2009 10:26 AM

How to troubleshoot the “Loading Grid” Project 2007 hang issue

Sometimes when a user tries to logon to Project 2007, he is stuck at the “Loading Grid” screen. Usually a user gets stuck in the “Loading Grid” splash screen if the ActiveX Controls cannot be downloaded, e.g. - The user does not have the correct permissions.
Posted by John Daskalakis | 1 Comments
Friday, April 03, 2009 1:44 PM

MSDTC does not appear to be working when the SQL resource resides on a different node than the MSDTC resource

On a Windows 2003 Cluster, MSDTC must be configured as a clustered resource as described in this KB article: How to configure Microsoft Distributed Transaction Coordinator on a Windows Server 2003 cluster http://support.microsoft.com/kb/301600 On the
Posted by John Daskalakis | 1 Comments
Filed under:
Wednesday, April 01, 2009 11:59 AM

SQL Server - Memory Trimming

You might have seen these two messages logged in the SQL Server ERRORLOG files: - Cannot use Large Page Extensions: lock memory privilege was not granted. - A significant part of sql server process memory has been paged out. This may result in a performance
Posted by John Daskalakis | 2 Comments
 
Page view tracker