Rob Hardy's Blog Space

'Property Owner is not available for Database' Error Message in SQL Management Studio

2010-09-20T05:37:00.000-07:00

When trying to open the properties for a database in SQL Management Studio, you may encounter a message that states 'Property Owner is not available for Database'

This can happen on restored databases. To solve this, adjust the below query;

USE SampleDB
EXEC sp_changedbowner 'DOMAINNAME\USERNAME'

Creaing a new Application Proxy Group in SharePoint 2010

2010-09-17T05:18:00.000-07:00

In PowerShell, type the following command and adjust the name as required;

New-SPServiceApplicationProxyGroup –Name "Project 2010 Proxy Group"

Project Server 2010 - Installation Notes

2010-09-17T02:31:00.001-07:00

Below are some installation notes that have created, during various installations. This will be added to where required.

1. For backup purposes, it is best to have a SEPARATE content database for PWA with a Site Collection limit of just ONE. This doesn't restrict the amount of project workspaces that are created as they are not site collections.

2. Check the other note sections for things such as PerformancePoint for considerations to make there. These are on this site.

3. If applying server updates, you will need to download the Project Server 2010 update that you want. This will contain the SharePoint Server update. You do not need SharePoint Foundation update!! This is included in the main update itself, unlike 2007 where you needed to install the WSS update beforehand.

More to come......................

SharePoint/Project 2010 - PerformancePoint Configuration Notes

2010-09-14T12:55:00.000-07:00

Below are some notes that I have made, for the configuration of PerformancePoint. These are notes when I have come across problems, for example when I couldn't connect to a data source in the designer, or couldn't even get in the designer without error.

1. Check the PerformancePoint service has been started
2. Check a suitable Unattended Service account has been applied
If using a unique unattended service account for performancepoint (e.g. not the farmadmin or similar), you will need to open SQL Management Studio and connect to Analysis Services. From here you will need to add the performancepoint account to the ProjectServerViewOLAPData role. this error sometimes throws ACL related messages!
3. Check the Secure Store has been setup properly
4. Maybe try checking the Unattended Service Account has DB Owner rights on the relevant Content DB
5. You could also check that Excel Services can connect, as this may generate more helpful error messages or logs

Changing Web Application Account in SharePoint 2010

2010-09-10T01:58:00.000-07:00

In order to change the web application account, you need to open central administration and click Security > Change Service Accounts.

I found this useful for when I had a faulty Windows Profile for one of my accounts.

You can change the Farm Admin account here, as well.

Changing Index locations in SharePoint 2010

2010-09-07T03:45:00.001-07:00

The below commands are useful if you didn't setup the Index Location when originally configuring the farm. It is also useful if you want to move the indexes to a new drive or similar.

Two of the below are for index locations, and the PowerShell command is for the default index location for any newly created indexes.

Index Location (See what it currently is)
stsadm -o spsearch -action list

Index Location (Change what it is)
stsadm -o spsearch -indexlocation "E:\SharePoint Indexes" (This is your new index location)

Default Index Location (Change in PowerShell)
1. Get-SPEnterpriseSearchServiceInstance
2. Set-SPEnterpriseSearchServiceInstance –DefaultIndexLocation "E:\SharePoint Indexes"

Windows account logs on as a temporary profile

2010-09-03T08:14:00.000-07:00

This sometimes happens on Windows 7 and Windows 2008 after a profile is deleted. The solution:

1) login to the box as an administrator

2) open regedit and navigate to:

HKLM\SOFTWARE\Microsoft\Windows NT\CurrentVersion\ProfileList

3) expand ProfileList so that you can see a list of SIDS of loaded user profiles

4) click on each SID in turn and look at the ProfileImagePath value to determine which user profile the SID belongs to

NOTE: You can at this point simply delete the profile however you will loose the data. This is the only option at the time of this post which I have tested. Step 5 below may avoid this! But I havent tested it.

5) add .old to any SIDs (including ones ending with .bak!!! - i.e. .bak becomes .bak.old ) belonging to the user profile that keeps logging in on a TEMP user profile

6) reboot

7) now login as the user and you should log in as that user now

