Zephyr's SharePoint Blog

My Sharepoint world experience notes on day to day basis…..

Hide Left Navigation

Posted by fillzephyr on July 7, 2009

I am trying to hide left navigation through this little javascript.

Go to site Action> edit page> Add webpart

Choose content editor webpart.

Select source editor and paste the below script :

display: none;
On the appereance change the Title to Hide Left Nav bar

On the Layour check the Hidden



Posted in MOSS Funstuff, SharePoint Blogs | Tagged: | 1 Comment »

Redirecting or Changing My Sites Link Name to the New Link Name

Posted by fillzephyr on June 26, 2009


I had got a requirement to change the name of hyperlink  from ” My Site “to the some other Name called ” My”. 




I had download this codeplex project…………….


Open the Project using Visula studio. Go to the \12\TEMPLATE\CONTROLTEMPLATES\MySpace in the Project and open the MySpaceLink.ascx file

Now go to the line

<asp:HyperLink id=”hlMySite” Text=”MySpace” NavigateUrl=”/_layouts/MySpace/MySpace.aspx” runat=”server” /> 

here change the Text = “My”.  Save the file.

Now  rebuild the solution to see if there is any error.

After builing solution successfully, create the solution package using WSP builder.

Now add the solution to the server. Deploy it globally.

You can see the change to “My” from “My site ” at the top link.




Hope It will helpful.



Posted in Mysite, SharePoint Blogs | Tagged: , , | 1 Comment »

Unable to Delete Share Service Providers (SSP) in SharePoint 2007 (MOSS)

Posted by fillzephyr on June 23, 2009

I am trying to delete two SSP from my environment and I am always getting this error:

An object in the SharePoint administrative framework, “SharedResourceProvider Parent=SPFarm”, could not be deleted because other objects depend on it.  Update all of these dependants to point to null or different objects and retry this operation.  The dependant objects are as follows:

– here I don’t see any dependencies (that’s really makes me wonder what’s happening)

I tried both ways to delete SSPs from central admin as well as using STSADM command:

stsadm –o deletessp –title “SSPName”

When I go to the Manage this Farm’s Shared Services Then my both SSPs are shown as unprovisioning.

I went through this simple way of deleting ssp.

First of all I find the Object id of my SSP. To come out through this I open the SQL Server Management Studio gone to the Objects table.

Under Databases>sharepoint_config_DBName > tables > dbo.Objects

And run the following select query

SELECT * FROM [SharePoint_Config_ DBName].[dbo].[Objects]

where name like ‘SSPName’

and find out the ID of my ssp.

Then I run the following stsadm command:

Stsadm -o deleteconfigurationobject -id “id retrieved from object table”

And still it gives me the same above error.

(In most of the cases after running above cmd when you try to delete SSP it works , but not in my case)

I then try this other way:

I find out that the object status of my ssp is “3” which should be 0 by default, so to convert it to 0 I run the following update query on my objects table

UPDATE [SharePoint_Config_ DBName].[dbo].[Objects]

SET [Status] = 0 WHERE objects.name=’SSPName’

It sets my status to 0.

When I go to the Manage this Farm’s Shared Services and refresh it the unprovisioning warning sign gone.

Now I tried to delete ssp using stsadm still the same error and the ssp shows unprovisioning warning sign again. I check in the object table and it shows me the status update to 3. I again change the status and make it to 0.

Now I want to delete the row with the object id of my ssp as I feel it’s an orphaned. I find the object id running select query.

SELECT * FROM [SharePoint_Config_ DBName].[dbo].[Objects]

where name like ‘SSPName’

then find the dependencies running the following query on dependencies table loacte

Under Databases>sharepoint_config_DBName > tables > dbo. Dependencies

SELECT * FROM [SharePoint_Config_DBName].[dbo].[Dependencies]

where [ObjectId] = ‘EBE75FD3-4EA3-4BF0-BC15-E796A0F7BC21’

check the dependencies.

Then delete it using the following query on dependencies table

Under Databases>sharepoint_config_DBName > tables > dbo. Dependencies

DELETE FROM [SharePoint_Config_ DBName].[dbo].[Dependencies]

WHERE [ObjectId] = ‘EBE75FD3-4EA3-4BF0-BC15-E796A0F7BC21’

Now I try to delete the unnecessay SSP and it is deleted through the Central Admin.

Hope it will help you out in issues of deleting the SSP.


Read the rest of this entry »

Posted in Errors, SharePoint Blogs | Tagged: , , , , | 8 Comments »

Change number of site collections view in Site Collection List

Posted by fillzephyr on May 14, 2009

Go to

