Tuesday, September 18, 2012

Excel Services Application event 2026

When trying to run any BI sample report in Project Server 2010, the report gets stuck on loading the following event is logged

Log Name:      Application
Source:        Microsoft-SharePoint Products-Excel Services Application
Date:          9/18/2012 12:01:23 PM
Event ID:      2026
Task Category: Excel Calculation Services
Level:         Warning
Keywords:     
User:         
Computer:     
Description:
An internal error occurred.
   at Microsoft.Office.Excel.Server.MossHost.MossHost.Microsoft.Office.Excel.Server.Host.IEwaHost.IsSecureConnection()
   at Microsoft.Office.Excel.WebUI.EwaCUIDataSource.EnsureDocument()
   at Microsoft.Web.CommandUI.CUIDataSource.RunQuery(UIQuery query)
   at Microsoft.Office.Excel.WebUI.EwaRibbon.QueryRibbonDataSource(CultureInfo uiCulture, String clientID, Boolean denormalizeImareUri)
   at Microsoft.Office.Excel.WebUI.EwaStringsHandler.ProcessRequest(HttpContext context)

This error occured because there was no site collection created at the root of the web application, creating a blank site collection fixed the problem.

Also a hotfix is available http://support.microsoft.com/kb/2596582

Monday, September 3, 2012

Rule "Network binding order" generated a warning

While installing an SQL failover cluster, the system checks generate this warning

Rule "Network binding order" generated a warning
The domain network is not the first bound network. This will cause domain operations to run slowly and can cause timeouts that result in failures. Use the Windows network advanced configuration to change the binding order.


First thing to check is the binding order from Network Connections -> Advanced -> Advanced Settings and place the domain network on top


If it was already on top then check for hidden NICs, see Finding and deleting non present devices in Windows Server

If that did not solve the problem either, then it is probably the Microsoft Failover Cluster Virtual Adapter. This happened to me when I configured the cluster while the domain network was not the top one.

Run this command to get the NICs IDs

wmic nicconfig get description, SettingID

Then place the domain NIC on top by editing the following registry key

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\services\Tcpip\Linkage\Bind

Sunday, September 2, 2012

Microsoft ACPI-Compliant Power Meter Device unsigned driver

Windows 2008 R2 cluster validation wizard reports a System Configuration warning about an unsigned driver: Microsoft ACPI-Compliant Power Meter Device. Driver Name: Value Not Found




The problem was missing files acpipmi.ini and acpipmi.pnf from the Windows\inf directory. It seems the files have been deleted after installing EMC PowerPath. So back them up before installing PowerPath or if you have already installed it copy them from another similar Windows 2008 R2 installation.

Cannot rename this connection. A connection with the name you specified already exists

If you replace a network card or move it to a different slot, the old one does not get deleted it only becomes a hidden device. This can happen also if you remove a network adapter from a virtual machine. So if you try to rename a connection to the name of that hidden one you will get this error message:


Error Renaming Connection
Cannot rename this connection. A connection with the name you specified already exists. Specify a different name.

To delete the hidden NIC, launch a command prompt and set this environment variable

set devmgr_show_nonpresent_devices=1

then run the device manager devmgmt.msc


From the view menu, check: Show hidden devices



under the network adapters, you will find more devices have appeared, remove the old NIC but DO NOT delete the driver unless you are sure you do not need it.

Now you can rename the connection.

Wednesday, June 20, 2012

Moving tempdb on SQL 2008 R2

Moving tempdb to a new location:

1) Connect to the SQL server and run this query:
USE master
ALTER DATABASE tempdb MODIFY FILE (NAME = tempdev, FILENAME = '[new path]\tempdb.mdf');GO
ALTER DATABASE tempdb MODIFY FILE (NAME = templog, FILENAME = '[new path]\templog.ldf');GO


2) Stop the SQL service
3) Move tempdb.mdf and templog.ldf to the new location
4) Start the SQL Service

Tuesday, June 19, 2012

Using Microsoft SQL Report Builder 3 to create custom SCOM 2007 R2 reports

In SCOM 2007 R2 if you click "Design a new report" from the Reporting tab you will notice that Report Builder version 1 runs, even if you have version 3 installed because SCOM still opens the old link.
To use 3 instead navigate to the C:\Program Files\Microsoft SQL Server\MSRS10_50.SCOM\Reporting Services\ReportServer\ReportBuilder


Make a copy of "ReportBuilder_3_0_0_0.application"


Rename "ReportBuilder.application"


Rename the copy of version 3 to "ReportBuilder.application"


Now when you "Design a new report", SCOM will run Report Builder 3.