Fix the SharePoint DCOM 10016 error on Windows Server 2008 R2

http://www.wictorwilen.se/Post/Fix-the-SharePoint-DCOM-10016-error-on-Windows-Server-2008-R2.aspx

Thank you Wictor for this great post......Works perfectly.

Schannel error showing up on your front-ends event log

I am posting this as I have search the web for quite awhile and found a lot of issues surrounding this. However for SharePoint related issues I found very little. It seems this error could be realted to you using https in your sharepoint farm and a process or user initiates a http request instead. This error is just reporting it. As far as I know, these errors are common and not serious, it is simply a Security feature of Windows Server 2008 R2 that any negotiation or problem of unexpected messages for secure channel can be recorded. The Schannel level of logging can be configured as described in:

NPS: SCHANNEL
http://technet.microsoft.com/en-us/library/dd197492%28WS.10%29.aspx




The General error is
The following fatal alert was generated: 10. The internal error state is 1203 "or it could be 10".
The Details are
- System
- Provider
[ Name] Schannel
[ Guid] {1F678132-5938-4686-9FDC-C8FF68F15C85}
EventID 36888
Version 0
Level 2
Task 0
Opcode 0
Keywords 0x8000000000000000
- TimeCreated
[ SystemTime] 2010-06-18T04:51:41.830028400Z
EventRecordID 10087
Correlation
- Execution
[ ProcessID] 604
[ ThreadID] 3828
Channel System
Computer
- Security
[ UserID] S-1-5-18
- EventData
AlertDesc 10
ErrorState 1203 or it could be 10

SharePoint 2010 Training for end users FREE from Microsoft!

http://www.microsoft.com/downloads/en/details.aspx?familyid=4AAA9862-E420-4331-8BC3-469D7BAE0FF1&displaylang=en&hash=hu2XviPPtxw6tFJenXjgvWNraiuxnCoBXGJu9%2bRI3wD%2bUX7Mk9G25uOXKhaDm9wv8C%2bN7q%2brxXG6HKiG2pFaMQ%3d%3d

SharePoint 2010 search does not display numbers like IP addresses

Just click the top checkbox and run a full crawl. Your numbers will now appear!

Kudos http://blogs.msdn.com/b/enterprisesearch/archive/2010/01/21/regular-expressions-support-in-crawl-rules.aspx

Added SSL now crawls stopped

First, open IIS manager, go to the sharepoint site, then double click SSL settings, check if you set “client certificates:” to Accept, if you did, change it to Ignore.

Second, use the default content access account when you specify authentication in crawl rules.

:)

The credentials you provided for the sql server service are invalid & The current SKU is invalid

Summary: The credentials you provided for the sql server service are invalid & The current SKU is invalid
Details:

Ok, disk problems resolved, resuming the install (not doing advanced prepare this time!)
Successfully installed first single node cluster, hoooooray!!!!
When attempting to add node to the cluster, it failed stating “the credentials you provided for the sql server service are invalid”. It Failed on SQL Server / SQL Server Agent. I attempted to change the password to no avail, failed every time.
Found this article: http://support.microsoft.com/default.aspx/kb/955948/ which states “To work around this issue, type the domain account manually in the Account Name text box.” This is not true, as the boxes are grayed out and do not allow you to change the account.
Unsure to as where I got the information from, but I had read somewhere that CU1 would resolve this specific issue (trying to find link).
Ok, installed SP1 on the node which has the single node cluster setup.
Attempted to add node, “Failed: SQL 2008 Cluster – The current SKU is invalid.”
Found these articles: http://support.microsoft.com/kb/957459/ & https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=363036&wa=wsignin1.0M
Install SP1 on a node that doesn’t have SQL installed huh? Interesting. The 2008 cluster install doesn’t use the task scheduler any more, and the nodes have to be manually installed, so why do I need to patch a server that doesn’t have any trace of SQL on it yet?
Low and behold, when I went to install SP1 on each of the other nodes, it patched the “shared features” successfully.
Tried to add node to cluster, successful on each node!
Had to install SP1 again on each node after I completed the install.
What did I learn?
You need to install SP1 (or at least CU1) after installing your first single cluster node. After that, you have to install SP1 (or CU1) prior and post to adding any other nodes on the cluster. Crazy, but at least I know now.


--------------------------------------------------------------------------------

GREAT POST FROM SQLSLAYER

Migrate 07 Content DB to 2010--last two steps!

Reset Site Definition under site actions, then go in and do visual upgrade.

:)

SharePoint-Visio-Stencils

Download them here, I forgot where I got them from...

http://www.gigabytz.net/sharepoint-visio-stencils.zip

John

SharePoint Server 2010 performance and capacity test results and recommendations

I took the liberty of zipping up all the word docs from MS and giving you guys a link :)

http://www.gigabytz.net/sps2010.zip

Cheers

SharePoint 2010 SharePoint Sizer Tool

HP has a pretty cool tool for SharePoint Architects, download it here.

http://h20338.www2.hp.com/activeanswers/Secure/548230-0-0-0-121.html

HP Sizer for Microsoft SharePoint is a complimentary planning resource that encapsulates knowledge gained from extensive performance characterization of Office SharePoint Server 2007 and SharePoint 2010 in the HP Alliances Performance and Solutions labs, widespread collaboration between HP and Microsoft, and numerous SharePoint performance whitepapers produced by HP engineering. The Sizer offers a quick and consistent methodology for determining and comparing configurations, as well as detailed, customizable server and storage solutions complete with bill of materials and pricing.

HP Sizer for Microsoft SharePoint solicits data or uses built-in defaults to determine optimal configurations based on SharePoint deployment best practices. Selectable configurations include entry level, highly available, and application optimized solutions. A "what if" feature allows rapid comparison of the effects of workload changes, platform and storage technology selection, and provides role-based server configurations, capacity utilization, and estimated network traffic. Users can select a configuration and then customize their environment by adding or substituting components within best-practice guidelines.

The tool also addresses one of the most critical areas of SharePoint server design: performance and capacity planning for the storage subsystem. Its storage sizing and configuration capabilities offer detailed best-practice storage volume and RAID recommendations to support database and content storage needs using HP direct-attach storage, HP StorageWorks MSA or EVA Storage SAN solutions.

Configure NLB as normal on a windows 2003/2008 box.

Configure NLB as normal on a windows 2003/2008 box.

Add new server to the farm and select host site on this server

Go into the registry of the server HKLM\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14\WSS

For each server make sure the link is going to the server itself. This fixes your actual server link in the programs shortcuts on each server.

Then, go into Central Admin on either server and configure access mappings.
Drop down the application and click central admin. Make one of them the default and the other the Intranet.

So, you should have for instance: DEFAULT http://gigaportal:9111 and INTRANET http://gigaportal2:9111

SPS 2010 Developer Dashboard...helps in troubleshooting

Stsadm –o setproperty –pn developer-dashboard –pv ondemand (or “on” or “off”)

This will put a small icon in the top right of your sharepoint page. Click it and it will display debugging info on your page all the way at the bottom. The cool thing is its activated by each person, by that if you click it, only you see the information.

Very useful!

Language Translator for SharePoint

http://www.microsofttranslator.com/widget/

This thing is cool. Just add a content editor webpart. Paste the code in a .txt file and link the content editor to the .txt file in the sharepoint library.

really cool and a load of time savings!

Moving site collections to new databases SharePoint 2010

On the SharePoint Server, open command prompt to hive.
Type Stsadm -o enumsites -url > .xml

I used this for example:
Stsadm -o enumsites -url http://sp-giga > c:\sites.xml

Edit the sites.xml file to remove all sites that you do NOT want to move to another content db.

Then once you have done that, save the file back to c:\sites.xml.
Type Stsadm -o mergecontentdbs -url -sourcedatabasename -destinationdatabasename -operation 3 -filename

For example:
Stsadm -o mergecontentdbs -url http://sp-giga -sourcedatabasename wss_content -destinationdatabasename wss_content_sc_IT -operation 3 -filename c:\sites.xml

Check to make sure the sites moved over in central admin, manage content databases

SharePoint 2010 fly-out menu NOPE not there!

Flyout levels are still a problem for SharePoint, you will need to modify the v4.master page and change the string value DynamicDisplayLevels from “1” to “3”, and this will allow sub menus to fly out three levels. In order to do this, make sure you have the publishing feature on and the navigation is set to show sub-sites. In order to change this value, use SharePoint designer, open up the master page and click code view. Do a find for the string. Save it, publish it, approve it.

SharePoint 2010 .pdf's here we go again

http://bloggingabout.net/blogs/harold/archive/2008/10/02/index-pdf-documents-on-sharepoint-using-adobe-pdf-ifilter-9.aspx