Setting up the Search Service Application in PowerShell for SharePoint 2010

2010-08-22T11:33:00.000-07:00

The below commands will do this, and avoid the horrible GUID's on the database names for the three Search databases that are created. You will need to amend the first few lines where indicated in RED. If you use different naming conventions then just adjust as required.

IMPORTANT NOTE: There is a character which is used in the below script on more than one occasion, that doesn't show on this blog!!!!! This is the breaker character, which looks like an 'I' and is normally located next to the left shift key.

Essentially you will not be able to copy the below, its more of a reference piece.

###################

$app = new-spserviceapplicationpool –name "SERVERNAME Search Application" –account Rob-Hardy\Search
$searchapp = new-spenterprisesearchserviceapplication -name "SERVERNAME Search Service" -applicationpool $app
$proxy = new-spenterprisesearchserviceapplicationproxy -name "SERVERNAME Search Service" -Uri $searchapp.uri.absoluteURI
$proxy.status

#####IF THE PROXY IS OFFLINE ENTER THIS##### $proxy.status = “online”
#####IF THE PROXY IS OFFLINE ENTER THIS##### $changestatus.update()

$si = get-spenterprisesearchserviceinstance –local
$si.status
Start-SpEnterpriseSearchServiceInstance -identity $SI
set-spenterprisesearchadministrationcomponent –searchapplication $searchapp –searchserviceinstance $si
$ct = $searchapp new-spenterprisesearchcrawltopology
$csid = $SearchApp.CrawlStores select id
$CrawlStore = $SearchApp.CrawlStores.item($csid.id)
$hname = hostname
new-spenterprisesearchcrawlcomponent -crawltopology $ct -crawldatabase $Crawlstore -searchserviceinstance $hname
$ct set-spenterprisesearchcrawltopology -active
$qt = $searchapp new-spenterprisesearchquerytopology -partitions 1
$p1 = ($qt get-spenterprisesearchindexpartition)
new-spenterprisesearchquerycomponent -indexpartition $p1 -querytopology $qt -searchserviceinstance $si
$PSID = $SearchApp.PropertyStores Select id
$PropDB = $SearchApp.PropertyStores.Item($PSID.id)
$p1 set-spenterprisesearchindexpartition -PropertyDatabase $PropDB
$qt Set-SPEnterpriseSearchQueryTopology -Active

Cannot reuse a deleted Managed Service Application name in SharePoint 2010

2010-08-22T11:26:00.000-07:00

If you arrive in a situation where you cannot reuse an old deleted service application name because its supposedly in use or similar, then you can run the following commands.

The first one is as follows - in powershell;

C:\Users\installation> get-SpServiceApplicationPool

This will now show up the names for the Application Pools. Simply identify which one you need to delete, and then run the below command and adjust with the relevant name;

C:\Users\installation> Remove-SpServiceApplicationPool "APPLICATION NAME HERE"

This item and all items under it will not be crawled because the owner has set the NoCrawl flag to prevent it from being searchable

2010-08-13T08:56:00.000-07:00

“This item and all items under it will not be crawled because the owner has set the NoCrawl flag to prevent it from being searchable"

In order to fix this issue (and this is true for any Site Collection), is to navigate to your MySite host and click on Site Actions > Site Settings.

From here, click on “Search and offline availability” under Site Administration, and ensure that you have Allow this site to appear in search results? set to Yes.

PSConfig Checks

2010-08-01T13:03:00.001-07:00

Below are some typical things you can check when running the PSConfig command when it fails:

1. Check the text carefully, is the server name and logon correct?
2. Is Windows 2008 being used? You may need to make firewall exceptions such as port 1433-1434 (SQL Database Engine)
3. Check that TCP/IP is enabled in SQL Configuration Manager
4. Do the servers ping each other?
5. Do the service accounts (installation and farmadmin) have the relevant SQL rights? (dbcreator, securityadmin and public?)

How to disable MySites in SharePoint 2007

2010-07-14T01:56:00.001-07:00

Simply follow these steps:

1) Go to the Central Administration Web Page

2) Click on Shared Services Administration on the left hand navigation that you created for your site collection..in this case it's called 'SharedServices1'

