Integrate Project Server 2010 with Sharepoint 2010

Integration of Project Server 2010 with SharePoint 2010

Step1: Install SharePoint 2010 and run the configuration wizards with this SharePoint 2010 installed.

Step2: Install the Project server 2010 and run the wizard

Steps 3: Goto Central Admin-->Application Management-->Project Server Service Application

Select project server serviceàClick New->Create Application…..

It prompt for project path in next window give the path else leave the as it is click next

Finally it creates Timer Job

Note: Don’t be excited to View the site which is created because timer job will not finish creating wabapplication and Database on spot (i.e it creates job schedule so to completing it takes few minutes)

To observer the timer job Completion go toàCentral Admin ->Monitoring àTimer Job Sta

tus.

Relax for few Minutes it creates Site for in within 5 minutes.

Upgrade Sharepoint Site from 2007 to 2010

Attach SHAREPOINT 2007 SQL DATABASE TO SHAREPOINT 2010 SQL DATABSE:UPGRADE
=======================================================================
Step1: Take the sharepoint 2007 SQL server database backup of the site and restore into newly created database (i.e New share point 2010 Environment)

Step2:
Type the following command in Sahre point Managment Shell

Mount-SPContentDatabase -Name -DatabaseServer -WebApplication [-Updateuserexperience]

There has been an error creating the personal site. Contact your site administrator for more information

In sharepoint site when you click on mysite some times gives the "There has been an error creating the personal site. Contact your site administrator for more information"

Solution:

Following steps outline how to configure your existing web app 'http://mywebapp' to host ‘My Sites’ to be stored in a separate database

1. Go to “Application Management” and select “Content Databases” under “SharePoint Web Application Management”
2. Select the ‘http://mywebapp’ web application. And select “Add Content Database”
3. Create a new DB and name it: "MySites_Content"
4. Once this DB is created select the existing database named: MyWebApp_Content.
5. In the “Manage Content Database Settings” for 'MyWebApp_Content’ select Database status to “Offline”

This will ensure that no new site collections are created in the default content database 'MyWebApp_Content'. Taking this content database offline only prevents new site collections from being created. Users are still able to create sub sites and items and use the existing sites

4. Go to Application Management and select “Define Managed Paths” under “SharePoint Web Application Management”
   
   
5. Select the 'http://mywebapp' web application and create a new path named ‘mysite’ and select “Explicit inclusion”
6. Create a another managed path named ‘personal’ and make it a “Wildcard inclusion”
7. Go to “Application Management” and select “Create Site Collection”
8. Ensure that the path selected is 'http://mywebapp/mysite' **(Important)**
9. Name it ‘My site host’ and select the “My Site” template from the templates list from the “Enterprise” tab
   
   
10. Go back to Central Administration and select the Shared Services Provider configuration
11. Select “My Site Settings” and Set "Personal site provider" to "http://mywebapp/mysite/" and "Location" to "personal"
    
    
12. Go back to Central Administration and enable “Self Service Site Creation” for the web application ‘http://mywebapp’

Service Unavailable for Sharepoint webapplications

Solution:

Verify that the application pool is configured for the virtual server. The default application pool is MSSharePointPortalAppPool.

Follow these steps to determine the application pool that the virtual server is using:

Click Start, point to Administrative Tools, and then click Internet Information Services (IIS) Manager.

Expand ServerName, expand Web Sites, right-click the virtual server, and then click Properties.

Click the Home Directory tab.

The application pool that is configured for the virtual server is listed in the Application pool box.

Click OK.

Verify that the password for the application pool account is correct. IIS does not automatically poll password changes in Active Directory directory service. If the application pool account is a domain account, and the password expires, you may receive the error message that is described in the "Symptoms" section of this article after a new password is specified for the account.

Follow these steps to verify that the password for the application pool account is correct:

In Internet Information Services (IIS) Manager, expand Application Pools.

