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...

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...

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...

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...

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...

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. ...

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...

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...

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...

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...

· 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...

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...

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...

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...