Tuesday, June 12, 2012

3 Connect DC as Local user

I have VM with Windows Server 2008 R2 Server Core installed. I have add this VM as Domain Controller. Being GUI less make it difficult to perform some task sometimes. Therefore I like to connect to the VM via RSAT.

If my workstation is part of domain , then there should not be any issue. However, my workstation is the parent of  VM which is not part of domain. I have to figure the way to do this.

It turns out it is not that difficult.

1. Create the local user on the DC and add the user as member of the administrators group

net user /add USER1 *
net localgroup administrators /add USER1

2.  Create the same user name on the workstation . The user name would need to be exactly the same user name as in DC and password needs to be the same as well.

On the DC, the user is actually DOMAIN\USER1, on the workstation, the user is WORKGROUP\USER1, since they have the same credential, now you can connect to the DC with RSAT. 

2 Install Domain Controller on Windows 2008R2 Server Core

1. Configure Remote Desktop

sconfig –> 7. Remote Desktop


2 Remove Last DC from WinServer 2008R2 Core

dcpromo /unattend:C:\Users\Administrator\DC.txt


password=* <The password for the UserName account> Specify * to prompt the user for credentials during the installation.
administratorpassword=<The local administrator password for the server>
DNSDelegationUserName=<The DNS server administrative account for the DNS zone that contains the DNS delegation>
DNSDelegationPassword=<The password for the DNS server administrative account>



Monday, June 11, 2012

5 Win2008R2 Enterprise VS Standard

Here are some major difference between Enterprise and Standard

1. Memory/CPU limitation


2. Failover cluster is only available on Enterprise Edition




7 Nest Hyper-V on VMWare fail to star the VM.

I have installed the Hyper-V on my VM Player. While try to start VM created on the Hyper-V server, I got below error message.


3 Configure Hyper-V with StarWind

StarWind provide the Fee version of ISCSI software. I am going to use to service my SAN environment for Hyper-V.

The interface is relative easy to create the san disk.


Sunday, June 10, 2012

8 Configure Hyper-V Server mange from remote.

This article is assume the Hyper-V has already install and enable on the Server Core.

1. Create the match new user account: This step can be skip if you are not use workgroup

Use sconfig to create new administrator account that match the workstation’s user account. You can use the net user  command to change the password later if necessary.

net user username *

Saturday, June 9, 2012

5 Install (RSAT) Remote Server Administration Tools for Windows 7

After Download the RSAT from MSFT website, I tried to install it on my Win7 Home Premium.  I got below error message. It is because MSFT does not support it on Home Premium version.


Friday, June 8, 2012

1 Hyper-V Installation

It is recommend to have three physical network card for the Hyper-V server. One for the Hyper-V remote  management. One for the Hyper-V Server (root partition ) connect to the physical network. One for the VM. Hyper-V does not support wireless network interface. According to the MSFT, wireless consider is less stable network.

Enable the role using GUI from Existing Windows Server


Wednesday, June 6, 2012

2 How to check your Hardware is compatible for Virtualization

1. Use Vt.iso from http://communities.vmware.com/docs/DOC-8978 


2. Use Securable http://www.grc.com/securable.htm


When I tried this utilizes on my VM Player with Windows 2008R2 installed. It shows NO for Hardware Virtualization. Therefore I can not install Hyper-V role. image

To enable the Hardware Virtualization usually needs to be done through the BIOS. Since it is just VM. I can change it through the VMPlater configuration.


Sunday, June 3, 2012

2 Trace Flag

Trace flag is used to set up some specific server feature or behavior.  For example the 3605 would output the error information to the error log.

To check the trace flag status:

-- Show trace flag status in the current session
--   Show trace flag status for the global
-- Show whether trace flag 3205 is enable at current session

Saturday, June 2, 2012

1 Server Name and Instance Name

To get the SQL Server Server name

Select * from sys.servers 

To get the instance name


For the default instance. the @@servicename always show as ‘MSSQLSERVER’

The SSMS –> Instance name –> Server Property –> General –> Name represents the name of the instance. ( http://msdn.microsoft.com/en-us/library/ms178496  ) , however for the default instance, it would show as HOSTNAME.


We can change the server name quite easily . In fact there are some application has dependence on the server name.

sp_dropserver 'Servername';
sp_addserver 'servername',local;

After the name has been changed, bounce the sql server instance. However there is no easy way to change the instance name.

In theory, you can update the register key and recreate the sql server service by using SC command. I have done so for the SSAS but not ever do it for SQL Server.


SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates