SharePoint 2010 Error: domain/my Cannot be found

So, this morning i was trying to access my personal site and my profile pages in our new SharePoint farm. But what i got was the HTML 404 The Page Cannot be Found.
After spent hours looking for the solution of this issue, finally found the way to figure this out! Yippi!

1st step---
Log on to your Central Administration > Application Management > Create Site Collection

2nd step---
Point to Web Site Address and click on the link Define Managed Paths.

3rd step---
Add a new path

1. my, choose the type Explicit inclusion, Add Path

2. my/personal, choose the type Wildcard inclusion, Add Path

3rd step---
Go back to Create Site Collection page.

Put the Title and Description : My Sites

Web Site Address : http://your_domain/my/

Template Selection : Enterprise > My Site Host

Then choose the Primary and Secondary Site Collection Administrator, then click OK. Now you have /my site collection.

4th step---
This is optional, just in case if you haven't configured the Self-Service Site Creation. This will let the authenticate user create their own personal page.
Go to Central Administration > Security > General Security > Configure self-service site creation.

Then choose On in the Enable self-service site creation section. Press OK.

Easy, huh? :)

Read more »

SharePoint 2010: Specify the Default Database Server

If you have look at my posts before this, this post is connected to Migrating SharePoint 2010 Databases from SQL Server 2008 Express Edition to SQL Server 2008 R2 Enterprise Edition. After detach and attach all MOSS 2010 databases from SQL Server Express, now we have  to go back to SharePoint Central Administration. 

1st step---

Log on to your Central Administration as farm administrator.

2nd step---

In the SharePoint 2010 Central Administration Page go to Application Management > Databases > Specify the default database server.

3rd step---

In the default database server page, fill in the Domain\SHAREPOINT_DB_Instance of the SQL Server Instance that you'd like to be as the default.

And if on that Instance you are using SQL Authentication, then you have to fill in the Username and Password, instead leave it blank if you're using Windows Authentication.

Sometimes you may get an error message if there's an issue with the permission for NT AUTHORITY/NETWORK SERVICE group like shown below:

Login failed for user 'NT AUTHORITY\NETWORK SERVICE'

This happens when you're using Windows Authentication, and means you will need to grant permission for NT AUTHORITY/NETWORK SERVICE. Below are some steps that i did to grant permission for NT AUTHORITY/NETWORK SERVICE group.

1st step---

Open SQL Management Studio and then connect to the Database Instance. After you are connected, right click on the Database Instance and point to New Query, because we are going to use Transact-SQL to grant the permission.

2nd step---

Execute the script below:

sp_grantlogin 'NT AUTHORITY\NETWORK SERVICE'

After that you will need to go back to the SharePoint Central Administration, and redo the 2nd step---  and 3rd step--- up above. You will not find any error anymore. :)

Read more »

SharePoint 2010 : Detach SharePoint databases from SQL Server Express Edition & Attach to SQL Server Enterprise Edition

As default on the new installation, Microsoft Office SharePoint Server (MOSS) 2010 using SQL Server Express Edition to store the databases. To migrate MOSS 2010 databases to SQL Server Enterprise edition, you need to install SQL Server Management Studio first so you can manage all Database Engine easily. Before you do databases detach, please read this article carefully from Microsoft official site. According to the information and requirements provided by Microsoft you will need to stop some of the SharePoint services. You can manage by using Administrative Tool > Services, but i'm using a very quick tool from CodePlex called SharePoint 2010 Service Manager. You can download from here for FREE!

So below are the steps to detach your SharePoint databases from SQL Server Express Edition and attach them again  to SQL Server Enterprise Edition.

1st step---

Go to SQL Server Management Studio, connect to your SharePoint Server database.

This is what i did:

Server type  : Database Engine

Server name : Domain\SHAREPOINT

Then click Connect.

2nd step---

In the Object Explorer, point to Connect button and choose Database Engine. Then connect again to your SQL Server Enterprise Edition server.

3rd step---

After installing SharePoint 2010 Service Manager, click on the Stop SharePoint 2010 button to stop all the services we need to detach the MOSS 2010 databases.

After we stop all the services, note that the SQL Server also stopped. We need to start it again manually from SQL Server Management Studio.

4th step---

Point to the database that we need to detach. Right click, then point to Tasks > Detach..

5th step---

Go to Windows Explorer and find the location of your SQL Server Express databases, then copy the .mdf and .ldf file to the SQL Server Enterprise databases location.

6th step---

Back to SQL Server Management Studio, but now we focus on the SQL Server Enterprise Edition server. Expand the Databases. Then right click on Databases and choose Attach..

The new dialog for attach database will show up after that. Click on Add. And it will show the dialog to locate the .mdf file.

7th step---

Click OK, and then OK again to attach the database file. You will notice a new database has been attached to your SQL Server Enterprise Edition. If it doesn't appear then right click on the server name and Refresh.

Good Luck.

Read more »

SharePoint 2010: Change Preferred Name To FirstName + LastName Instead Of Domain\Username

In this tutorial i would like to share how to change your account preferred name in SharePoint Server 2010.

1st step---
Log on to SharePoint Central Administration as Farm Administrator.

2nd step---
Go to Application Management > Manage service applications.

3rd step---
Scroll down to User Profile Service Application and click on the hyperlink.

4th step---
Go to  Manage User Profiles.

6th step---
Put the username that you would like to change its profiles on to Find profiles textbox. Then click Find. Once it shows the result, rollover to the Account Name and click the little arrow, choose Edit My Profile.

5th step---
Now you can Edit the account properties, don't forget to Save and Close after you're finished editing. Good luck!

Read more »

SharePoint 2010 Error: Requested registry access is not allowed

Did you find this error? Well i just did few hours ago, and after struggling many hours, i think i finally have found what the problem is. The first issue came because i did repair my SharePoint site, because i did a mistake by changing the farm account and suddenly my SharePoint Central Administration page can not be accessed. So, after i repaired my SharePoint using SharePoint Server 2010 installation CD, my Central Administration worked fine. But wait, it wasn't fine at some pages, like i couldn't access Security > General Security > Configure managed accounts. It returned me an error :
Error: Requested registry access is not allowed

and not even that i couldn't delete or edit any of my web applications, and i couldn't access all my SharePoint site or web applications, it says my license has expired. So what was going on? After surfing on the internet and tried to find a bunch of articles about it, finally i found the way to figure it out.

Below are some steps that i did:
--1st step
Open the registry by run regedit on the server where the SP2010 is installed.

--2nd step
Go to HKEY_LOCAL_MACHINE\SOFTWARE\MICROSOFT\OFFICE SERVER\14.0
Right click and choose Permission..

--3rd step
Add WSS_ADMIN_WPG and give Full permission to this Group.

--4th step
Add WSS_WPG and give Read permission to this Group.

--5th step
Restart the server.

Try to browse Central Administration again. And it should be working fine as well as your SharePoint sites.

Read more »