Sharepoint 2013 – Unir servidor a la granja Connect-SPConfigurationDatabase

Al querer unir un servidor, supongamos que se llame ServidorApp04, nos lanza el siguiente error al ejecutar el comando:

Connect-SPConfigurationDatabase -DatabaseServer $sqlServerAlias -DatabaseName $configDatabaseName -Passphrase $sPassphrase –SkipRegisterAsDistributedCacheHost

Connect-SPConfigurationDatabase : The current server cannot be joined to this farm because the set of installed products does not match the
products installed in the farm.
The license state for the current server doesn't match the farm's license state.

Esto se debe a que el servidor nuevo que quiero unir NO tiene el mismo software que lá granja.

Para saber que software falta instalar se debe hacer lo siguiente:

1.   Ingreso a la base de datos de Configuración, y ejecuto la siguiente query

Select * from Objects with (nolock) where properties like '%icrosoft.SharePoint.Administration.SPInstallState%'

En el campo Properties nos indicará los GUID´s de los productos instalados en la granja.

Para saber que productos son mediante los GUID´s, podemos consultar el siguiente artículo:

http://msdn.microsoft.com/en-us/library/jj659075.aspx

9FF54EBC-8C12-47D7-854F-3865D4BE8118", "SharePoint Foundation 2013"

"B7D84C2B-0754-49E4-B7BE-7EE321DCE0A9", "SharePoint Server 2013 Enterprise"

"35466B1A-B17B-4DFB-A703-F74E2A1F5F5E", "Project Server 2013"

2.   Ingreso al nuevo server ServidorApp04, y verifico la siguiente clave de registro

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\15.0\WSS\InstalledProducts

En la clave verifico que estén las tres claves. En este caso falta la clave del Project Server, por lo tanto debo instalar Project Server 2013 para igualar los ambientes.

Otra posibilidad para ver los productos instalados en la granja, es mediante el siguiente comando de powershell

Get-SPFarm | select Products

En el caso que la lista que retorna el comando difiere de la segunda imagen, podemos ejecutar el siguiente comando para refrescar la base de configuración.

Set-SPFarmConfig -installedproductsrefresh

La lista de productos también puede consultarse mediante la siguiente query sobre la base de configuración de Sharepoint

SELECT [Product], [Version], [PatchableUnit], [PatchableUnitName] FROM [dbo].[ServerVersionInformation]

as

Links útiles #38 Sharepoint 2010

1-Crear una feature en Sharepoint 2010

http://salaudeen.blogspot.com.ar/2012/05/how-to-create-feature-in-sharepoint.html

2-SSL para Sharepoint 2010

http://www.sharepointboost.com/blog/how-to-configure-ssl-for-a-sharepoint-web-site/

3-Business Connectivity Services y User Profiles: creando una propiedad de usuario

https://www.nothingbutsharepoint.com/sites/devwiki/articles/Pages/SharePoint-Extend-Active-Directory-People-Search-Result-by-Using-Business-Connectivity-Service-Part-1.aspx

4-Instalar Sharepoint 2010 con SQL Server 2012 y Windows Server 2012

http://mohamedradwan.wordpress.com/2012/06/21/install-sharepoint-2010-with-ms-sql-server-2012-on-windows-server-2012/

5-Script de powershell para saber el tamaño de las bases de datos de contenido (Storage Report)

http://salaudeen.blogspot.com.ar/2012/05/sharepoint-content-databases-size.html

6-Health Analyzer y PowerPivot

http://whitepages.unlimitedviz.com/2012/06/the-health-analyzer-and-powerpivot-for-sharepoint/

7-Sharepoint y DNS (+ alternate access mapping, bindings, etc)

http://min2dmax.wordpress.com/2012/06/15/customize-sharepoint-url-using-aam-and-dns/

8-Limpiar los valores de una user profiles en Sharepoint 2010

http://blogs.technet.com/b/meamcs/archive/2012/06/22/cleaning-up-specific-user-profile-properties-in-sharepoint-and-avoid-indexing-them-in-search.aspx

9-Join de listas en Sharepoint

http://sprider.org/2012/06/22/how-to-join-two-sharepoint-lists-with-inner-join-functionality/

http://thechriskent.com/2012/06/19/merging-data-into-a-sharepoint-list-using-ssis/

10-KeywordQuery y FullTextSqlQuery en Sharepoint (búsqueda mediante programación)