3) From here, look under "User Profiles and My Sites" click Personalization Services Permissions

4) Select the group you want to limit the functionality for. (More than likely you will just have NTAuthority\Authenticated Users. )

5) On the next screen you will see a list of checkboxes:

--To disable MySites uncheck "Create Personal Site"
--To disable MyLinks uncheck "Use Personal Features"

6) Click Save

Disabling Windows Loopback Check for SharePoint Server 2007

2010-06-29T02:41:00.000-07:00

The loopback check will cause constant password prompts appear whenever using host headers in SharePoint 2007. To get around this, you can make exceptions in the Loopback Check security feature, or completely disable it. The steps on how to sort this, are below:

Dev Environments (Less Secure Method)

Click Start > Run > type 'regedit' > OK
In Registry Editor, locate and then click the following registry key: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa
Right-click Lsa, point to New, and then click DWORD Value.
Type 'DisableLoopbackCheck' and then press ENTER.
Right-click DisableLoopbackCheck, and then click Modify.
In the Value data box, type 1, and then click OK.
Quit Registry Editor, and then restart your computer.

Live Environments (More Secure Method)

Click Start > Run > type 'regedit' > OK
In Registry Editor, locate and then click the following registry key: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\MSV1_0
Right-click MSV1_0, point to New, and then click Multi-String Value.
Type BackConnectionHostNames, and then press ENTER.
Right-click BackConnectionHostNames, and then click Modify.
In the Value data box, type the host name or the host names for the sites that are on the
local computer, and then click OK.
Quit Registry Editor
Restart the Computer

If you are doing this on SharePoint, you will need to do this on all SharePoint servers in the Farm.

SharePoint 2007 Anonymous Access and STSADM Lockdown

2010-06-29T02:34:00.000-07:00

To setup Anonymous Access, please see the below basic steps (remember to change the URL):

Logon to the SharePoint Server
Open Command Prompt
Edit and type the following command: stsadm -o activatefeature -url http://intranet -filename ViewFormPagesLockDown\feature.xml
Still in command prompt, edit and type the following command: stsadm -o deactivatefeature -url http://intranet -filename ViewFormPagesLockDown\feature.xml
Finally, open Central Administration and click Application Management > Authentication Providers and select the relevant Web App you wish to enable Anonymous Access on
Toggle Enable Anonymous Access check box (go in and out of this screen, essentially leaving Anoynmous Access turned on and thus toggling it)

From here, as long as the site collection should be ready to go.

Configuring the Adobe PDF iFilter for SharePoint 2007

2010-06-29T01:44:00.000-07:00

Below are steps for installing the x64 Adobe PDF iFilter for SharePoint 2007:

First of all, install the x64 Adobe PDF iFilter to the SharePoint index server. This file can be found on the Adobe website, or by searching Google
When installed, open Central Administration on the index server
Open the SSP thats relevant to the iFilter
Click Search Administration under the Search heading
Click File Types
Click New File Type
Type pdf and click OK

Next, we need to verify that PDF has been added to the registry correctly:

Run Regedit by browsing to c:\Windows\system32\regedt32.exe
Within the left hand side tree, browse to: \\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office Server\12.0\Search\Applications\{site GUID}\Gather\Portal_Content\Extensions\ExtensionList
If PDF extension is present, skip to Step 8 to verify the second location. If PDF extension is not present, continue with the next step
Right click on right-side Extension List pane and choose New > String Value
Add a name to the new Registry Key (e.g. “38” - basically the next in line)
Double click the new Registry Key. For Value data, enter pdf”
This would automatically add an entry for ‘pdf’ filetype as mentioned above
Verify that PDF has the correct settings in a second registry location.
While still in Regedit, within the left-side tree, browse to: \\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office Server\12.0\Search\Setup\Filters\.pdf
Verify the following values. If values are not as shown, edit them.
i. Default =
ii. Extension = pdf
iii. FileTypeBucket = 1
iv. MimeTypes = application/pdf
Verify that PDF has the correct settings in a third registry location.
While still in RegEdit, within the left-side tree, browse to: \\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office Server\12.0\Search\Setup\ContentIndexCommon\Filters\Extension\.pdf
Verify the following values. If values are not as shown, edit them.
i. Default = {E8978DA6-047F-4E3D-9C78-CDBE46041603} OR {56BD18AD-CF9C-4110-AAAA-B2F96887D123}

