SharePoint Solutions

Issue: Calendar list is Missing in SharePoint 2010

2011-07-28T06:54:00.000-07:00

Issue:
Calendar list is Missing in SharePoint 2010.

Reason:
The required "site feature" may not be activated in the SharePoint portal.

Solution:
1. Go to the "Site Settings"
2. Go to "Manage Site Features"
3. Check "Group Work Lists" feature is activated or not. If not, Activate the feature.

Thats it...

Update:
If you are not able to view / create lists or document library or task library, you need to activate the "Team Collaboration Lists" site feature.

Error occurred in deployment step 'Recycle IIS Application Pool': The local SharePoint server is not available. Check that the server is running and connected to the SharePoint farm

2011-07-07T04:39:00.000-07:00

Error:

Error occurred in deployment step 'Recycle IIS Application Pool': The local SharePoint server is not available. Check that the server is running and connected to the SharePoint farm.

Reason:

You will get this error, when you are trying to deploy the web part/solution through visual studio. The reason is the current logged-in user may not be the "db owner" in the content databases.

Solution:

To deploy the solution successfully, you need to map the current logged-in user as db_owner into the 3 databases.

1. SharePoint_Config

2. SharePoint_Admin_[GUID]

3. Your current web application that needs to deploy the Web part

For more info, check the below screenshot.

Thats it...

The Web application at could not found. Verify that you have typed the URL correctly. If the URL should be serving existing content, the system administrator may need to add a new request URL mapping to the intended application.

2011-06-29T01:18:00.000-07:00

Error:

The Web application at could not found. Verify that you have typed the URL correctly. If the URL should be serving existing content, the system administrator may need to add a new request URL mapping to the intended application.

Solution:

change the visual studio solution to 64 bit in properties as per the below screenshot.

Thats it...

Error: The type or namespace name 'SPSite' could not be found (are you missing a using directive or an assembly reference?)

2011-06-28T06:58:00.000-07:00

Error:

The type or namespace name 'SPSite' could not be found (are you missing a using directive or an assembly reference?)

Reason:

Sometimes you will get this issue, while you are testing/developing your SharePoint code through console applications.

By default, visual studio 2010 will set target framework as ".Net Framework 4 Client Profile"

Solution:
We need to change the target framework as ".Net Framework 3.5"

To do this,

1. Go to Solution property in visual studio.

2. Change the target framework to ".Net Framework 3.5" as below:

3. Save all & build the solution.

Thats it...

Issue: User profiles Sync DB doesn't have Tables or Stored Procedures

2010-11-12T02:48:00.000-08:00

Issue:

While you are trying to import the user profiles in SharePoint 2010, you will get lots of errors. Particularly, we will face some of the issues like below:

1. Forefront Identity Manager Service may not be started.

2. Forefront Identity Manager Synchronization service may not be started.

3. If you see the "eventvwr", you will get some of the errors like below:

Error 1:

The Forefront Identity Manager Service cannot connect to the SQL Database Server.

The SQL Server could not be contacted. The connection failure may be due to a network failure, firewall configuration error, or other connection issue. Additionally, the SQL Server connection information could be configured incorrectly.

Verify that the SQL Server is reachable from the Forefront Identity Manager Service computer. Ensure that SQL Server is running, that the network connection is active, and that the firewall is configured properly. Last, verify the connection information has been configured properly. This configuration is stored in the Windows Registry.

Error 2:

.Net SqlClient Data Provider: System.Data.SqlClient.SqlException: Could not find stored procedure 'RegisterService'.

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

at Microsoft.ResourceManagement.Data.DataAccess.RegisterService(String hostName)

Error 3:

The Forefront Identity Manager Service was not able to initialize a timer necessary for supporting the execution of workflows.The Forefront Identity Manager Service could not bind to its endpoints. This failure prevents clients from communicating with the Web services.

Error 4:

A most likely cause for the failure is another service, possibly another instance of Forefront Identity Manager Service, has already bound to the endpoint. Another, less likely cause, is that the account under which the service runs does not have permission to bind to endpoints.

Ensure that no other processes have bound to that endpoint and that the service account has permission to bind endpoints. Further, check the application configuration file to ensure the Forefront Identity Manager Service is binding to the correct endpoints.

Solution:

I have spent lots of time to fix this issue. Hmmmm... The solution is in SQL server side. In SQL Server database, you cannot find any "tables" or "Stored Procedures" in "Sync DB"

I have given the solution in single screenshot. In the below screenshot, set the "db_owner" schema for "dbo".

If you set the "dbo" as "db_owner", you can able to start the "Forefront Identity Manager Service". so that you will be able to start the profile import process.

Update:
The same permission should be assigned to all user profile service databases like "Profile DB", "Social DB".

Also you need to restart the below services
1. Forefront Identity Manager service
2. Forefront Identity Manager Synchronization Service
3. IIS

Thats it...

Error: The form cannot be rendered. This may be due to a misconfiguration of the Microsoft SharePoint Server State Service. For more information, contact your server administrator.

2010-11-02T07:34:00.000-07:00

Error:

The form cannot be rendered. This may be due to a misconfiguration of the Microsoft SharePoint Server State Service. For more information, contact your server administrator.

Reason:

You will get this error while you are trying to view the InfoPath forms in browsers. The reason is, the "State Service" may not be enabled/associated for the current web application.

Solution:

Check all the below possibilities...

(Note: I assume that you already know how to develop a browser compatible InfoPath forms)

1. Go to "Application Management" --> "Manage service applications"

2. Check whether the "State Service" is enabled or not (like the below screenshot).

3. If the service is not started or missed, we should configure/start the state service. OK. How to start the service? proceed with step 4.

4. Go to the "Configuration Wizard" and start the configuration

5. Make sure the "State Service" is enabled. (Eventhough it is selected, run the wizard again.Hmmmm...That is microsoft :) )

6.Wait until you see the below screen (It will take few minutes to complete).

7. Now, check whether the InfoPath forms are rendering properly in the browser or not. If everything is fine, then continue with your work.. Again if you are getting the same error screen, you need to check the "Service Associations" for your current web application (proceed with step 8).

8. In "Central Administration", Go to "Application Management" and select the "Configure service application associations" in "Service Applications" section.

9. Click on your web application and a pop up windows will be displayed.