Central Administration>Application management> Site Collection List

Default you can see 10 site collections in a list at a time.

I want to change it to 20 as I have 376 site collections and I don’t want to go long way to click for more pages.

So to change it I go to

C:\Program Files\Common Files\Microsoft Shared\web server extensions\ 12\ TEMPLATE\ ADMIN\sitecollections.aspx

Open sitecollection.aspx page

Find PageSize and do the following thing:

change the number 10 to your “specified number” in PageSize=” your number”


Posted in MOSS Funstuff | Leave a Comment »

Solutions Deployment Hungs up on Deploying/retracting in MOSS 2007

Posted by fillzephyr on May 11, 2009

Problem: During the execution of a retraction/deployment the timer job may hang showing ‘Retracting’ or ‘deploying’ and never completes

Cause: This is cause from one of the WFE not being able to finalize the retraction or deployment.

Solution: For each WFE in the farm execute a stsadm.exe -o execadmsvcjobs. I had follow up these two good articles to come out from deploying /retracting status.



But what next when I try to deploy/retract the solution again. It hung’s up.  So I tried to figure out whats the problem causing this thing. I checked in my Timer job status (Central Administration>Operations>Timer Job Status) and it show that the Solution is tried to deploy on my one WFE and the index server.   I had not found any deployment on my other WFE So I had executed the command stsadm.exe -o execadmsvcjobs manually on the other WFE server. And it works like a charm the solution deployed/retracted successfully.

Also I had tried to check the time of my servers and my CA web application to confirm that they both are on the same time zone sometime this may also create a problem for deploying/retracting the solutions on the servers. In my case they are on the same time zone. To check the time zone for your CA site just


Central Administration>Application Management>Web Application General Settings

Select your central administration web application. In Default Time Zone just checks out the time to match with your servers. If it’s not matched then select the appropriate time zone and click OK.


Feedback appreciated.

refrences :




Posted in Errors, SharePoint Blogs, Uncategorized, Warnings in MOSS | Tagged: , , , | 4 Comments »

An error occurred accessing a data source. An entry has been added to the Windows event log of the server. Log ID:5566

Posted by fillzephyr on May 3, 2009

I tried to open the InfoPath form from the form library as web-browsable form and I fall on to this error:

An error occurred accessing a data source. An entry has been added to the Windows event log of the server.

Log ID: 5566

The cause of this error is the installation of .net 3.5 SP1. So to resolve this error you have to add key to the registry on all of the servers I have 2 WFE and 1 Application server. I had change the registry key on the entire server and restart the servers. The first server I restart is of course WFE on which my CA resides and the other WFE and then Application server. I think it’s always best to change first in Server on which CA resides.

I had followed these steps on all my servers and it works for me:

  1. Click Start, click Run, type regedit, and then click OK.
  2. Locate and then click the following registry subkey: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa
  3. Right-click Lsa, point to New, and then click DWORD Value.
  4. Type DisableLoopbackCheck, and then press ENTER.
  5. Right-click DisableLoopbackCheck, and then click Modify.
  6. In the Value data box, type 1, and then click OK.
  7. Exit Registry Editor.
  8. Restart the computer.

Reference: http://support.microsoft.com/kb/926642

Posted in Errors, infopath | Tagged: , | 6 Comments »

The server is currently being taken down for maintenance. Check with your system administrator to see when this server is scheduled to come back online.

Posted by fillzephyr on May 3, 2009

I had setup a new farm with 2 WFE and 1 Application server in an x64 production. I had to move a few site collections from a dev environment to prod environment. I had the farm installed with the MOSS SP1. The dev environment is with the latest February cumulative updates. So when I move the site collections it will give me error that the site is not going to be restoring as the prod environment is not up to date to the dev environment and so I run the February cumulative updates. And then restore the site and it went successfully. After few days I got a task of uploading some InfoPath forms and then I got this error.


The reason for this error is that the Server farm is in a Quiescent Condition.  So I gone to the Operations in CA and then under the the Global Configuration there is an option of Quiesce Farm.

Go to Central Administrator->Operations->Global Configuration-> Quiesce Farm

I click on it and I check the farm conditions and it shows me the status as Quiesced.

As shown below:


Set the minutes to 3  min and then click reset farm.

After the farm reset I tried to upload the form and it went well for me.

Refrence :  http://wssv3faq.mindsharp.com/Lists/v3%20WSS%20FAQ/DispForm.aspx?ID=242


Posted in Errors, infopath | Tagged: , , | 1 Comment »

Change MySite Web application

Posted by fillzephyr on April 20, 2009

When first My site is created its url is http://moss:23478/ I want to change to something good url name like http://Mysite . So I had done following steps.