http://sharepoint-snippets.com/sharepoint-2010-search-programmatically-example/

Links útiles #23 Sharepoint 2010

1-Restore contenido de una base de contenido sin atachar (unattached)

http://blog.sharepoint-recovery.com/2010/06/25/sharepoint-2010-unattached-content-database-recovery-not-recovery-just-export/

2-Estructura de Directorios de la carpeta 14

Program Files\Common files\Microsoft Shared\Web Server Extensions\14 -
Este directorio es el directorio de instalación de los archivos principales de SharePoint Server.

Program Files\Common files\Microsoft Shared\Web Server Extensions\14\ADMISAPI -
Este directorio contiene los servicios SOAP para la Central Administración. Si este directorio se altera, la creación de sitio remoto y otros métodos expuestos en el servicio no funcionarán correctamente.

Program Files\Common files\Microsoft Shared\Web Server Extensions\14\CONFIG -
Este directorio contiene archivos que se utilizan para extender los sitios Web de IIS con SharePoint Server. Si este directorio o su contenido se alteran, el aprovisionamiento de aplicaciones web no funcionarán correctamente.

Program Files\Common files\Microsoft Shared\Web Server Extensions\14\LOGS -
Este directorio contiene información de instalación y run-time tracing logs.

Program Files\Common files\Microsoft Shared\Web Server Extensions\UserCode -
Este directorio contiene archivos que se usan para apoyar sus sandboxed solutions.

Program Files\Common files\Microsoft Shared\Web Server Extensions\WebClients -
Este directorio contiene los archivos relacionados con el nuevo Client Object Model.

Program Files\Common files\Microsoft Shared\Web Server Extensions\WebServices -
Este directorio contiene los archivos de wcf or .svc

3-Configurar una granja de 3 servidores en Sharepoint 2010

http://www.microsoft.com/en-us/download/details.aspx?displaylang=en&id=29420

4-Conversión de documentos en Sharepoint 2010

http://www.sharepointblog.co.uk/2012/05/web-content-management-document-conversion-in-sharepoint/

5-Agregar una propiedad a nuestro perfil de usuario desde BDC

http://sharepointreferences.wordpress.com/2012/04/19/how-to-augment-user-profile-properties-using-bdc-and-the-secure-store/

http://sharepointreferences.wordpress.com/2012/04/19/how-to-augment-user-profile-properties-using-bdc-and-the-secure-store-part2/

http://sharepointreferences.wordpress.com/2012/04/19/how-to-augment-user-profile-properties-using-bdc-and-the-secure-store-part3/

6-Proceso de Instalación de Sharepoint 2010

http://sharepointreferences.wordpress.com/2012/05/14/sharepoint-installation-process-part-1/

http://sharepointreferences.wordpress.com/2012/05/14/sharepoint-installation-process-part-2/

http://sharepointreferences.wordpress.com/2012/05/14/sharepoint-installation-process-part-3/

http://sharepointreferences.wordpress.com/2012/05/14/sharepoint-installation-process-part-4/

http://sharepointreferences.wordpress.com/2012/05/14/sharepoint-installation-process-part-5/

http://sharepointreferences.wordpress.com/2012/05/14/sharepoint-installation-process-part-6/

7-Galería de conectores de search para búsqueda federada

http://technet.microsoft.com/en-US/sharepoint/ff727944

Instrucciones de uso: http://technet.microsoft.com/en-US/sharepoint/ff727944#2010

Links útiles #14–Sharepoint 2010

1-Requerimientos de espacio para Sharepoint 2010

http://blogs.msdn.com/b/mohamed_el_ashmawi/archive/2012/03/19/sharepoint-2010-capacity-management-disk-space-requirements.aspx

2-Resetear un theme a default

http://blog.falchionconsulting.com/index.php/2011/08/resetting-sharepoint-2010-themes/

3-Aplicar tema via programación a un sitio nuevo mediante una feature y event receiver

http://www.enjoysharepoint.com/Articles/Details/how-to-use-webprovisioned-event-in-sharepoint-2010-3.aspx

http://hermansberghem.blogspot.com.ar/2011/11/alternatecssurl-save-site-to-template.html?utm_source=BP_recent

http://howtosharepoint.blogspot.com.ar/2010/04/how-to-apply-theme-programmatically.html

