SharePoint integrates SAP

Why SharePoint Integrates SAP(ERP) ?

Employees in their mySites a view of pending SAP expenses reports.

You can use WSRP if you want to create a custom look and feel to your view. It's preferable to URL wrapping since it's a true web service and not simply another system's HTML.
You can display entire BSPs in web parts. HTTP or HTTPS is used to access the application across the network so firewalls and proxy servers can be used. SAP portal is not required to execute BSPs.
Accessing SAP data using services and bringing it into WSS or the client (e.g. through Enterprise Search, lists, in the client in a custom task pane or custom apps)
Surfacing SAP data for analysis – this involves exporting SAP data into a warehouse and then consuming the warehouse using Excel pivotCharts, Excel Services and dashboards

In touch with it ,i will post the  how to integare SharePoint to ERP soon.....

Restart Service Application in sharepoint2010

To restart service applications, type the following command, and then press ENTER:

Open-->SharePoint Managment Shell

Start-SPServiceInstance –Identity

Where is the GUID of the service application.

To restart all service applications, use Start-SPServiceInstance without any parameters

Differencs between Sharepoint Foundation 2010 vs Sharepoint 2010

Features                                    SharePoint Foundation 2010                                                    SharePoint Server 2010          

Access Services                                                                                                                                                                        √

Use Access Services in Microsoft SharePoint Server 2010 to edit, update, and create linked Microsoft Access 2010 databases that can be viewed and manipulated by using an Internet browser, the Access client, or a linked HTML page.

Business Connectivity Services                                         √                                                                                                √

SharePoint 2010 includes Microsoft Business Connectivity Services, which is a set of services and features that provide a way to connect SharePoint-based solutions to sources of external data and to define external content types based on that external data.

Central Administration (Redesigned)                             √                                                                                                √

Central Administration has been redesigned in SharePoint 2010 to provide a more familiar experience and make it easier for users to find what they are looking for.

Digital Asset Management                                                                                                                                                   √

SharePoint Server 2010 includes a new asset library specially designed for managing and sharing digital assets such as audio, video, and other rich media files.

Enterprise Search                                                                                                                                                                   √

With the new capabilities in SharePoint Server 2010, search administrators can configure an optimal search infrastructure that helps end users find information in the enterprise quickly and efficiently.

Excel Services                                                                                                                                                                          √

Excel Services in Microsoft SharePoint Server 2010 can be used to publish Excel client workbooks on SharePoint Server 2010.

Managed Metadata                                                                                                                                                              √

Managed metadata is a hierarchical collection of centrally managed terms that you can define, and then use as attributes for items in SharePoint Server 2010. The Managed Metadata Service supports the use of managed metadata, as well as the sharing of content types across the enterprise.

PerformancePoint Services                                                                                                                                                 √

PerformancePoint Services in Microsoft SharePoint Server 2010 provides flexible, easy-to-use tools for building dashboards, scorecards, and key performance indicators (KPIs).

Records Management                                                                                                                                                          √

In SharePoint Server 2010, you can manage records in an archive, or you can manage records in the same document repository as active documents.

Social Computing                                                                                                                                                                                                   √

SharePoint Server 2010 includes social networking tools such as My Site Web sites and social content technologies such as blogs, wikis, and really simple syndication (RSS). These features are built upon a database of properties that integrates information about people from many kinds of business applications and directory services. You can adapt content to each user while enabling administrators to set policies to protect privacy.

Visio Services                                                                                                                                                                          √

The Visio Graphics Service is a service on the SharePoint Server 2010 platform that enables users to share and view Visio diagrams and enables data-connected Microsoft Visio 2010 diagrams to be refreshed and updated from a variety of data sources.

Upgrade                                                                                 √                                                                                                √

Review upgrade requirements and find out about new upgrade tools and options, including information about the pre-upgrade checker, Visual Upgrade, and the test-spcontentdatabase Windows PowerShell cmdlet.

Claims-Based Authentication                                            √                                                                                                √

SharePoint 2010 incorporates a new authentication model that works with any corporate identity system, including Active Directory Domain Services, LDAP-based directories, application-specific databases, and user-centric identity models.

Health Monitoring                                                               √                                                                                                √

SharePoint 2010 includes an integrated health analysis tool called SharePoint Maintenance Manager that enables SharePoint Server to automatically check for potential configuration, performance, and usage problems.

Sandboxed Solutions                                                          √                                                                                                √

You can deploy sandboxed solutions to quickly and more securely solve business problems. Sandboxed solutions are like farm solutions except in the following ways: they are rights-restricted and have a more permissive deployment policy than farm solutions; they are limited to the site collection to which they are deployed; and their server resource usage is monitored against an administrator-controlled quota for the site collection.

Windows PowerShell                                                          √                                                                                                √

Windows PowerShell is the new command-line interface and scripting language specifically designed for system administrators.

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.