10. Select the "State Service" Check box and click "OK".

11. Now you can able to view the InfoPath forms in browser like below.

Thats it...

Error: The installed virus scanner is currently unavailable. If the problem persists, contact your administrator.

2010-11-02T06:49:00.000-07:00

Error:

The installed virus scanner is currently unavailable. If the problem persists, contact your administrator.

Reason:

You will get this error, while you are uploading/downloading a document in SharePoint 2010 portal (single/multiple file upload). The configured Antivirus setting will not let you to do the upload/download operations.

Solution

1. Go to Central Administration.

2. Go to "Security" section.

3. In "General Security" tab, go to "Manage antivirus settings".

4. in "Antivirus settings" section, remove the tick marks from "upload" and "download" options.

5. Click "OK"..

6. Now try to upload the documents in SharePoint web application. Documents will be uploaded successfully.

Thats it...

Note: This is temporary solution and it is not recommended in live scenarios, due to security concerns.

Error: Unable to create or access workbook cache at C:\WINDOWS\TEMP\Excel Server\FileCache\SharedServices1-1078443246\Ranges. Excel Services is unable to function without a workbook cache

2010-10-12T07:59:00.000-07:00

Error:

Unable to create or access workbook cache at C:\WINDOWS\TEMP\Excel Server\FileCache\SharedServices1-1078443246\Ranges. Excel Services is unable to function without a workbook cache.

(you can see this error in Event viewer)

Reason:

Unknowingly you may have deleted the above mentioned folders. So, Excel services is not able to save the temporary files under the "Ranges" folder.

Solution:

Login inside the SharePoint server and create the "Ranges" folder as per the above mentioned folder structure. If you are not able to see the "Excel Server" folder inside "C:\Windows\Temp" folder, just create it manually.

If you see any other error like this, create the missing folder.

Thats it...

Error: The Managed Metadata Service or connection is currently not available. The Applicaiton Pool or Managed Metadata web service may not have been started. Please contact your Administrator.

2010-10-11T03:59:00.000-07:00

Error:

The Managed Metadata Service or connection is curretnly not available. The Applicaiton Pool or Managed Metadata web service may not have been started. Please contact your Administrator.

Reason:

The "SharePoint web services root" site may be stopped in your IIS.

Solution:

Just follow the solution that I have given in my another post

http://sensoft2000-sharepoint.blogspot.com/2010/10/error-security-token-service-is-not.html

Now, you will be able to see the MetaData service in your central admin.

Thats it...

Error: The Security Token Service is not available. The Security Token Service is not issuing tokens. The service could be malfunctioning or in a bad state.

2010-10-11T03:24:00.000-07:00

Error:

The Security Token Service is not available.
The Security Token Service is not issuing tokens. The service could be malfunctioning or in a bad state.

(Or)

An exception occurred when trying to issue security token: Could not connect to http://localhost:32843/SecurityTokenServiceApplication/securitytoken.svc. TCP error code 10061: No connection could be made because the target machine actively refused it 127.0.0.1:32843.

(Or)

The Managed Metadata Service '' is inaccessible.

Reason:

These are all unusual errors and you will get these kind of errors, if you have installed the SSL certificate on your SharePoint server. In my situation, I have installed SSL & Lync Server 2010 RC in my SharePoint 2010 server.

Solution:

I found an very nice post about this issue in the below URL:

https://blogs.blackmarble.co.uk/blogs/rhepworth/archive/2010/01/07/reassigning-the-correct-ssl-certificate-to-sharepoint-2010-web-services-iis-site.aspx

But unfortunately, the above post is not useful for me. Anyhow, it gave me some ideas about the actual issue. Finally I have found an simple solution.

1. Go to InetMgr

2. Just start the "SharePoint Web Services" site and "SharePoint Web Services Root" application pool as per the below screenshot.

3. To make sure, do the "IISReset".

Thats it....

Error: E-mail to owner could not be sent.

2010-09-15T02:46:00.000-07:00

Error:

E-mail to owner could not be sent.

Reason:

You will get this error, when you are trying to send "Request Access" in SharePoint 2010. Because, the system could not send request to the specific portal administrator, since the email address of the portal administrator may be wrong or empty.

Solution:

1. Go to the "Site Actions" --> "Site Permissions" as per the below image.

2. Click on the "Manage Access Rights" option in the Ribbon Menu.

3. Provide the correct and valid email-id in the pop-up.

4. Now, you will be able to send request successfully and the success message will be displayed like below:

Thats it...

Error: Access Services is unable to process the request.

2010-08-10T00:00:00.000-07:00

Error:

Access Services is unable to process the request.

(or)

Unrecognized attribute 'allowInsecureTransport'. Note that attribute names are case-sensitive. (C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\WebClients\Bdc\client.config line 36)

(or)

Reason:

You will get this error, when you are trying to create any site using "Access Database service" like BDC or "Project Database" templates. The reason is Microsoft missed to update a patch in Windows 7.

Solution:

So, download a patch from https://connect.microsoft.com/VisualStudio/Downloads/DownloadDetails.aspx?DownloadID=23806 (Windows6.1-KB976462-v2-x64.msu) and install this in your SharePoint machine.

Note: Don't forget to restart the machine to take effect.

That's it...

Error: No Access Database Service is available in the farm.[User: SHAREPOINT\system].

2010-08-09T08:02:00.000-07:00

Error:

No Access Database Service is available in the farm.[User: SHAREPOINT\system].
(or)
No Access Data Services is available in the farm.

Reason:

You will get this error, when you are trying to create any site using "Access Database service" like BDC or "Project Database" templates. The reason is "Access Database Service" may not be started.

Solution:

Just follow my below steps:

1. Go to central admin

2. Then go inside the "Application management"

3. Under the "Service Applications", select "Manage services on server"

4. In this page, "Access database service" may be stopped.

5. Click to "Start"

Thats it...

Error: Method not found: 'Microsoft.SharePoint.Administration.SPContentDatabase Microsoft.SharePoint.Administration.SPContentDatabaseCollection.Add(System.String, System.String, System.String, System.String, Int32, Int32, Int32, Boolean, Boolean)

2010-08-04T04:54:00.000-07:00

Error:

Method not found: 'Microsoft.SharePoint.Administration.SPContentDatabase Microsoft.SharePoint.Administration.SPContentDatabaseCollection.Add(System.String, System.String, System.String, System.String, Int32, Int32, Int32, Boolean, Boolean)

Reason:

You will get this error while you are trying to add the content database in central admin for any of the existing website.

This is because of some bug in the MOSS 2007 SP2

Solution:

Anyhow you can easily add the content DB using the STSADM tool. Just go to the 12 hive folder in command prompt and type the below command.

stsadm -o addcontentdb -url "http://weburl:5005" -databasename "Your Content DB Name" -databaseserver "Your DB Server"

Thats it....

Error: Your Personal site cannot be created because Self-Service Site Creation is not enabled. Contact your site administrator for more information.

2010-08-03T05:44:00.002-07:00

Error:

Your Personal site cannot be created because Self-Service Site Creation is not enabled. Contact your site administrator for more information.

Reason:

As mentioned in the error message, the "Self-Service Site creation" is not enabled in your central admin.

Solution:

To enable the "Self-Service Site creation" option, just follow the steps given below:

1. Go to the Central admin.

2. Go to the "Application Management" & Select the specific web application.

3. Now, you can see the "Self-Service Site Creation" option in the Ribbon Menu.

4. Click on that Menu item and Select the "On" option in the pop-up window.

5. Click "OK" and now click the "My Content" link from your "My Site" site. You can see the "Processing" screen which means that your steps are correct.

6. Now you can see the newly created personal site. Here, you can create your own blogs, documents, etc...

Thats it...

Error: Your personal site cannot be created because the managed path "personal" has not been created for this site. Contact your site administrator for more information.

2010-08-03T05:26:00.000-07:00

Error:

Your personal site cannot be created because the managed path "personal" has not been created for this site. Contact your site administrator for more information.

Reason:

You haven't added the "Managed Path" for the the "My Site".

Solution:

Just follow the below steps to add "Personal" path as "Managed Path".

1. Go to "Central admin"

2. Select "Application Management" and select the specific "Web Application".

3. Type the 'MySite Host' URL as I mentioned in the above image. (I have created new site collection for MySite. So, I have added 'sites/mysite/personal' in the above screenshot).

4. Click OK.

Thats it...

In SharePoint 2010, MySite is not Working

2010-08-03T01:31:00.000-07:00

Issue:

In SharePoint 2010, If you click on the "people", usually you will be redirected to see their profiles page (My Site). But sometimes, you will get "404 file not found" error.

Reason

The reason is, the "my site" may not be created for the profile or the created profile pages may not be crawled at this time.

Solution:

To avoid this kind of issues, first we must ensure some of the mandatory points given below:

1. You must create a Site collection from central admin or web application with "Search Center" template.

2. Create another subsite with "My Host Site" template from "Enterprise" tab through Central admin.

3. Then goto "User Profiles Service Application" home page and select the "Setup My Sites" from "My Site Settings" section.

4. In the next screen, type the search center web application URL under the "Preferred Search center" text box, which we have created in step 1. (Mandatory)

5. Under the "My Site Host Location", Type the URL which we have created in Step 2. (Mandatory)

6. Then Click OK.

3. Then, Start full import from Search service. (Mandatory)

Thats it...

In SharePoint 2010, Normal search is working and People search result is not working fine. Why?

2010-08-03T01:08:00.000-07:00

Issue:

Finally, you may have configured the user profiles synchronization & Search services. Also, you may be able to see the number of profiles under "User profile service" and contents under "Search Service".

Then, If you have used the search box and search results web parts to display the web application contents (not people), you can able to see the documents, forms, pages, etc... But, you cannot see the "people", if you click on the "people" tab in search results page. (or) you cannot see the results, if you have used the "peopleresults" web part.

What will be reason? :)

Reason:

You may have forgot to add the URL to crawl the people in Search service "ContentSource". So, just add the exact url which will start "SPS3://".

Example:

SPS3://km.sensoft2000.com (just an example)

Thats it....

Error: The management agent failed on run profile "DS_FULLIMPORT" because of connectivity issues

2010-08-03T00:54:00.000-07:00

Error:

The management agent failed on run profile "DS_FULLIMPORT" because of connectivity issues.

Reason:

You will get this error during the profile import from "User Profile Service" of SharePoint 2010. The reason is the domain name may be mismatched with the actual domain name. Because, you will use the domain name like "sensoft" (just an example). But the actual domain may be different in Profile AD. for example, the actual domain name will be "sensoft.local" for "sensoft". So, you have to change the actual domain name in the "Synchronization Service Manager".

Solution:

To resolve this error, just follow the below steps:

1. Login into the SharePoint 2010 server.

2. Open the Synchronization Service Manager from C:\Program Files\Microsoft Office Servers\14.0\Synchronization Service\UIShell\miisclient.exe

3. Go to "Management Agents" tab & select the "Active Directory Domain Services" type

4. Double click on it & Select "Connect to ActiveDirectory Forest"

5. The domain name may be different than the profile "Connection string" provided in the central admin. Give the correct domain name and press "OK". If there is any error, you will get error in this step itself.

6. Again rigth click on your "Ad Profile Connection string" & click the "Run".

7. Select "Full Import" option in the next Pop-up window.

8. Your profile will be crawled successfully, if there is no connectivity error.

9. If you are getting any connectivty error, check my another post, "http://sensoft2000-sharepoint.blogspot.com/2010/08/error-replication-access-was-denied.html"

Thats it...

Error: Replication access was denied. error code: 8453

2010-08-03T00:28:00.000-07:00

Error:

Replication access was denied. error code: 8453

Reason:

You will get this error, while you are trying to crawl the people from Active directory in SharePoint 2010.

During the people search configuration, the the number of people will not be crawled in SharePoint 2010. Also, you cannot get the actual error straightaway. The right way to get the actual error message is, you have to use the Synchronization service manager. You can get this tool inside the SharePoint server at the below path:

C:\Program Files\Microsoft Office Servers\14.0\Synchronization Service\UIShell\miisclient.exe

In this tool, if you "Run" the Profile Import, under the "Operations" tab, you will get the above error message. The error screenshot may be like below:

Solution:

The resolve this issue, we must provide the access rights to the service account of the "User Profiles" service. OK. What kind of access rights needs to be provided?

