Enable or disable Global Catalog by command

We can enable or disable Global Catalog for a domain controller in Active Directory Sites and Services > NTDS Settings Properties.

We can also perform "dsmod server" command to enable or disable Global Catalog. This is my lab environment.

I would like to disable Global Catalog in DC01.

1. On DC01, log in as Domain Administrator.

2. Launch "Command Prompt" as Administrator.

3. Perform "dsmod server "CN=DC01,CN=SERVERS,CN=Default-First-Site-Name,CN=Sites,CN=Configuration,DC=corp,DC=contoso,DC=com" -isgc no

The Global Catalog was disabled in DC01.

Remark: To enable Global Catalog, type parameter "-isgc yes".

Reference:

Dsmod server

This posting is provided “AS IS” with no warranties, and confers no rights!

Delete all mails in a mailbox by PowerShell in Exchange

One of my friends asked me. How to delete all emails in a user mailbox in Exchange 2007? 

Then I try to search the solution . I found the solution from an article "Delete emails from mailboxes - Exchange 2007" which was written by Ratish Nair.

After that, I tried to find a solution to delete all emails in a user mailbox in Exchange 2010 and 2013. I found the another solution from an article "Exchange 2010 SP1 or SP2 PowerShell cmdlet for deleting all email in a mailbox" which was written by Terence Luk. I tried to perform it in Exchange 2010 and Exchange 2013 environment.

Remark: To delete all emails in Exchange 2010 RTM , we need to add a user in "Discovery Management", "Exchange Support Diagnostics" and "Exchange Mailbox Import Export" groups and then use "Export-Mailbox -DeleteContent" to delete all emails in a user mailbox.

Reference:
Search-Mailbox

Export-Mailbox

This posting is provided “AS IS” with no warranties, and confers no rights!

Installing Microsoft Assessment and Planning (MAP) 8 with SQL Server 2012 database

The MAP toolkit is used for multi-product assessment and planning. It accessed a network environment using agentless data collection technologies to gather inventory and performance information. Then provides assessment reports and executive proposals with recommendations to aid organizations with their IT infrastructure planning.

(Source: The MAP Toolkit Survival Guide)

By default, MAP Toolkit connects to the localDB, SQL Express 2012. To connect to other version SQL, we need to install the SQL Server manually and change the instance name to "MAPS".

MAP Toolkit supports any edition of SQL Server 2008, 2008 R2 and 2012 but the SQL server  and MAPS Toolkit must be installed in the same server.

MAP Toolkit supports the following operating system:

• Windows 7 Professional, Enterprise and Ultimate with Service Pack 1
• Windows Vista Business, Enterprise and Ultimate with Service Pack 2
• Windows Server 2008 all edition with Service Pack 2
• Windows Server 2008 R2 all edition with Service Pack 1
• Windows Server 2012 all edition

I will install SQL server and MAPS in a server, MP01 which was installed Windows Server 2008 R2 with Service Pack 1.

Assuming that Microsoft .Net Framework 3.5 and Microsoft .Net Framework 4.0 with update 2 have been installed in MP01.

Installing SQL Server

1. On MP01, log in as Domain Administrator.

2. Insert SQL Server 2012 standard DVD.

3. Click "Run SETUP.EXE".

4. On "SQL Server Installation Center", click "Installation > New SQL Server stand-alone installation or add features to an existing installation".

5. On "Setup Support Rules" window, click "OK".

6. On "Product Key" window, click "Next".

7. On "License Terms" window, check "I accept the license terms".

8. Click "Next".

9. On "Setup Support Rules" window, click "Next".

10. On "Setup Role" window, select "SQL Server Feature Installation", click "Next".

11. On "Feature Selection" window, check "Database Engine Services", "Management Tools - Basic" and "Management Tools -Complete".

12. Click "Next".

13. On "Installation Rules" window, click "Next".

14. On "Instance Configuration" window, select "Named instance", type "MAPS".

Remark: Make sure the "Named instance" is changed to "MAPS". If the instance name isn't changed, MAP Toolkit cannot connect to this SQL server.

15. Click "Next" twice .

16. On "Server Configuration" window, provide the user name and password for "SQL Server Agent" and "SQL Server Database Engine".

17. Select "Collation" tab, make sure "Database Engine" is "SQL_Latin1_General_CP1_CI_AS".

18. Click "Next".

19. On "Database Engine Configuration" window, click "Add Current User" and then click "Next".

20. On "Error Reporting" window, click "Next" twice.

21. On "Ready to Install" window, click "Install".

22. On "Complete" window, click "Close"

Installing Microsoft Assessment and Planning (MAP)

1. On MP01, log in as Domain Administrator.

2. Run "Microsoft_Assessment_and_Planning_Toolkit_Setup.exe".

3. On "Welcome to the Microsoft Assessment and Planning Toolkit Setup Wizard", click "Next".

4. On "License Agreement" window, select "I accept the terms of the license agreement".

5. Click "Next".

6. On "Installation Folder" window, click "Next".

7. On "Customer Experience Improvement Program" window, select "I don't want to join the program at this time".

8. Click "Next".

9. On "Ready to Install" window, click "Install".

10. On "Installation Successful" window, click "Finish".

11. Now, the "Data source" is selected the "MAPS Instance".

12. Next to "Name", type "MAP Test", click "OK".

13. Launch "Microsoft SQL Server Management Studio".

14. Click "Connect".

15. Expand "Databases".

The "MAP Test" was created in the SQL Server.

Remark: The localDB was installed when you install MAP Toolkit.

Download link:

http://www.microsoft.com/en-us/download/details.aspx?id=7826

This posting is provided “AS IS” with no warranties, and confers no rights!

Installing SharePoint 2013 two-tier farm on Windows Server 2012

I will install SharePoint 2013 in the following lab environment.

 

Computer FQDN: DC01.contoso.com

IP address / network: 192.168.7.10/24

Roles: Domain Controller, DNS server, Global Catalog server

OS: Windows Server 2012 Datacenter

Computer FQDN: SP01.contoso.com

IP address / network: 192.168.7.11

Roles: SharePoint 2013 server

OS: Windows Server 2012 Datacenter

Computer FQDN: DB01.contoso.com

IP address / network: 192.168.7.12

Roles: SQL Server 2012 standard server with service pack 1

OS: Windows Server 2012 Datacenter

Service accounts for installing SharePoint 2013

To install SharePoint 2013, we need to create the following accounts in Active Directory.

Account Name	Usage
SPAdmin	SharePoint 2013 installation and Farm Administrator account (Local Administrator of SP01)
SPFarmSvc	SharePoint 2013 Farm account
SPSQLAdmin	SQL Server 2012 administrator (Local Administrator of DB01)
SPSQLSvc	SQL service account

Installing SQL Server 2012
1. On DB01, log in as SPSQLAdmin.
2. Insert SQL Server 2012 standard DVD.
3. Run "Setup.Exe".

4. On "SQL Server Installation Center", click "Installation > New SQL Server stand-alone installation or add features to an existing installation".

5. On "Setup Support Rules" window, click "OK".

6. On "Product Key" window, click "Next".
7. On "License Terms" window, check "I accept the license terms".

8. Click "Next".
9. On "Setup Support Rules" window, click "Next".

10. On "Setup Role" window, select "SQL Server Feature Installation", click "Next".

11. On "Feature Selection" window, check "Database Engine Services", "Management Tools - Basic" and "Management Tools - Complete".

12. Click "Next" twice.
13. On "Instance Configuration" window, select "Named instance" and then type "SP13SQL".

14. Click "Next" twice.
15. On "Server Configuration" window, type "Contoso\SPSQLSvc" in "Account Name" of "SQL Server Agent" and "SQL Server Database Engine".
16. Type the password of "Contoso\SPSQLSvc" in "Password" of "SQL Server Agent" and "SQL Server Database Engine".
17. Change the "Startup Type" of "SQL Server Agent" to "Automatic".

18. Click "Next".
19. On "Database Engine Configuration" window, select "Windows authentication mode" and then click "Add Current User".

20. Click "Next".
21. On "Error Reporting" window, click "Next".
22. On "Installation Configuration Rules" window, click "Next".

23. On "Ready to Install" window, click "Install".

24. On "Complete" window, click "Close".

Configuring the SQL Server for set up SharePoint 2013
1. On DB01, log in as SPSQLAdmin.
2. Launch "Microsoft SQL Server Management Studio".
3. Click "Connect".
4. Right-click "Security", select "New > Login".

5. Next to "Login name", type "Contoso\SPAdmin".

6. On left pane, select "Server Roles".
7. Add "dbcreator" and "securityadmin" under Server roles.

8. Click "OK".
9. Right-click "DB01\SP13SQL", select "Properties".

10. On left pane, select "Advanced".
11. Next to "Max Degree of Parallelism", change to "1".

12. Click "OK".

Remark: If "Max Degree of Parallelism" setting hasn't been changed, you may get the following error when you perform SharePoint Products Configuration wizard.

 

Installing prerequisites tools of SharePoint 2013
The SharePoint server requires accessing Internet to download and install the prerequisites tools. If the SharePoint server can access Internet. We need to download and install the prerequisites tools by ourselves.

To download the prerequisites tools, please go to the following web site:
http://technet.microsoft.com/en-us/library/cc262485.aspx

1. On SP01, log in as SPAdmin.
2. Insert SharePoint 2013 DVD.
3. Click "Run splash.hta".

4. Click "Install software prerequisites".

5. On "Welcome to the Microsoft SharePoint 2013 Products Preparation Tool" window, click "Next".
6. On "License Terms for software products" window, check "I accept the terms of the License Agreement(s)", click "Next".

The prerequisites tools are downloading in the server.

You may need to restart the server a few times.

7. On "Installation Complete" window, click "Finish".

Installing SharePoint 2013
1. On SP01, log in as SPAdmin.
2. Run "splash.hta".
3. Click "Install SharePoint Server".

4. On "Enter your Product Key" window, enter the product key, click "Continue".

5. On "Read the Microsoft Software License Terms" window, check "I accept the terms of  this agreement", click "Continue".

6. On "Server Type" window, select "Complete", click "Install Now".

7. On "Run Configuration Wizard" window, check "Run the SharePoint Products Configuration Wizard now", click "Close".

8. On "Welcome to SharePoint Products" window, click "Next".

9. On pop-up window, click "Yes".

10. On "Connect to a server farm" window, select "Create a new server farm", click "Next".

11. On "Specify Configuration Database Settings" window, next to "Database server" type "DB01\SP13SQL".
12. Next to "Username", type "Contoso \SPFarmSvc".
13. Next to "Password", type the password of "Contoso \SPFarmSvc".

14. Click "Next".

"Specify Database Access Account" is the SharePoint farm service account which is used as the application pool identity for Central Administration and as the process account for SharePoint Foundation 2013 Timer service.

15. On "Specify Farm Security Settings" window, provide a password for "Passphrase".

"Passphrase" is used to joining the SharePoint farm by other SharePoint servers.

16. Click "Next".
17. On "Configure SharePoint Central Administration Web Application" window, check "Specify port number".
18. Next to "Configure Security Settings", select "NTLM".

19. Click "Next".
20. On "Completing the SharePoint Products Configuration Wizard" window, click "Next".

21. On "Configuration Successful" window, click "Finish".

Reference:
Initial deployment administrative and service accounts in SharePoint 2013

Account permissions and security settings in SharePoint 2013

You Shall Configure your MAXDOP When Using SharePoint 2013

Hardware and software requirements for SharePoint 2013

This posting is provided “AS IS” with no warranties, and confers no rights!