Create a Web Application:

Go to

Central Administration > Application Management > Create or Extend Web Application > Create New Web Application

IIS Web Site:

Create a New IIS website Description: Mysite

Port: 80

Host Header: Mysite

Path: C:\Inetpub\wwwroot\wss\VirtualDirectories\mysite

Security Configuration:

Authentication Provider: NTLM

Allow Anonymous: No

Use SSL: No

Load Balance Url: http://Mysite:80

Application Pool:

Create New Application Pool:

Application Pool Name: Sharepointpool_mysite


Username: farmadmin

Password: **********

Restart Manually

Database Name and Authentication:

Database Server: XYZ


Hit OK

Create A Site Collection:

Go to

Central Administration > Application Management > Create Site Collection

Web application: http://mysite

Title: Mysite

Website Addresses: http://mysite / (root site)

Select a Template: Enterprise > My Site Host

Username: Farmadmin

Select a Quota Template: No Quota

Hit OK

Create Managed Paths:

Go to

Central Administration > Application Management > Defined Managed Paths

Web Application: http://mysite

Add a New Path:

Path: personal

Type: wildcard inclusion

(Check url)

Hit OK

Modify SSP Settings for My sites:

Go to

Shared Services Administration: Shared services > My Site Settings

Personal site services:

Personal site provider: http://mysite

Personal site Location:

Location: personal

Hit OK

Now go and click on My site Links on the top and it will create your personal site using:





Posted in Mysite, SharePoint Blogs | Tagged: , , | 4 Comments »

Event ID 5586

Posted by fillzephyr on April 17, 2009


Event Type:     Error

Event Source:   Windows SharePoint Services 3

Event Category: Database

Event ID:       5586

Date:           4/16/2009

Time:           3:52:09 PM

User:           N/A

Computer:       MOSSPRD


Unknown SQL Exception 515 occured. Additional error information from SQL Server is included below.

Cannot insert the value NULL into column ‘permission path’, table ‘tempdb.dbo.#temp_______________________________________________________________________________________________________________000000000657’; column does not allow nulls. INSERT fails.

The statement has been terminated.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp

Resolution :

I was struggling with this error. I had a colleague who had setup the farm with the service account set to SA for the SQL Server.  After the farm is setup the backend SQL server’s cluster got collapsed. The Database team backup and restore the all databases including the config and all other databases. After restoring database the permission of the Service account is set to DBcreator and DBsecurity. Now when I go and try to create the webapplication from central admin and STSADM. I got this error “Unknown Error” , when i check in event viewer in application i see error of event ID 5586. I had Google about these errors but I can’t find any solution on net. When I discussed with my colleague and then gone to the database team to solve this problem. We had checked everything from the database user mail configuration settings and other stuffs it’s all set to be perfect. Still we are getting this error. At the end when we change the Service Account Permission to the SA and try to create to Webapplication, I am able to create it. Also I tried to create a root site collection and it works perfectly fine. I don’t find the perfect reason what’s creating this error but we can create a web app using Service account as SA. Also to add when I check the config and other database it was seen it was under the person’s name owner who had restore the database, but we had make the service account owner for all the databases related to SharePoint.

Any Feedback appreciated. Also anyone know the reason for these error please let me know.


Posted in Errors, SharePoint Blogs | Tagged: , , | 1 Comment »

Converting Western Digital HD From FAT32 To NTFS

Posted by fillzephyr on February 8, 2009

Go to>Start>Run>type Cmd in “Open” (Hit enter).

Type  cd\ (hit enter )

Type the below command :

C:\>convert I:/fs:NTFS  (hit enter)

[Above I is the drivers location]

This displays the following instruction in command window
The type of the file system is FAT32.
Enter current volume label for drive I: (“it should be the name of external HD in my case it is “MyPassport“)

MyPassport  (hit enter)
Volume MYPASSPORT created 2/8/2009 4:47 PM
Volume Serial Number is 2EE3-6FF1
Windows is verifying files and folders…
File and folder verification is complete.
Windows has checked the file system and found no problems.
488,264,736 KB total disk space.
974,560 KB in 1,374 hidden files.
143,712 KB in 4,486 folders.
75,431,552 KB in 19,240 files.
411,714,880 KB are available.

32,768 bytes in each allocation unit.
15,258,273 total allocation units on disk.
12,866,090 allocation units available on disk.

Determining disk space required for file system conversion…
Total disk space:              488384001 KB
Free space on volume:          411714880 KB
Space required for conversion:   600391 KB

Converting file system

Conversion complete

Posted in General | Tagged: | 2 Comments »