The user should have the "Replicating Directory Changes" Permission in the active directory. To provide this rights to the "service account" user, follow the below steps:

1. Login into the Active directory server.

2. Open the "Active Directory Users and Computers" console. (C:\WINDOWS\system32\dsa.msc)

3. Right click on the "Domain name" and goto "properties".

4. Go to security tab and Select the specific service account user. (If the user is not listed, you can add the user by clicking the "Add" button in the same screen).

5. Scroll the Permissions and select the "Replicate Directory Changes" option like the below image.

Thats it...

Error: Access is denied. Verify that either the Default Content Access Account has access to this repository, or add a crawl rule to crawl this repository. If the repository being crawled is a SharePoint repository, verify that the account you are using has "Full Read" permissions on the SharePoint Web Application being crawled.

2010-07-29T06:01:00.000-07:00

Error:

Access is denied. Verify that either the Default Content Access Account has access to this repository, or add a crawl rule to crawl this repository. If the repository being crawled is a SharePoint repository, verify that the account you are using has "Full Read" permissions on the SharePoint Web Application being crawled.

Reason:

This error will occur, at the time of crawling the SharePoint application content. because, you may have provided a URL to access the SharePoint web application like http://kmportal.sensoft2000.com (just an example).

When the search engine tried to crawl the content using the kmportal.sensoft2000.com URL, the server will reject the request. because, it will take the request as "LoopBackRequest".

Solution:

So you need to disable the LoopBackRequest in registry. To do this, just follow my instructions:

1. Go to command window and type regedit.exe

2. Once opened the registry editor, just navigate to "HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa"

3. Right click on "Lsa" and create a new 32bit DWORD value

