Nav2013 setting

We can install the Navision 2013 to 3-tires structure,
1. SQL Server, Save SQL DB only.
2. Nav Server, Install Nav 2013 Server. ( Server2, maybe a Hyper-V server, but on another physical Server)
3. RTC, Nav 2013 Client for end user.(On local user PC).
but on SQL server, must delegate to Nav Server.
http://msdn.microsoft.com/en-us/library/aa905162(v=sql.80).aspx

Open PDF file on SharePoint 2010

After install SP2010 and migrated SP2007 into 2010, open pdf file has problem.
So we need follow up some structure to modify CM & DOCICON.xml file.
follow up this:
http://www.youtube.com/watch?v=ay6Xvb2oIUU

PowerPivot installation

PowerPivot must be install with SharePoint Server, for Example; SQL Server installed in physical Server and SharePoint Server installed in a VM server,. When we need install PowerPivot from SQL install CD, we need install this with SharePoint Server in VM server.
ps. install PowerPivot only.


http://msdn.microsoft.com/en-us/library/ee210616(v=sql.105).aspx

Enable Office Web Application in SharePoint 2010

SharePoint 2010 support Office Web application, so we can use browser to browse office file in SharePoint. Before enable office web app, we need download and install.
1. Install Office Web Application
2. Run Configuration Wizard. after finish, system will open Central Administration. don't run Farm configure Wizard and closed wizard.
3. in Central Administration, Application Management -> Manage Service Application -> Secure Store Service, click "New" to add Excel Service ID in "Target Application ID" like 39235 (Excel)
4. Click Application Management -> Manage Service Application -> Excel Service Application ->Global Setting, set 39235 in "Application ID"
5. Now, when you right click excel file in library, you can see open by browser or client. if you want set browser is default, go to library setting -> advance setting, set browser is default.
6. on this time, you open Word or PowerPoint file, you will be get error message like "Word Web App cannot open this document for viewing because of an unexpected error". we need
7. Application Management -> Manage service on server to verify PowerPoint service and word viewing service is started.
8. If both application service are not in list, click "New" and then click "Word Viewing Service" and "Power Point Service Application".
9. in those application dialog box, in name, type those service name, in application pool, select "Use existing application pool" and then in the listbox, select "sharepoint web services default". then click "OK"
A. Now we can browse office file in browser.
B. came from : http://support.microsoft.com/kb/2028346

SharePoint 2010 Site Collection setting

After Farm created and configuration finished, we can login Central Administration Web Application page.
1. Create a user name at AD server, SP_PortalApp
2. Create a Web Application, default port is 80.
3. Host Header, we can set to "TestPortal.vff.com", don't select SSL.
4. Database name change to "WSS_Content_TestPortal"
5. Manage Account is vff\SP_PortalApp
6. System will auto created this Web Application
7. Go back AD server, in DNS, set Host(A) to resolve "Testportal.vff.com" to the IP address of SharePoint Server.
8. Create a Site Collection under "http://testportal.vff.com/". Title can set like "SharePoint 2010 Test Environrment " and enter Primary and Secondary Site Collection Administrator.
9. Now we can login "http://testportal.vff.com"

SharePoint 2010 installation Guide

1. Hardware.
    a. SQL Server; Win SVR 2008R2 *64 + MS SQL 2008 SP2. SQL Memory at least 4096MB
    b. SP2010 Server; Win SVR 2008R2 *64 + SharePoint 2010 Enterprise
2. Accounts ( as domain user)
    a. SP_Admin; added as a loca administrator on SP2010 Server only + dbcreator, public, securityadmin role in SQLserver
    b. SP_Farm
    c. SP_ServiceApp
3. Run "Prerequesteinstall.exe until get "success".
4. Run setup, input license key
5. Select "Server Farm" options, Don't select "standalone"
6. Select "Complete", Don't select "standalone"
7. Run Configuration Wizard after strp 6 finished.
8. Select "Create a new server farm" and next
9. in "Specify Configuration Database Setting"
    a. DB server is SQL Server
    b. DB Name, default is "SharePoint_Config", Don't change.
    c. User Name : SP_Farm & password
A. Enter and confirm your passphrase.
B. Specify a port number for Central Administration Web Application
C. After Wizard, CA will auto open, Select "Yes, I'm willing to participate"
D. Start the "Farm Wizard".
E. Use "vff\SP_ServiceApp" & password in "Service Account"
F. Select all service application except "Lotus Notes"
G. Now, in this wizard. we can create a home site by template.
H. Configure the outgoing e-mail.
I. Configure the secure state service.
    Appliaction Management -> Service Applicatioins -> Manage Service Application ->
    double click "secure store service" -> click "generate new key" then input "passphrase" and click "OK"
J. Set a simple search crawl schedule.
K. Done
 

PowerPivot on SharePoint 2010

PowerPivot on SharePoint 2010 are useful, but SharePoint must be "Server Farm" version. because standalone version couldn't add PowerPivot farm into SP2010.
view document :  PowerPivot for SharePoint – Existing Farm Installation
and this : http://msdn.microsoft.com/en-us/library/ee210616.aspx
and this: http://msdn.microsoft.com/en-us/library/ee210708.aspx

7/20 update. I created a document to know how to use Powerpivot and how to post pivot chart on SharePoint, document on Google Drive. Name is "Power Pivot for Excel and SharePoint"