Right-click the application pool that is configured for the virtual server (for example, right-click MSSharePointPortalAppPool), and then click Properties.

Click the Identity tab.

In the Password box, type the password of the application pool account that is listed in the User name box, and then click OK.

In the Confirm Password dialog box, type the password again, and then click OK.

Service Unavailable(FOR Central Admin site):

Service Unavailable when accessing SharePoint Central Administration

There can be many, many issues to troubleshoot in a SharePoint server environment. Recently one of my clients was receiving a Service Unavailable error while trying to access the Web pages or any service provided by a Web application. If the Web application pool is unable to start you will receive this error. One of the ways we can fix it is to reset the password for the Central Administration Web application pool identity and the Windows SharePoint Services Timer service. You can use the stsadm.ext utility to reset the password by following these steps. You should ensure the password has been changed on the domain controller because the credentials are matched with the domain controller. If the password has not been changed on the domain controller before you perform these steps, an error will occur and the changes will not take place.

Open the command line and navigate to the Progarm Files\Common Files\Microsoft Shared\web server extensions\12\BIN folder.

Type the stsadm -o updatefarmcredentials -userlogin -password

Reset IIS by typing iisreset /noforce to restart the Web application pool.

After you complete these steps on the computer running Central Administration, you should perform the following steps on every server in the farm:

Open the command line and navigate to the Progarm Files\Common Files\Microsoft Shared\web server extensions\12\BIN folder.

Type stsadm -o updatefarmcredentials -userlogin -password -local

cannot connect to the configuration database

In sharepoint

Solution:

1. If the WSS is in a server farm, use the “SharePoint Products and Technologies Configuration Wizard” to disconnect the server from the farm.
2. go to Start >Program > Microsoft SQL Server 2005 > Configuration Tools >SQL Server Configuration Manager
3. Navigate to SQL Server 2005 Network Configuration > Protocol for MSSQLSERVER
4. Right click Named Pipes and select Enable (if not enabled)
5. Restart SQL Server
6. Join back the server to server farm using “SharePoint Products and Technologies Configuration Wizard” and follow the wizards.

Sitecollection could not be restored .if this problem persists,make sure the content databases are available and have suffient free space?

Even if u have lot of space in database some times gives the error

Just try following command

Solution :Restart the timer service and resetiis

Failed to resolve the site ID for 'Office Server Web Services'.

Solution:

MOSS on Windows Server 2008
I have to admit the install of MOSS on Longhorn RC0 went much smoother than expected; I eventually had one little error trying to start Excel Services (not that I really needed ECS at that point; but it was the last step and thankfully makes the Farm Incomplete message go away). The error message is:

"Failed to resolve the site ID for 'Office Server Web Services'"

But it seems it will start just fine if you use the command line; go to love STSADM.

STSADM.EXE -o provisionservice -action start -servicetype "Microsoft.Office.Excel.Server.ExcelServerSharedWebService, Microsoft.Office.Excel.Server, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c"

Automatic Share point 2007 Site Backups

Step1: open Notepad and paste the following code

@echo off

echo getting todays date
for /F "tokens=1-4 delims=/- " %%A in ('date/T') do set DATE=%%A%%B%%C%%D

echo getting todays time
for /F "tokens=1-4 delims=:., " %%a in ('time/T') do set TIME=%DATE%%%a%%b%%c


cd \Program Files\Common Files\Microsoft Shared\web server extensions\12\BIN
@echo off

echo perform backup
stsadm.exe -o backup -url http://mis-app-test:21208 -filename "D:\share point backup\backup%TIME%.dat" -overwrite

echo zip file
pkzipc.exe -max -add=update -dir=full "backup%TIME%.zip" "backup%TIME%.dat"

echo remove original file
del /q /f "backup%TIME%.dat"

Step2:Save as .bat file

Step 3:Create the Task schedule(goto Control panel-->Scheduler task)

Step 4:Point out the .bat file which you created for  sc
hedule.