4. Rename it as "DisableLoopbackCheck" (Note: you cannot rename it actually. so, once created the DWORD value, directly paste/type as "DisableLoopbackCheck".

5. Then again modify the value of "DisableLoopbackCheck" as "1"
6. Close the registry editor.
7. Now start to crawl the content.

Thats it...

Issue: Multiple login prompts while browsing a SharePoint application

2010-07-13T07:45:00.000-07:00

Issue:

Sometimes, you will be prompted to type the Login credentials to enter into the SharePoint application.

(Amazingly, this will not occur in Firefox)

Reason:

Because, all your browser requests may be processed through the proxy. So the response will be passed through the proxy and the converted HTML output will be displayed in browser. So, the browser will trying to access the SharePoint application's resources (like images, css) directly through the HTTP. By default, nobody can access the SharePoint resources directly in the browser and they can be accessed only if he is the authorized person.

I meant, this kind of access is equivalent to access a image directly from SharePoint image library in browser like, http://sensoft2000-sharepoint.blogspot.com/Images/Logo.jpg (Just an example).

Solution:

You have to add the URL in trusted sites zone of the IE and the URL should be added in exception list.

Just follow the below mentioned steps to fix this issue.

Open the IE browser
Go to Tools and click internet options
Then Click "Security" tab
Select "Trusted Sites"
Click "Sites" button
Type your URL in the text box and click "Add" button.
Click "Close" button
Click "Apply" button
Go to "Connections" tab
Click "LAN Settings" button
Here your "Proxy Server" check box may be checked already.If not, Select it
Click "Advanced" button
Now, you will see a Text area in the "Exceptions" panel.
Here you have to add your URL. for example, if your URL is like http://moss.sensoft2000.com (example), then you need to add the URL as mentioned in the below screenshot *.sensoft2000.com.

Thats it...

Error: Cannot navigate to the requested page while User Profile Synchronization is running. Please wait for the current Synchronization run to finish.

2010-07-12T08:24:00.000-07:00

Error:

Cannot navigate to the requested page while User Profile Synchronization is running. Please wait for the current Synchronization run to finish.

Reason:

You will get this error, in case if you are trying to "Import the User profiles" in SharePoint 2010. Sometimes, "The user profile sync" job may not be running or it may be in "Starting" stage for a long time.

You can check this status in central admin as I said below.

In central admin, go to "Monitoring" link
Then go to "Review Job definitions" under "Timer Jobs"
Then click the "Running Jobs" link in left hand side.

Here you can see that the sync job will be running continuously. Reason is the required services may not be ready after the SharePoint 2010 installation.

So, what to do?

Solution:

Solution is very simple. Just login into the SharePoint server and go to the command prompt with administrator privileges (right click on the "Command Prompt" icon and select the 'Run as Administrator' option).

Then, just type "IISReset" to reset the IIS.

Now you can come and check the Running Jobs link as I mentioned above.

Thats it...

Error: The context has expired and can no longer be used. (Exception from HRESULT: 0x80090317)

2010-07-12T06:15:00.000-07:00

Error:

The context has expired and can no longer be used. (Exception from HRESULT: 0x80090317)

Reason:
1. Security context of your session may be expired.
2. You/somebody may have changed the date/time in the server.

Solution:
1. Just change/update the Date/Time in the SharePoint server.
2. Increase the Security context in SharePoint central admin. This can be done by following the below steps:

Go to central admin
Go to "Application management section"
Go to "Web Application General Settings"
Go to "Web page Security validation" section & increase the timeout field. Or, you can simply disable this option.

Thats it...

Error: CREATE TABLE permission denied in database . at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

2010-07-09T03:12:00.000-07:00

Error:
CREATE TABLE permission denied in database . at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

Reason:

You will get this error, when you are trying to create a new SharePoint web application using the ATTACHED DATABASE through the central admin. Because, your central admin user (that is current user to create a website) may not having a permission to create tables dynamically in the SQL Server.

Solution:

Solution is very simple. Just attach the database in SQL Server using the current user of the central admin as the owner of the DB. (But it takes long time for me to find out the exact reason).

For example, If your current central admin logged-in username is "domain\senthil" (Assumes, senthil is going to create a new web application) , then you should attach the database using the "domain\senthil" username.

You can change the owner of the database during the "Attach databases" as per the below screenshot.

Thats It...

"New" ribbon icon disabled in central admin

2010-06-22T03:09:00.000-07:00

Issue:

You cannot see the "New" icon in the Ribbon menu, when you are trying to create any new web application or service through SharePoint 2010 central admin in windows 7 machine.

Reason & Solution

The reason is very simple. The Internet explorer is not opened using the administrator privileges. So, Open the Internet Explorer with "Run as Administrator" privileges. How to do this?

OK, I will explain you the steps here.

1. Just right click on the IE icon.

2. There you can see a menu as "Run as Administrator".

3. In IE, browse the application. You can see the "New" icon in Ribbon menu as below:

Thats it...

Getting Blank page instead of Central Admin after installing SharePoint 2010 in Windows 7

2010-06-22T01:33:00.001-07:00

Issue:

You will get a blank page instead of Central admin page when you are trying to access the central admin page after installed and configured the SharePoint 2010 software in windows 7 machine.

Reason:

By default, some of the authentication providers may not be installed in Windows 7 machine (inside IIS). You can check the list of authentication providers by double click on the central administration site in IIS. See the sample screenshot below.

If you double click in the "Authentication" link as I specified in the above image, you cannot see the below authentication mechanisms:

1. Windows Authentication

2. Basic Authentication

3. Digest Authentication

If they are existing, they may not be enabled.

Solution:

To add these authentication mechanisms in IIS, open the Command Prompt and type the below command. Then, wait for 2 minutes.

Command

start /w pkgmgr /iu:IIS-WebServerRole;IIS-WebServer;IIS-CommonHttpFeatures;IIS-StaticContent;IIS-DefaultDocument;IIS-DirectoryBrowsing;IIS-HttpErrors;IIS-ApplicationDevelopment;IIS-ASPNET;IIS-NetFxExtensibility;IIS-ISAPIExtensions;IIS-ISAPIFilter;IIS-HealthAndDiagnostics;IIS-HttpLogging;IIS-LoggingLibraries;IIS-RequestMonitor;IIS-HttpTracing;IIS-CustomLogging;IIS-ManagementScriptingTools;IIS-Security;IIS-BasicAuthentication;IIS-WindowsAuthentication;IIS-DigestAuthentication;IIS-RequestFiltering;IIS-Performance;IIS-HttpCompressionStatic;IIS-HttpCompressionDynamic;IIS-WebServerManagementTools;IIS-ManagementConsole;IIS-IIS6ManagementCompatibility;IIS-Metabase;IIS-WMICompatibility;WAS-WindowsActivationService;WAS-ProcessModel;WAS-NetFxEnvironment;WAS-ConfigurationAPI;WCF-HTTP-Activation;WCF-NonHTTP-Activation

The command will be executed and you can see in IIS that these authentication mechanisms will be added. See the sample screenshot below:

Please make sure that the Windows Authentication should be enabled to access the SharePoint 2010 central administration page.

So, now you can browse the central admin page instead of blank page.

Thats it...

Could not load file or assembly 'Microsoft.IdentityModel, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencie

2010-06-21T06:14:00.000-07:00

Error:

Could not load file or assembly 'Microsoft.IdentityModel, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.System.IO.FileNotFoundException: Could not load file or assembly 'Microsoft.IdentityModel, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.

Reason:

"Windows identity foundation pack" may be missed from your machine.

Solution:

Download the pack from http://www.microsoft.com/downloads/details.aspx?FamilyID=eb9c345f-e830-40b8-a5fe-ae7a864c4d76&displaylang=en and install it in your Windows 7 machine.

An exception of type Microsoft.SharePoint.Upgrade.SPUpgradeException was thrown. Additional exception information: Failed to call GetTypes on ....

2010-06-21T06:06:00.000-07:00

Error:

An exception of type Microsoft.SharePoint.Upgrade.SPUpgradeException was thrown. Additional exception information: Failed to call GetTypes on assembly Microsoft.Office.Server.Search, Version=14.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c. Could not load file or assembly 'System.Web.DataVisualization, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35' or one of its dependencies. The system cannot find the file specified.

Reason:

You will get this error, when you are trying to configure the SharePoint 2010 central admin (SharePoint product configuration wizard). The reason behind the error is, you might not installed the "Chart Control" in your windows 7 machine.

Solution:

So, download the chart control from http://go.microsoft.com/fwlink/?LinkID=122517 and install it.

Thats it...

The specified SPContentDatabase Name=WSS_Content Parent=SPDatabaseServiceInstance Name=MSSQL2008 has been upgraded to a newer version of SharePoint.

2010-04-15T01:52:00.000-07:00

Error:

The specified SPContentDatabase Name=WSS_Content Parent=SPDatabaseServiceInstance Name=MSSQL2008 has been upgraded to a newer version of SharePoint. Please upgrade this SharePoint application server before attempting to access this object.

Reason:

This error may occur, if you are trying to attach the SQL server 2008 "MDF" file in SQL Server 2008 (No typo :) ) and the SharePoint Version is MOSS 2007 with no service packs.

Solution:

Just install the WSS service pack 2 & MOSS service pack 2. Now, you can attach the database without any issue.

For more info, refer my another post here

Thats it...

Issue: "Create or extend web application" link is missing in Central Admin

2010-04-12T03:52:00.000-07:00

Issue:

"Create or extend web application" is missing in Central Admin.

Reason:

1. Because, the current browsing user may not have the rights to create the Web application.

2. You may be browsing within "Windows Server 2008"

3. You may be browsing within the MOSS server

Solutions:

Solution 1:

Browse the Url from outside MOSS 2007 server

Solution 2: (Suggested solution)

1. Right click on the browser icon.

2. Select "Run as Administrator" option.

3. Now, go to the central admin url and you can see the "Create or extend web application" link.

Thats it.

"Save site as template" Missing in MOSS 2007

2010-04-12T03:13:00.000-07:00

Issue:

Sometime "Save site as template" link may be missed in MOSS 2007.

Solution:

Usually this link will be available in the "Site Actions" --> "Site Settings" area. This may be missed sometimes, if you upgrade your team site into "Publishing Site". (i.e. If you forced to convert as a publishing site through the STSADM command). Then, How can we save the site template?

Still there is an answer. Just type the below command in browser after the site name & port (without quotes).

"/_layouts/savetmpl.aspx"

For example:

http://172.16.10.10:5002/_layouts/savetmpl.aspx

Later, you can download this template from "Site Template Gallery" (under Site Actions --> Site Settings).

For Example:

http://172.16.10.10:5002/_catalogs/wt/Forms/Common.aspx

Thats it...

Error: Some or all identity references could not be translated

