Posts Tagged ‘Windows Server 2008’

No tool like an old tool

March 7th, 2012 No comments

Administration Tools Pack gets a refresh

and Server Administration Tools

Another eNerd called me yesterday wondering how to let a non-admin user at his client’s business have access to their virtualized server. The hope was to have the vSphere Client locked down in some way.

When I asked what the user needed to do, it was “Manage users and reset passwords and such.”  I realized then that this was not a VMware access issue at all, but a Windows Server rights issue.

In fact, this can readily be handled by the Microsoft Management Console (MMC) which can be installed on the user’s workstation – no need to give the user login to the Windows or VMware server at all.

This is not a new trick by any means, but is one worth remembering.

Also, I’ll add that there is now a version for Windows 7 (Win7) and Vista, in both 32 and 64 bit flavors. (Sorry, they don’t let this run on “Home” editions of Windows.)  The following give some details.

There are many places where you can get detailed help on using MMC such as this post:
Here’s just a bit then about getting started with the “new” version.

    1. In Windows 7, click on the start button, and type “mmc” (Win7 will find the MS Management Console) and press enter. It will create a blank console called Console1. Click on “File”, “Add/Remove Snap In…” and you’ll see NO snap-ins for AD user management. Close MMC and let’s go get that snap-in.
    2. Download and run the Remote Server Administration Tools for Windows 7 (32 and 64 bit) is at:
A help screen should open to give you further assistance.

  1. Basically, after installation, you access Programs and Features from the Control Panel, click on “Turn Windows features on or off”, and expand Remote Server Administration Tools to reveal all the tools.
  2. For the case mentioned, to obtain access to Active Directory Users and Computers (for password and other user information), I drilled down into Role Administration Tools until I found “AD DS Snap-ins and Command-line Tools”. Check it and click OK
  3. Back to Win7, click on the start button, and type “mmc” and press enter. It will create a blank console called Console1. Click on “File”, “Add/Remove Snap In…” and you’ll see one for Active Directory Users and Computers. Click Add-> and OK and you’ll have your Management Console well on it’s way.

See the TechNet article for additional steps such as linking it to the Domain Controller, Saving the Console, etc..

Microsoft SQL on Windows Server 2008 and Firewall Settings

February 3rd, 2011 No comments

When installing SQL on windows Server 2008, the firewall is not automatically setup to allow access to the default SQL ports which are as follows:

SQL Server Ports
  1. Default instance port TCP 1433
  2. Dedicated Admin Connection port TCP 1434
  3. SQL Server Service Broker port TCP 4022
  4. Transact-SQL Debugger/RPC port TCP 135
Analysis Service Ports
  1. SSAS Default Instance port TCP 2383
  2. SQL Server Browser Service port TCP 2382
Miscellaneous Ports
  1. HTTP port TCP 80
  2. SSL port TCP 443
  3. SQL Server Browser Service‘s Port TCP 1434
  4. You also need to Allowing multicast broadcast response on UDP

Instead of adding each of these rules one by one you can create a batch file and run it in a cmd prompt.

Read more…

How to copy folders and keep NTFS and Share Permissions

February 3rd, 2011 2 comments

I have a client that has created a template folder structure for their client files that has the required permissions set up on them.

What the client wants to do is copy this template structure to a new folder whenever they get another client and keep the folder security that they have applied to their template folder structure.

And here is how it can be done.

Read more…