http://blog.qumsieh.ca/2010/10/07/how-to-attach-an-event-receiver-to-the-web-added-event-and-for-what-purpose/

4-Organizador de contenido

http://geeks.ms/blogs/marchena/archive/2012/03/30/content-organizer-moviendo-documentos-entre-repositorios.aspx

5-Content By Query Web Part

http://chrisstahl.wordpress.com/2011/07/18/display-news-pages-with-cqwp-part-3/

http://chrisstahl.wordpress.com/2011/08/09/image-slideshow-with-cqwp-in-sharepoint-2010/

http://farhanfaiz.wordpress.com/2012/03/28/sharepoint-content-query-web-part-more-than-three-filters-and-queryoverride/

6-Data View Web Part

http://chrisstahl.wordpress.com/2011/09/18/how-to-customize-a-grouped-view-in-the-data-view-web-part/

http://chrisstahl.wordpress.com/2011/02/14/display-random-items-with-the-data-view-web-part/

7-Visualización de Workflows con Visio

http://blogs.technet.com/b/meamcs/archive/2012/03/27/walkthrough-sharepoint-2010-workflow-visualization.aspx

8-SharePoint Online for Office 365: Developer Guide

http://www.microsoft.com/download/en/details.aspx?id=17069

9-Renombrar la base de datos de metadata

http://blog.brainlitter.com/2012/03/30/renaming-the-sharepoint-2010-managed-metadata-database/

10-Content Type Syndication Hub

https://docs.google.com/open?id=0BylR0frusV7oY2lpZWYxMWVTNHUtMzRaSkUzLVJMdw

11-Reemplazar todas las instancias de un usuario de los campos Modified By y Created By

http://blog.blksthl.com/2012/04/02/replace-all-instances-of-a-user-in-last-modified-and-created-by-using-powershell/

Links útiles #12 – Sharepoint 2010

1-Search multilenguaje Sharepoint 2010

http://blogs.msdn.com/b/opal/archive/2010/06/28/multilingual-search-in-sharepoint-server-2010-and-fast-search-server-2010.aspx

2-Crear un slider de contenido con Sharepoint y Jquery

https://www.nothingbutsharepoint.com/sites/eusp/pages/creating-your-own-content-slider-for-sharepoint.aspx

3-Alias de SQL Server 2008 R2 con Sharepoint 2010

http://www.sharepointassist.com/2010/02/02/configure-a-sql-server-alias-for-sharepoint-sql-server-2008/

4-Filtrar una lista de Sharepoint con jquery y un combo

http://request4it.wordpress.com/2012/03/13/filter-a-sharepoint-list-with-jquery/

5-Puertos necesarios para un farm de Sharepoint 2010

http://geeks.ms/blogs/ciin/archive/2012/03/21/sharepoint-2010-puertos-necesarios-para-un-despliegue-en-modo-granja.aspx

6-Script para habilitar todas las features de IIS para usar Sharepoint 2010

http://otak-otak-it.blogspot.com.ar/2012/03/automatic-iis-configuration-script-for.html

7-Eligiendo la tecnología de reportes correcta

http://devinknightsql.wordpress.com/2012/03/01/choosing-the-right-microsoft-reporting-technology-part-1-report-services/

http://devinknightsql.wordpress.com/2012/03/06/choosing-the-right-microsoft-reporting-technology-part-2-excel/

http://devinknightsql.wordpress.com/2012/03/15/choosing-the-right-microsoft-reporting-technology-part-3-powerpivot/

http://devinknightsql.wordpress.com/2012/03/21/choosing-the-right-microsoft-reporting-technology-part-4-performancepoint/

8-Reglas: Analizador/mantenimiento de base de datos de Sharepoint 2010

http://www.mssqltips.com/sqlservertip/2648/sharepoint-2010-databases-maintenance-health-analyzer-rules/

9-Configurando el Panel de refinamiento Sharepoint 2010

http://geeks.ms/blogs/marchena/archive/2012/03/22/configuraci-243-n-del-panel-de-refinamiento-en-los-resultados-de-b-250-squeda.aspx

10-Configurar el servicio de user profile

http://www.anhero.org/how-to-configuration-the-user-profile-service-in-sharepoint-2010/

11- Extendiendo la parte social de Sharepoint

http://www.sharepointnutsandbolts.com/2012/03/extending-sharepoint-2010-social.html?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+ChrisObrien+%28Chris+O%27Brien+%5BMVP+SharePoint%5D%29