The final part, is to sort out the PDF Icon. If you search on the internet, there are plenty of 16x16 PDF Icons about. Firstly obtain this, and proceed with the following steps on the index server.

Copy the 16x16 PDF Icon you have downloaded to the following location:
C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\IMAGES
Add an entry in docicon.xml for the pdf icon by copying/pasting and adjusting one of the other entries on a new line. The location for this XML file is:
C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\TEMPLATE\XML

The last thing to do is restart all SharePoint services as well as IIS:

Launch the Command Prompt by clicking Start > All Programs > Accessories > Command Prompt
Type the following at the prompt: “net stop osearch”. Wait for success message.
Type the following at the prompt: “net start osearch”. Wait for success message.
Type the following at the prompt: “iisreset”. Wait for success message.
Close the Command Prompt window.

Microsoft Office SharePoint Server can now index PDF files. Also, the PDF icon should show in File Types list in Central Administration and therefore along side the search results that appear.

Moving SQL Databases

2010-06-29T01:33:00.000-07:00

SQL Steps for moving databases to another drive are outlined below. This example is for SharePoint 2007 databases, that are on SQL 2005:

Logon to SharePoint and stop the relevant IIS Website
Logon to SQL, and right click the server name and click Properties
In the dialog box, click Database Settings on the left, and change the default locations for all new databases
Now, right click a relevant database and click Tasks > Detach...
When the box appears, check the exact database and log file names and make NOTES of them
Select the Drop Connection checkbox
Click OK
The database should now dissapear from the left pane
Still on SQL, open Windows Explorer and locate the MDF and LDF files, and copy and paste them to the new drives and make a note of the new location
In SQL Manager, Right click Databases and select Attach and point to the new locations for the MDF and LDF Files
Start the Website in IIS on SharePoint

From here, check the site works. If the pages cannot be displayed, it maybe due to the SQL Database permissions being incorrect. You may need to check to see if there is a DBOwner etc.

There maybe different considerations for databases that aren't for SharePoint 2007.

SharePoint 2007 Version Numbers

2010-06-29T01:26:00.000-07:00

Below is a list of SharePoint 2007 and WSS 3.0 Version Numbers, which you can find in Central Administration's Site Actions > Site Settings screen.

12.0.0.6535
SP2 + April 10 CU (KB981042 + KB981043)

12.0.0.6529
SP2 + February 10 CU (KB978396 + KB978395)

12.0.0.6524
SP2 + December 09 CU (KB977027 + KB977026)

12.0.0.6520
SP2 + October 09 CU (KB974989 + KB974988)

12.0.0.6514
SP2 + August 09 CU (KB973400 + KB973399)

12.0.0.6510
SP2 + June 09 CU (KB971538 + KB971537)

12.0.0.6504
SP2 + April 09 CU (KB968850 + KB968851)

12.0.0.6421
SP2 (KB953338 + KB953334)

12.0.0.6341
February 09 CU (KB961755 + KB961756)

12.0.0.6335
December 08 CU (KB960010 + KB960011)

12.0.0.6331
October 08 CU (KB957691 + KB957693, KB958567 + KB958569)

12.0.0.6327
August 08 CU (KB956056 + KB956057)

12.0.0.6318
Infrastructure Update (KB951695 + KB951297)

12.0.0.6303
Post-SP1 Hotfix (KB948945)

12.0.0.6301
Post-SP1 Hotfix (KB941274)

12.0.0.6300
Post-SP1 Hotfix (KB941422)

12.0.0.6219
SP1

12.0.0.6039
October 2007 Public Update

12.0.0.6036
August 2007 Hotfix package

12.0.0.4518
RTM

12.0.0.4407
Beta 2 TR

12.0.0.4017
Beta 2

12.0.0.3111
Office 12 (PDC image - pre-beta) - This version of Office does not have a support link in the Add/Remove programs dialog box.