This post covers everything to a tee, and works perfectly. The only thing I have to add is this:

In the web browser, open Central Admin, under Application Management, click manage service applications.

Left side, click file types. Click new file type, put .pdf in there. Scroll down the list you should see the pdf icon there now and associated to adobe.

This actually worked better in 2010 then 2007!

SharePoint 2010 pre-req's location for download

Here is the location of all those pesky pre-reqs you need prior to installing sharepoint. You ask why do this? Well, if you have a lab setup with NO internet connectivity it is a very useful thing to have them all on a usb stick!

http://download.microsoft.com/download/C/9/F/C9F6B386-824B-4F9E-BD5D-F95BB254EC61/Redist/amd64/Microsoft%20Sync%20Framework/Synchronization.msi
http://download.microsoft.com/download/c/c/4/cc4dcac6-ea60-4868-a8e0-62a8510aa747/MSChart.exe
http://download.microsoft.com/download/2/0/e/20e90413-712f-438c-988e-fdaa79a8ac3d/dotnetfx35.exe
http://download.microsoft.com/download/2/8/6/28686477-3242-4E96-9009-30B16BED89AF/Windows6.0-KB968930-x64.msu
http://download.microsoft.com/download/D/7/2/D72FD747-69B6-40B7-875B-C2B40A6B2BDD/Windows6.1-KB974405-x64.msu
http://download.microsoft.com/download/6/8/1/681F5144-4092-489B-87E4-63F05E95079C/Windows6.0-KB976394-x64.msu
http://download.microsoft.com/download/E/C/7/EC785FAB-DA49-4417-ACC3-A76D26440FC2/Windows6.1-KB976462-v2-x64.msu
http://download.microsoft.com/download/D/7/2/D72FD747-69B6-40B7-875B-C2B40A6B2BDD/Windows6.0-KB974405-x64.msu
http://download.microsoft.com/download/3/5/5/35522a0d-9743-4b8c-a5b3-f10529178b8a/sqlncli.msi
http://download.microsoft.com/download/b/9/a/b9a78047-d269-4a25-88a1-9c4321d90677/SQLSERVER2008_ASADOMD10.msi
http://download.microsoft.com/download/1/7/1/171CCDD6-420D-4635-867E-6799E99AB93F/ADONETDataServices_v15_CTP2_RuntimeOnly.exe
http://download.microsoft.com/download/B/8/6/B8617908-B777-4A86-A629-FFD1094990BD/iis7psprov_x64.msi
http://download.microsoft.com/download/1/0/F/10F1C44B-6607-41ED-9E82-DF7003BFBC40/1033/x64/rsSharePoint.msi
http://download.microsoft.com/download/8/D/F/8DFE3CE7-6424-4801-90C3-85879DE2B3DE/Platform/x64/SpeechPlatformRuntime.msi
http://download.microsoft.com/download/E/0/3/E033A120-73D0-4629-8AED-A1D728CB6E34/SR/MSSpeech_SR_en-US_TELE.msi

SQL server at (Blank) has an unsupported version 10.0.2531.0

You update SQL 2008 to SP1 thinking ok I am ready......NO U R NOT! You will get the folowing error:

SQL server at [Your-DATABASE-SERVER] has an unsupported version 10.0.2531.0. Please refer to “http://go.microsoft.com/fwlink/?LinkId=165761” for information on the minimum required SQL Server versions and how to download them.

You might see threads here an there say that the minimum build number for SQL server is 10.0.2531.0. This is not very accurate as the minimum build for SPS 2010 for the SQL 2008 Enterprise Edition is the version number 10.0.2714.0 which is the cumulative update package 2. They are up to five now which I will post the link here: http://support.microsoft.com/kb/975977/en-us

If I had read the Pre-req from Microsoft for SharePoint 2010 it does state this.......But who reads! :)

SharePoint 2010 n SQL 2008 can't connect to DB

1. Open the SQL Server Configuration Manager (Start > SQL Server 2008 > Configuration Tools > SQL Server Configuration Manager
2. Navigate to the SQL Server Network Configuration > Protocols for MSSQLSERVER node in the tree view
3. Enable TCP/IP and Named Pipes (you’ll be warned that these changes will not apply until you the service is shut down)

That will allow you when installing SPS 2010 to connect to a SQL 2008 Server. This took 4 hours to finally figure out.