2010-01-19T04:44:00.000-08:00

Error:

Some or all identity references could not be translated.

Reason:

You will get this error, when you migrate your server domain from one to another. Coz, your farm administrator domain also will be changed.

Solution:

1. Go to command prompt.

2. Navigate to STSADM tool folder.

3. type the below command

stsadm.exe -o updatefarmcredentials -userlogin "NewDomain\Admin" -password "Password"

4. Reset the IIS.

Thats it...

Error: Content deployment job '' failed.The remote upload Web request failed

2009-12-23T05:48:00.000-08:00

Error:

Content deployment job '<Job Name truncated>' failed.The remote upload Web request failed

Reason:

You will get this error, when you are trying to deploy the content from one sharepoint server to another. You will get this

error, because the destination server name/IP may not be resolved by the deployment job.

Solution:

1. Go to your destination server desktop.

2. Right click on the "My Computer"

3. Click on "Properties"

4. Go to "Computer Name" tab.

5. Copy the Full Computer Name as shown below:

6. Open your host file from "c:\windows\system32\drivers\etc\hosts" in NotePad. (In Source Server)

7. Paste the Server name along with IP address at last as below: (Do not delete/move other texts)

8. Now run the content deployment.

Thats it.

SharePoint: Custom validator or InputFormCustomValidator, Which one is best?

2009-12-17T02:51:00.000-08:00

In some scenarios, you are in a situation to use "CustomValidtors" in your SharePoint WebPart coding (object model). This is very common situation to handle/validate our webpart controls using default validation controls.

But, in SharePoint object model, "CustomValidator" won't fire perfectly in most of the scenarios. Then what to do?

Microsoft Provides an another control called "InputFormCustomValidator". Just explore all the features by using this control. Some of the key points are:

1. For InputFormCustomValidator, we need not to assign the "ControlToValidate" property.

2. We can enforce the "Page.Validate();" method on button click method.

Error: The protocol handler cannot be found. Check that the handler has been installed.

2009-12-11T04:52:00.000-08:00

Scenario:

You will get this error, when you are trying to "Crawl" the content in SharePoint SSP.

Solution

1. Go to Services in the SharePoint server (type "Services.msc" in command prompt and preses 'Enter')

2. Stop the "SharePoint SHarePoint server search", "Windows SharePoint Services Search" & "Windows SharePoint Services" Timer.

3. Start all the 3 services again.

4. Reset the IIS

Thats it...

Error: The form submission cannot be processed because it exceeded the maximum length allowed by the Web.

2009-12-07T03:23:00.000-08:00

Error:

The form submission cannot be processed because it exceeded the maximum length allowed by the Web.

Reason:

Whenever you are trying to upload a file into the SharePoint with more than 50MB, you will get this error.

You can not fix this issues, even if you updated the tag in web.config file.

Solution:

1. Go to Central Admin

2. Open "Web Application Gegenal settings" link

3. There is an option to enter the maximum file size. type 100 MB in that text box. Don't forget to change the web application in the dropdown box.

4. Also, change the HttpRuntime in the web.config as follows:

Thats it...

Error: The application is unable to accept further updates because the last attempt to persist the state failed. See the event log for more details

2009-11-19T23:12:00.000-08:00

Error:

The application is unable to accept further updates because the last attempt to persist the state failed. See the event log for more details

Solution:

Sometimes you will get this error, when you configure the search in sharepoint server. Do the below steps, one by one.

1. Go to central admin

2. Go to Operations Tab.

3. Click on "Services on Server" link and Stop the "Office Sharepoint Server Search"

4. Again, start the "Office Sharepoint Server Search".

5. Go to SSP & Search Settings.

6. Here you have to configure again the search settings.

7. Then, It will take few minutes to complete teh operation. (based on the Timer execution).

Thats it...

How To: Reduce SharePoint database log file size?

2009-10-29T07:38:00.001-07:00

Sometimes, your SharePoint server space may be very low. This is because, the SharePoint server database log will be increased slowly day by day.

For example, you may have 30 or 40 GB free space in C drive, when you installed SQL Server in your database server. After 1 or 2 months, your database server C drive may be very low. So that you will get "Low disk space" error. This is beacuse, the log file size will be high.

So, here I am going to explain, how to reduce the size of the Database log file size to 1MB.

1. First open your SQL Server management studio 2005.

2. Click "New Query"

3. Type the below Command. Here, "WSS_Content_10002" is my database name. replace this text with your database name.

BACKUP LOG [WSS_Content_10002] WITH TRUNCATE_ONLY

USE [WSS_Content_10002]

DBCC SHRINKFILE ('WSS_Content_10002_log' , 1)

Finished. Now, you can see that the free space in C Drive will be increased.

Thats it....

How To: BreadCrumb to show sub folders in Document Library

2009-10-23T05:21:00.000-07:00

Usually, you cannot see the breadcrumb for the Sub folders which are stored in the Document Library. You can see the Breadcrumb links only up to Parent folder (i.e. document library).

So, how to modify the breadcrumb to show the Sub folders too?.

Well..

1. Open SharePoint Desigenr 2007

2. Open that specific web site

3. Go to that document library. Inside you can see a folder with the name of "Forms".

4. Double click to open it.

5. Double click on "AllItems.aspx" file.

6. Within that source, you can see the below code. sometime, the below code will not be available. If the code is not available, add the below code in between any of the 2 Content blocks.

<asp:Content ID="Content1" ContentPlaceHolderId="PlaceHolderTitleBreadcrumb" runat="server">

<asp:SiteMapPath ID="siteMapPath1" Runat="server" SiteMapProvider="CurrentNavSiteMapProviderNoEncode"

RenderCurrentNodeAsLink="false" SkipLinkText="" CurrentNodeStyle-CssClass="breadcrumbCurrent" NodeStyle-CssClass="ms-sitemapdirectional"/>

</div>

</asp:Content>

7. Change the SiteMapProvider value as "SPContentMapProvider" instead of "CurrentNavSiteMapProviderNoEncode"

See the Sample Code below:

<asp:Content ID="Content1" ContentPlaceHolderId="PlaceHolderTitleBreadcrumb" runat="server">

<asp:SiteMapPath ID="siteMapPath1" Runat="server" SiteMapProvider="SPContentMapProvider"

