Category Archives: Microsoft

Microsoft SQL Server

A WMI error has occurred and no additional error information is available

This can happen when you have different versions installed. For example, if you install SQL Server 2005 SP3 and later, and only then install the Reporting Services.

In this situation it should be rerun after the SP3 installation of Reporting Services

Microsoft Networking

Installing GPMC on Windows Server 2008 and Windows Vista Service Pack 1

The Group Policy Management Console is included in Windows Server 2008; however, you must install it before you can use it. The domain controller promotion process installs GPMC on the server, in addition to adding the domain controller to the domain. Additionally, you can install GPMC on a member server as long as it’s a member of the domain. Let’s look at two ways to install GPMC on Windows Server 2008 (other than through DCPROMO).

Installing GPMC using Server Manager (Windows Server 2008)

The Group Policy Management Console is a Feature in Windows Server 2008. You install Features using Server Manager. Once installed, you can access the feature using Server Manager or you can the specific management console (like gpmc.msc).

read more »

SQL Server Transact-SQL

SQL collations

Query:

select * from fn_helpcollations()
where name like ‘%SQL_Latin1_General_CP1_CI_AS%’
or name = ‘Latin1_General_CI_AS’
or name like ‘%cp1%’

Query result:

read more »

Outlook Tips & tricks

How to clear Outlook Contact history (auto display after TO:)

Short answer: Delete your NK2 file.

Slightly longer answer: In the C:\Documents and Settings\<user

name>\Application Data\Microsoft\Outlook directory there should be a file

with an NK2 extension. Deleting it should clear the auto-suggestion cache.

.NET ASP.Net Microsoft

ASP.NET Charting Control

Scott Gu blogged about the the free Microsoft Chart Controls for Microsoft .NET 3.5.

Microsoft recently released a cool new ASP.NET server control – <asp:chart /> – that can be used for free with ASP.NET 3.5 to enable rich browser-based charting scenarios:

Once installed the <asp:chart/> control shows up under the “Data” tab on the Toolbox, and can be easily declared on any ASP.NET page as a standard server control:

read more »

IIS Microsoft

IIS returns HTTP 404 for Office 2007 file downloads

This is kind of an old issue, but since I mostly work on corporate projects, we’re a bit slow on adopting new versions of anything.
I ran into this issue with Microsoft Word 2007 documents, but the same error will occur with any other file type that isn’t properly configured on the web server.

Symptoms
Microsoft Word 2007 documents return a HTTP 404 error when users attempt to download the documents. The web server uses Microsoft IIS 6.0.

Cause
IIS does not have a wildcard mapping for unknown MIME types and the file type is not known to the web server. This prevents IIS 6.0 to serve the file.

Resolution

To resolve the errors, add the missing MIME types to IIS.
Instructions

1. Open IIS Management Console (via Computer Manager->Services and Applications->Internet Information Service)
2. Right click on “Web Sites”.
3. Choose Properties
4. Activate “HTTP Headers” tab
5. Click “File Types” button in the MIME Map groupbox
6. Click “New Type”
7. Enter the MIME type data from the below table

Associated
Extension
Content type (MIME)
(remove any spaces below)
docx application/vnd.openxmlformats- officedocument.wordprocessingml.document
pptx application/vnd.openxmlformats- officedocument.presentationml.presentation
xlsx application/vnd.openxmlformats- officedocument.spreadsheetml.sheet
Hyper-V Microsoft

Hyper-V Licensing Explained!

I’ve spoken to a lot of people who have expressed a lot of confusion about the OS licensing model when virtualizing systems using Hyper-V products.

There are some simple guidelines to observe when planning your Hyper-V infrastructure to take advantage of the licensing models for each edition of Windows Server 2008.

First, a term definition: Microsoft uses the term “OSE” to refer to an operating system environment, either physical or virtual. Also, Microsoft refers to a “processor” in the context of a single processor socket on the motherboard. This calculation is not affected when considering multiple core processors or hyper-threading capabilities on certain processor types.

posted in: http://msmvps.com/blogs/virtualreality

read more »

Microsoft Security

Antivírus gratuito da Microsoft disponível em português

A Microsoft Portugal lançou hoje a versão portuguesa do Microsoft Security Essentials, uma solução gratuita de segurança para os computadores pessoais dos utilizadores do sistema operativo Windows.

Este antivírus está disponível a partir de hoje para download gratuito na página do produto e oferece aos utilizadores de tecnologia Microsoft uma protecção contra vírus, spyware e outros tipos de software malicioso, sendo compatível com os sistemas operativos Windows XP, Windows Vista e Windows 7.

security-essentials

homepage: www.microsoft.com/security_essentials

read more »

Windows server

Windows Server 2008 Workstation Converter

Convert Windows Server 2008 to Workstation Manual

If you don’t want to configure all options to convert Windows Server 2008 to a Workstation manually, sawo now made it possible to use a tool for this. He has done a great job by creating this converter to automate all steps of the manual!

Get the Windows Server 2008 Workstation Converter

  • Download Serv08Convert12.zip (13.2MB)
  • View previous versions.

http://converter.win2008workstation.com/

read more »

Microsoft

Visual Studio 2010 and .NET Framework 4 Release Candidate

Visual Studio 2010 is an integrated development environment that simplifies the entire development lifecycle, from design to deployment.

available on MSDN