Just a Reminder

Tuesday, October 18, 2011

Could not load file or assembly 'Microsoft.SqlServer.Sqm ...

When you try to run SQL 2008 Management Studio on Windows 2008 R2 x64 you receive this error:

Microsoft SQL Server Management Studio
Cannot show requested dialog.

Could not load file or assembly 'Microsoft.SqlServer.Sqm, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' or one of its dependencies. The module was expected to contain an assembly manifest. (SqlMgmt)

Solution:

Copy the file Microsoft.SqlServer.Sqm.dll located on
C:\Program Files\Microsoft SQL Server\100\Shared to folder
C:\Program Files\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE and
C:\Program Files (x86)\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE.

Wednesday, March 9, 2011

Find Objects In Active Directory

My Network Places -> Network Tasks: Search Active Directory.
or
from command line rundll32 dsquery,OpenQueryWindow.

Active Directory Schema snap-in

Notice that the Active Directory Schema snap-in is not available to add. The Active Directory

Schema snap-in is installed with the Active Directory Domain Services role with the

RSAT, but it is not registered, so it does not appear.

At the command prompt, type the regsvr32.exe schmmgmt.dll command.

Monday, February 28, 2011

Hidden command prompt in Windows Server 2008 installation

One reason why Windows Server 2008’s install is easy to use is because it is based on a MINWINPC (Mini PC) bootable environment, similar to the Windows PE environment. This means that a number of environment tools are available to the installation environment. Once the Windows manager is loaded, you can access this command prompt by pressing [Shift][F10].

Net Helpmsg for Windows Error 0xABCDEFGH

Suppose you get error 0x80070652 from an installer:

>net helpmsg 0x80070652
The syntax of this command is:
NET HELPMSG message#

It doesn’t support hex. You need to take the last 4 digits "0652" from 0x80070652, convert it to decimal "1618" and:
C:\>net helpmsg 1618
Another installation is already in progress. Complete that installation before proceeding with this install.

Friday, February 25, 2011

Reload, Transfer or Reload from Master DNS secondary zone?

Often confusion arises when manually updating the DNS zone.
Reload, Transfer From Master or Reload from Master - what to choose?
Open the book "MCTS Exam 70-642: Cinfiguring Windows 2008 Network Infrastructure" on the page 201 and carefully read the following:
"...
Manaully Updating a Secondary Zone
...

Reload This operation reloads the secondary zone from local storage.
Transfer From Master The server hosting the local secondary zone determines whether the serial number in the secondary zone's SOA resource record has expired and then pulls a zone transfer from the master server.
Reload From Master This operation performs a zone transfer from the secondary zone's master server regardless of the serial number in the seconadry zone's SOA resource record.

..."