12-Crear una columna autoincremental con formato definido

http://dlairman.wordpress.com/2011/01/10/add-a-unique-auto-incrementing-column-to-a-sharepoint-list/

13-Desarrollando un BCS de Sharepoint 2010 con Visual Studio 2010

http://www.sharepointbriefing.com/spcode/develop-a-business-data-connectivity-model-for-sps-2010-using-vs-2010.html

14-Almacenar datos de configuración para los jobs

http://blogs.microsoft.co.il/blogs/itaysk/archive/2012/03/23/storing-configuration-settings-for-timer-jobs.aspx

15-Acceder a Sharepoint 2010 vía tecnologías de cliente.

http://platinumdogs.wordpress.com/2012/03/20/sharepoint-displaying-list-data-with-client-side-technology-spservices-jquery-jsrender/

16-Cómo saber a que proceso atachar el debbuger en Visual Studio 2010 y Sharepoint 2010

http://ybbest.wordpress.com/2012/03/22/how-to-find-which-w3wp-exe-to-attach-when-debugging-your-sharepiont2010-project/

17-Servicios disponibles en las dos versiones de Sharepoint 2010 (Standart & Enterprise)

http://www.etechplanet.com/blog/service-applications-available-out-of-the-box-with-sharepoint-2010-products.aspx

18-Importar las managed property y crawled property

http://gallery.technet.microsoft.com/Import-Search-CrawledManage-1fa3d94b

19-Optimizando la performance de reporting services

http://sqlcat.com/sqlcat/b/technicalnotes/archive/2009/01/14/reporting-services-performance-optimizations.aspx

20-Mejores prácticas para backups & restore de Sharepoint 2010

http://smallcitydesign.com/sharepoint-2010-backup-and-recovery-best-practices/

Link útiles #11–Sharepoint 2010

1- Buscar contenido externo usando BCS

http://blogs.msdn.com/b/ericwhite/archive/2010/04/28/searching-external-data-in-sharepoint-2010-using-business-connectivity-services.aspx

2-Configurar Form Based Authentication y SQL Membership Provider

http://jasear.wordpress.com/2012/03/16/sharepoint-2010-setting-up-form-based-authentication-fba-using-asp-net-sql-membership-provider/

3-Usando CONTAINS con FULLTETSQLQUERY

http://platinumdogs.wordpress.com/2012/03/12/sharepoint-using-the-contains-predicate-with-fulltextsqlquery/

4-Crear columnas o fields de listas de manera programática (Single line of text, multiline text, boolean, number, choice, user field, date time field, lookup field, modificar una vista)

http://aleemsheikh.wordpress.com/2012/03/16/creating-list-fields-programmatically-in-sharepoint-2010-2/

5-Redireccionar un formulario infopath después de hacer el submit

http://www.tcscblog.com/2011/06/29/redirect-an-infopath-form-web-part-after-submit/

6-Filtrar un combo en infopath, dependiendo del valor de otro valor seleccionado

http://dataqueen.unlimitedviz.com/2012/03/dynamically-filter-a-drop-down-on-your-sharepoint-list-by-another-user-selected-value/

7-Usar una conexión de base de datos en infopath

http://dataqueen.unlimitedviz.com/2012/03/use-a-sql-server-data-source-for-an-infopath-pick-list/

8-Configurar el servicio de Search en Sharepoint 2010

http://mosshosting.asphostportal.com/?p=1989

9-Configurar el Servicio de User Profile

http://mosshosting.asphostportal.com/?p=2029

10-Permitir SSL en Sharepoint 2010

http://mosshosting.asphostportal.com/?p=2029

Link útiles #10 Sharepoint 2010

1-Consideraciones de capacidad al diseñar una farm

http://blogs.msdn.com/b/mohamed_el_ashmawi/archive/2012/03/12/sharepoint-2010-capacity-management-farm-design-considerations.aspx

2-Documento que describe las características y los pasos para migrar a FAST SEARCH

http://technet.microsoft.com/en-us/library/bb735129.aspx

3-Diseño de listas de gran tamaño y maximización del rendimiento de listas

http://technet.microsoft.com/es-ar/library/cc262813(v=office.14).aspx

4-Implementando un Secure Store Provider

http://pholpar.wordpress.com/2012/03/13/implementing-a-simple-secure-store-provider/

