User Profile “The query returns nothing” Error

Jan 10, 2013 9:00 PM, - Posted by Tommy Segoro

It’s time for me to configure the User Profile Synchronization service. I started with configuring the connection. It can somehow crawled and displayed my OU structure but when I click OK it returns to the connection listing page with the following error message:

“The query returns nothing”

I then research in Google and found the following article:

http://www.khamis.net/blog/Lists/Posts/Post.aspx?ID=19

I looked in Event Viewer and I found out that the account I was using to crawl AD didn’t have access. At this stage I was using SEGORO\sp_admin (account used to install SP 2010 Beta).

I then logged off and re-logged back in using SEGORO\sp_farm (account used to run services). When I tried to re-create the connection it worked.

Hope this helps,

Tommy

Configuring Sharepoint 2010 Part 3

Jan 10, 2013 8:59 PM, - Posted by Tommy Segoro

I’ve just deleted my SP 2010 VM and re-created it. This time I won’t choose the wizard but instead I’ll try to configure each service manually.

As before, after the SP 2010 was completed, Central Admin page first opened with the selection of either use the wizard or configuring the service manually. I then chose the second one.

At this point, the only services activated were:

– Central Administration

– Microsoft Sharepoint Foundation Incoming Email

– Microsoft Sharepoint Foundation Web Application

– Microsoft Sharepoint Foundation Workflow Timer Service

I will now attempt to activate each service starting from the very top.

What I found as a major difference between SP 2010 and SP 2007 is the Service Applications. In MOSS 2007 you have Shared Services Provider but now it’s replaced with Service Applications in 2010.

Unlike Shared Services Provider, in Service Applications you have to create the service manually one-by-one. In SSP, as soon as you open the administration page, you can straight away see User Profiles, Search, Excel, Audience and BDC headers but in Service Applications you have to create each of these services manually.

Once I was done with these services, I could finally create the web application and root site collection.

I’ll keep continuing my investigation.

Cheers,

Tommy

Configuring Sharepoint 2010 Part 2

Jan 10, 2013 8:59 PM, - Posted by Tommy Segoro

I then chose to use the wizard. With the wizard it seemed that Sharepoint will attempt to use only one account for all of the services. I used WINSERVER2008\spt_service for all of them. I assume you’ll be able to change the service account for each service manually later on.

Once I finished the wizard there were some other services that need activation:

– Document conversion launcher service

– Document conversion load balancer service

– Sharepoint Foundation Help Search

– User profile synchronization service

– Lotus Notes connector

I could then activate each service except User Profile Synchronization Service. Somehow it asked me for User Profile Application which I haven’t created.

At this point performance degraded so much! I think I now know why we need more than 1GB of RAM for it. Each Sharepoint service that we activate consumes resources and with Sharepoint 2010, there are a lot more services that are activated compared to MOSS 2007.

There are two main services that consume most of my CPU:

– SQL Server
– Microsoft Sharepoint Foundation User Code Service

When the User Code Service is on – together with SQL Server – it consumed ~80% of my CPU most of the time. Since my VM only has 1GB of RAM, it made it to a non-workable state. Even moving a mouse was really-really slow.

I then managed to turn off the User Code Service and at this point CPU consumption was around 18-70%. It hit 18% and 70% quiet rarely, it normally stayed on 40-55%.

That’s all for me for today, it’s already 10:50PM. Please stay tuned, I’ll continue my investigation tomorrow!

Cheers and until next time,

Tommy

Configuring Sharepoint 2010

Jan 10, 2013 8:58 PM, - Posted by Tommy Segoro

The install finished successfully (thank God!). Now I arrive at the stage where I need to configure Sharepoint 2010.

Below were the steps I took:

1. I selected “Create a new server farm”.

2. I specified the database server as WINSERVER2008 (VM machine name).

3. I then specified WINSERVER2008\SPT_Farm as the database access account and I encountered the following error message:

The specified user WINSERVER2008\SPT_Farm is a local account. Local accounts should only be used in stand alone mode.

I then came accross this article that can bypass that message:

http://sharepoint.microsoft.com/blogs/fromthefield/Lists/Posts/Post.aspx?ID=112

When I tried to run the PowerShell command as mentioned in that post, I get the following error message:

New-SPConfigurationDatabase : SQL server at WINSERVER2008 has an unsupported ve
rsion 9.0.4035.0. The minimum required SQL server versions are SQL Server 2005
SP3 CU3, version number: 9.00.4220.00, downloadable from “http://support.micros
oft.com/kb/967909”, or SQL Server 2008 SP1 CU2, version number 10.00.2714.00, d
ownloadable from http://support.microsoft.com/kb/970315. 
At line:1 char:28
+ new-spconfigurationdatabase <<<< + CategoryInfo : InvalidData: (Microsoft.Share…urationDatabase: SPCmdletNewSPConfigurationDatabase) [New-SPConfigurationDatabase], SPCmdle tException + FullyQualifiedErrorId : Microsoft.SharePoint.PowerShell.SPCmdletNewSPCon figurationDatabase

I then went to the KB article as mentioned above:

http://support.microsoft.com/kb/967909

After I installed 3 SQL patches, the install finished successfully.

Now I arrive at the SP2010 Central Admin site! WOOHOO!

At this point RAM consumption is 801-931MB and please note that I have SQL 2005 Developer Edition running on the same VM.

To be continued…

Sharepoint 2010 BETA does NOT need 8GB of RAM

Jan 10, 2013 8:58 PM, - Posted by Tommy Segoro

When SP2010 first came out everyone said that you’ll need at least 4GB of RAM. Since I don’t have that luxury just yet (my new laptop hasn’t come yet at the time of writing this article), I can only give 1GB of RAM to my VM.

Guess what… Sharepoint 2010 installed successfully on VM with 1GB of RAM.

Cheers,

Tommy