RenderCurrentNodeAsLink="false" SkipLinkText="" CurrentNodeStyle-CssClass="breadcrumbCurrent" NodeStyle-CssClass="ms-sitemapdirectional"/>

</div>

See the below sample result page:

Good luck...

How To: Add Custom Menu Item in Context Menu (MOSS 2007).

2009-10-20T05:09:00.000-07:00

Sometimes, you may have to add new custom menu item in the SharePoint list context menu. See the below image for an example:

(click image to enlarge)

This can be achieved through the "Content Editor Webpart".

1. Open SharePoint Designer.

2. Open SharePoint site (ex: http://172.16.10.10:2002)

3. Go to that specific page and edit that page

4. Click on "Task Panes" in SharePoint Designer and open "ToolBox"

5. In the "ToolBox" pane, explore "Webparts" title.

6. There, you can see a hyperlink as "Open the webparts task pane". Click on it.

7. Insert the "Content Editor Web Part" from the newly opened task pane.
8. Write the below code inside the "Content" tag of the "Content Editor Web Part".

Code:

<![CDATA[<script language="javascript">

* @ Desc: Adds a custom menu items into the menu

function Custom_AddListMenuItems(m, ctx)

{

var str = currentItemID;

var strDisplayText = "Navigate Project workspace";

strUrl = "Default.aspx";

var strImagePath = "";

strAction = "STSNavigate('http://" + location.host + "/ItemWorkspaces/Project/"+ strUrl+"')";

// Add our new menu item

CAMOpt(m, strDisplayText, strAction, strImagePath);

// add a separator to the menu

CAMSep(m);

// false means that the standard menu items should also rendered

return false;
}</script>]]>

See the below image, that will explain how i have added the code into the Content Editor Web Part.

Thats it....

How To: How to redirect to custom Edit Page in MOSS 2007 ?

2009-10-19T06:55:00.000-07:00

Usually, the Edit page of the "Sharepoint List" will be like three columns. First column will be a lable of the field, second column will be the seperator, third column will be the field control like Text box, calender control or people picker, etc...

Sample Edit Form

Sometimes, you are in a situation to modify the look and feel of "Edit" page of list/document library like the below image.

This can not be done in MOSS by editing the EditForm.aspx page. Instead, we can create a Blank Webpart page (ex: EditAsset.aspx) and we have to insert our customized Web Part. OK. We have created a page to modify the Content of the List/Document Library. But, How to redirect the users to this page, whenever they are trying to edit the list?

Well. This can be done in 2 ways.

1. We have to add custom menu item in context menu of the list/document library, wherever we are displaying the content. (This is very difficult. because we have to add javascript in each and every page, if we are going to display the list)

2. Redirecting to our Custom Edit Page from EditForm.aspx page

Second approach is easy one to follow. So, I will tell you how to redirect from EditForm.aspx page.

1. Open SharePoint Designer 2007

2. Open the Website

3. Go to the Document Library/List.

4. Go to "Forms" folder inside the document library.

5. Open "EditForm.aspx"

6. Insert one "Content Editor Web Part"

7. Write the below code inside the Content Editor Web part.

Code:

<![CDATA[<script language="javascript">

var query = window.location.search.substring(1);
var vars = query.split("&");

var2 =vars[0].split("=");

location.href = '/Pages/EditAsset.aspx?EditID=' + var2[1];
</script>]]>

So, The page will be redirected to our custom edit page.

In the above code, i have splitted the querystring from EditForm.aspx and sending the value to My "EditAsset.aspx" as a querystring parameter.

See my below image, that will explain how to add the code in the sharepoint designer.

(Click on the image to enlarge)

Thats it...

Error: A Single Sign-on error has occurred. Please contact an administrator. Details: Could not find domain controller for this domain

2009-10-15T00:07:00.000-07:00

Error:

A Single Sign-on error has occurred. Please contact an administrator. Details: Could not find domain controller for this domain.

Reason:

You will get this error, when you are trying to configure the SSO (Single Sign-On) in MOSS 2007. The reason is the specified account may not be a member of "Domain Controller" group.

Solution:

Ask your network administrator to add the specified user account into the "Domain Controller" group in the Active Directory.

Error: System.Data.SqlClient.SqlError: The media family on device 'C\WSS_Content' is incorrectly formed. SQL Server cannot process this media family.

2009-10-05T06:20:00.000-07:00

Error:

System.Data.SqlClient.SqlError: The media family on device 'C\WSS_Content' is incorrectly formed. SQL Server cannot process this media family.

Reason:

Sometimes you will get this kind of error, while you are trying to restore the backup of Sharepoint Content Database in SQL Server 2005. But the back up content may be taken from SQL Server 2008. This is the cause of the issue.

Solution:

Open SQL Server 2008 Management studio and Restore the database.

Error: No Excel Calculation Services is available in the farm.

2009-10-01T03:58:00.000-07:00

Error:

Sometime you will get error like below, while you are loading excel sheet in your SharePoint Excel Web Access web part.

1. No Excel Calculation Services is available in the farm.

(or)

2. There was an error in communicating with Excel Calculation Services http://SenMoss:56737/SharedServices2/ExcelCalculationServer/ExcelService.asmx exception: The request failed with HTTP status 503: Service Unavailable.

(or)

3. Unable to reach Excel Calculation Services http://SenMoss:56737/SharedServices2/ExcelCalculationServer/ExcelService.asmx.

Reason:

Your IIS application pool for Excel Calculation services may not be enabled.

Solution:

1. Go to IIS (Type "InetMgr" in Command Prompt")

2. Open "ApplicationPools" node

3. Select "OfficeServerApplicationPool".

4. Right Click on ir and select "Start"

Error: Cannot make a cache safe URL for "createsilverlghtobjects.js", file not found

2009-09-29T02:48:00.000-07:00

Error:
Cannot make a cache safe URL for "createsilverlghtobjects.js", file not found.

Reason:

You may not copied the "createsilverlghtobjects.js" into "_layouts" folder. You may be modified the "_Layouts" site path to some other location, instead of default location like

"C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS_10002\".

But silverlight application will look into the physical path of "C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS\1033" folder.

Answer:

So, put that "createsilverlghtobjects.js" file or someother required files into "C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS\1033" folder.

How To: Integrating Silverlight User Control with SharePoint WebPart (MOSS 2007)

2009-09-25T06:26:00.000-07:00

Silverlight with MOSS 2007

Developing a webpart may be very simple. Likewise, Developing a Silverlight application also will be very simple. But, If you are going to integrate both areas, that will be difficult little. Here, I am going to tell you that what are necessary steps that needs to be followed, while integrating the MOSS & SILVERLIGHT.

OK. See the steps below. (I assumes that you are familier with creating SharePoint webpart & creating sivlerlight Web applications.)

1. Whenever you are creating Silverlight applications, you can see a "Silverlight.js" file in your "Web" folder. For example, if your application name is "HelloWorld", your visual studio will create another folder with the name of "HelloWorld_web" or "HelloWorldWeb". Within this folder, you can see a file "SilverLight.js". Copy this file and paste it into "C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS\1033". (Note: you should paste that file, only into this folder. Else, you will get an error".

2. Create an Silverlight application and generate a XAP file.

3. Go to "c:\Inetpub\wwwroot\wss\VirtualDirectories\7070" and create a folder named "ClientBin" and give permission to Read & Write (for everyone).

4. Go to IIS

5. Go to Your SharePoint portal and make the "ClientBin" folder as a Virtual Directory.

6. Copy the Silverlight Application DLL & XAP file into this ClientBin folder.

7. Modify the Web.Config file to integrate the Silverlight. You can download a sample web.config file in the "download" section of http://www.codeplex.com/SL4SP

8. Create a Webpart. You can use WSPBuilder to create a Webpart. You can download a WSPBuilder from http://www.codeplex.com/wspbuilder

9. Add 2 references in WSP Project (System.Web.Extensions & System.Web.Silverlight)

10. In the WebpartCode, you must inherit the below 2 namespaces.

a. using System.Web.UI.SilverlightControls;

b. using System.Web.UI.WebControls;

11. Write a code to call the XAP file within the "CreateChildControls" method like.

Silverlight sl = new Silverlight();

sl.ID = "MYSL";

sl.Source = "/ClientBin/SenSLMOSS.xap";

sl.Height = Unit.Pixel(420);

sl.Width = Unit.Pixel(420);

this.Controls.Add(sl);

12. "ScriptManager" code also should be placed inside the WebPart code. See the sample code below and this code should be inside the "OnLoad" method, like,

protected override void OnLoad(EventArgs e)

{

if (!_error)

{

try

{

base.OnLoad(e);

ScriptManager sm = ScriptManager.GetCurrent(this.Page);

if (sm == null)

{

sm = new ScriptManager();

Controls.AddAt(0, sm);

}

this.EnsureChildControls();

}

catch (Exception ex)

{

HandleException(ex);

}

13. Add & Deploy the WSP Webpart using stsadm command.

(stsam -o addsolution -filename "C:\SLMOSSWebPart.wsp")

14. Create a "WebPart page and insert this webpart into that newly created page.

15. You will see an amazing SilverLight Page.

Thats it...

Error: Could not complete the operation due to error 80000012

2009-09-25T06:21:00.000-07:00

Reason:

While integrating the Silverlight XAP files into MOSS 2007 webpart, you will get this error. Because, your given path may not be in correct format.

Answer:

You may have mentioned the XAP file path like "\ClientBin\HelloWorld.xap".

Instead, use like "/ClientBin/HelloWorld.xap"

Microsoft SharePoint Workspace 2010 download

2009-08-25T02:12:00.000-07:00

Microsoft SharePoint Workspace 2010 download is locked due to over response. So, we are expecting the beta release at any time.

However, As per their blogs, I am listing some of the key points of SharePoint Workspace 2010:

1. Groove will be known as SharePoint Workspace Manager.

2. SharePoint Server 2010 will be 64 bit only.

3. IE 6.0 will not be supported.

4. SharePoint Workspace Manager and OneNote will be a part of the Office 2010 ProPlus SKU.

5. Migration should be smoother from 2007 to 2010 than 2003 to 2007.

6. 2010 will support silverlight controls effectively.

7. Now, you can Insert/Delete data through BDC.

8. Faceted search has been introduced.

I will update this post, If there is any latest news about Microsoft SharePoint Workspace 2010.

Error: HTTP 404: File Not Found in MOSS 2007 (SharePoint)

2009-08-24T00:51:00.001-07:00

Error:

HTTP 404: File Not Found.

(Or)

SharePoint site can not be opened in SharePoint Designer.

Reason:

Usually this error will occur due to the below reasons:

1. If the portal is not attached with "Central Administration" portal. i.e. The portal will be running in IIS. But the Portal site may not be created in "Central Admin".

2. The Port may not be associated with SSP.

3. Identity of the IIS application pool may be different. or the Application Pool Identity password may be changed.

Solution:

1. Create a new "Web application" in the same port with the previous credentials & with the same database name through the "Application Management". And don't create "Site Collection". (This is applicable, if the problem is due to Reason 1")

2. Associate the Port (Web application) with SSP, if the reason is 2.

3. Go to IIS and open the properties of the Application pool for this specific port and update the username,password in the "Identity" tab.

Important:

Don't forget to restart the IIS. Else, your master pages will not take effect in the "Application pages".

Hiding Menu in DispForm.aspx (MOSS 2007)

2009-08-20T01:17:00.000-07:00

Sometimes, you may struggle to hide the "Menu Toolbar" which is displaying in the top of the Display Form page.

You may tried to hide by editing the page in SP Designer & writing Java Scripts. But they will not reflect in page. Because, you may forgot to add the "Push" method.

OK. So, here is an sample script, that will hide the "Menu Toolbar" from the DispForm.aspx.

function check()

{

var elements=document.body.getElementsByTagName("a");

for (var index=0; index <>

{

if(elements[index].title.toLowerCase()=="edit item")

{

elements[index].parentNode.parentNode.parentNode.parentNode.parentNode.parentNode.style.display="none";

}

var elements=document.body.getElementsByTagName("td");

for (var index=0; index <>

{

if(elements[index].innerText.toLowerCase()=="itemworkspaceurl")

{

elements[index].parentNode.style.display="none";

}

_spBodyOnLoadFunctionNames.push("check()");

</script>

Once you have applied this script, final screen will be like,

That's It...