5-Microsoft Script Explorer for Windows PowerShell Beta 1

http://blogs.technet.com/b/heyscriptingguy/archive/2012/03/14/microsoft-script-explorer-for-windows-powershell-beta-1-now-available.aspx

6-Habilitar accesos cross dominios en Infopath forms services

http://www.thesharepointblog.net/Lists/Posts/Post.aspx?List=815f255a-d0ef-4258-be2a-28487dc9975c&ID=108

7-Mapeo de Powershell y Stsadm

http://www.dhirendrayadav.com/2012/02/stsadm-to-windows-powershell-mapping.html

8- Instalar un certificados de seguridad

http://blog.brainlitter.com/2012/03/13/sharepoint-2010-and-cert-trust-could-not-establish-trust-relationship-for-the-ssltls-secure-channel/

9-Facebook Kit for SharePoint

http://fks.codeplex.com/

10-Sharepoint Skype status field

http://skypestatusfield.codeplex.com/

11-Configurar Sharepoint y Exchange

http://www.anhero.org/how-to-configuration-incoming-email-in-sharepoint-2010-with-exchange-step-by-step-guide/

Añadir servidores de base de datos a una granja existente

En SharePoint 2010 se administran una gran variedad de bases de datos. Tenemos la BD de Configuración, BDs de Contenido y BDs para las aplicaciones de servicio.

En algunos escenarios es recomendable que las bases de datos de contenido estén alojadas en servidores de BD separados, el mismo caso se cumple para las BDs de Aplicaciones de Servicio como por ejemplo las  BDs del servicio de búsqueda.

El procedimiento para agregar nuevos servidores de BD a la granja lo obtuve del siguiente enlace:http://technet.microsoft.com/en-us/library/cc262781.aspx

Paso a describir el procedimiento:

1. Primero debemos instalar un servidor de SQL Server 2008 R2 que disponga de las mismas actualizaciones del servidor de BD que aloja nuestra de BD de configuración (Verificar las actualizaciones). Este servidor debe estar unido al dominio.

Sharepoint 2010–Orden correcto de instalación

1. SharePoint 2010 RTM + SP1 (slipstreamed)
2. Configure Farm using PowerShell
3. Office Web Apps RTM + SP1 (slipstreamed)
4. Run SharePoint Config Wizard (PSConfig) on all severs
5. SharePoint 2010 Server Language Pack RTM + SP1 (slipstreamed)
6. Run SharePoint Config Wizard (PSConfig) on all servers
7. Install OCT 2011 CU (or current recommended CU)
8. Run SharePoint Config Wizard (PSConfig) on all servers

Additional Note: Sometimes after installing CU’s I’ve noticed errors when trying to run the SharePoint Products Configuration Wizard (PSConfig), like in the screenshot below. In my case the PSConfig wizard was complaining about missing language packs and the CU files, which I could confirm had been installed properly and there before installing the CU. To fix this, I simply forced PSConfig through PowerShell – avoiding the GUI – and it worked like a charm!

psconfig.exe -cmd installcheck -noinstallcheck

There's also IISRESET and rebooting your servers as potential fixes too.

Instalación de Sharepoint–Cuentas locales

Al instalar una instancia de Sharepoint y SQL Server en un mismo servidor, en el momento de la configuración con PSCONFIG, nos lanzará el siguiente error al agregar una cuenta de farm.

The specified user xxxx\yyy is a local account. (el usuario especificado es una cuenta local)

Local accounts should only be used in stand alone mode. (cuentas locales deben usarse en mode stand alone)

Solución:

1. New-SPConfigurationDatabase
2. Cargo los datos indicados

Powershell script to pre-download prerequisites Sharepoint 2010

This script will download all files required by Prerequisiteinstaller.exe in advance, in order to support an 'offline' installation of SharePoint 2010 (that is, on a server without Internet connectivity, as is often the case). Normally it will attempt to download any missing files, which of course doesn't help you if your server can't browse the Internet. Thankfully, PrerequisiteInstaller.exe also accepts command-line switches to allow installation from a locally-accessible file for each respective hotfix/prerequisite.

The script contains a list (current as of this writing) of the URLs for each prerequisite, and attempts to download them all in sequence.

Descargar: http://gallery.technet.microsoft.com/bcf3332d-f726-4ac7-b01a-eeda4b7ece8e