SQL SERVER 2012 Enterprise vs Business Intelligence vs Standard vs Web vs Express with Advanced Services vs Express with Tools vs Express December 10, 2012
Posted by juanpablo1manrique in SharePoint.1 comment so far
Y en este mundo de las comparaciones …
| SQL SERVER 2012 | Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Cross-Box Scale Limits | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Maximum Compute Capacity Used by a Single Instance (SQL Server Database Engine)1 | Operating System maximum | Limited to lesser of 4 Sockets or 16 cores | Limited to lesser of 4 Sockets or 16 cores | Limited to lesser of 4 Sockets or 16 cores | Limited to lesser of 1 Socket or 4 cores | Limited to lesser of 1 Socket or 4 cores | Limited to lesser of 1 Socket or 4 cores |
| Maximum Compute Capacity Used by a Single Instance (Analysis Services, Reporting Services) 1 |
Operating system maximum | Operating system maximum | Limited to lesser of 4 Sockets or 16 cores | Limited to lesser of 4 Sockets or 16 cores | Limited to lesser of 1 Socket or 4 cores | Limited to lesser of 1 Socket or 4 cores | Limited to lesser of 1 Socket or 4 cores |
| Maximum memory utilized (SQL Server Database Engine) | Operating system maximum | 64 GB | 64 GB | 64 GB | 1 GB | 1 GB | 1 GB |
| Maximum memory utilized (Analysis Services) | Operating system maximum | Operating system maximum | 64 GB | N/A | N/A | N/A | N/A |
| Maximum memory utilized (Reporting Services) | Operating system maximum | Operating system maximum | 64 GB | 64 GB | 4 GB | N/A | N/A |
| Maximum relational Database size | 524 PB | 524 PB | 524 PB | 524 PB | 10 GB | 10 GB | 10 GB |
| High Availability (AlwaysOn) | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Server Core support1 | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Log Shipping | Yes | Yes | Yes | Yes | |||
| Database mirroring | Yes | Yes (Safety Full Only) | Yes (Safety Full Only) | Witness only | Witness only | Witness only | Witness only |
| Failover Clustering | Yes (Node support: Operating system maximum | Yes (Node support: 2) | Yes (Node support: 2) | ||||
| Backup compression | Yes | Yes | Yes | ||||
| Database snapshot | Yes | ||||||
| AlwaysOn Availability Groups | Yes | ||||||
| SQL Server Multi-Subnet Clustering | Yes | ||||||
| Mirrored backups | Yes | ||||||
| Hot Add Memory and CPU2 | Yes | ||||||
| Database Recovery Advisor | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Scalability and Performance | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Multi-instance support | 50 | 50 | 50 | 50 | 50 | 50 | 50 |
| Table and index partitioning | Yes | ||||||
| Data compression | Yes | ||||||
| Resource Governor | Yes | ||||||
| Partition Table Parallelism | Yes | ||||||
| Multiple Filestream containers | Yes | ||||||
| Security | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Basic Auditing | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Fine Grained Auditing | Yes | ||||||
| Transparent database encryption | Yes | ||||||
| Extensible Key Management | Yes | ||||||
| User-Defined Roles | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Contained Databases | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Replication | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| SQL Server change tracking | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Merge replication | Yes | Yes | Yes | Yes (Subscriber only) | Yes (Subscriber only) | Yes (Subscriber only) | Yes (Subscriber only) |
| Transactional replication | Yes | Yes | Yes | Yes (Subscriber only) | Yes (Subscriber only) | Yes (Subscriber only) | Yes (Subscriber only) |
| Snapshot replication | Yes | Yes | Yes | Yes (Subscriber only | Yes (Subscriber only) | Yes (Subscriber only) | Yes (Subscriber only) |
| Heterogeneous subscribers | Yes | Yes | Yes | ||||
| Oracle publishing | Yes | ||||||
| Peer to Peer transactional replication | Yes | ||||||
| Management Tools | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| SQL Management Objects (SMO) | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| SQL Configuration Manager | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| SQL CMD (Command Prompt tool) | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| SQL Server Management Studio | Yes | Yes | Yes | Yes | Yes | Yes | |
| Distributed Replay – Admin Tool | Yes | Yes | Yes | Yes | Yes | Yes | |
| Distributed Replay – Client | Yes | Yes | Yes | Yes | |||
| Distributed Replay – Controller | Yes (Enterprise supports up to 16 clients, Developer supports only 1 client) | Yes (1 client support only) | Yes (1 client support only) | Yes (1 client support only) | |||
| SQL Profiler | Yes | Yes | Yes | No2 | No2 | No2 | No2 |
| SQL Server Agent | Yes | Yes | Yes | Yes | |||
| Microsoft System Center Operations Manager Management Pack | Yes | Yes | Yes | Yes | |||
| Database Tuning Advisor (DTA) | Yes | Yes | Yes3 | Yes3 | |||
| RDBMS Manageability | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| User Instances | Yes | Yes | Yes | ||||
| LocalDB | Yes | Yes | |||||
| Dedicated admin connection | Yes | Yes | Yes | Yes | Yes (under trace flag) | Yes (under trace flag) | Yes (under trace flag) |
| PowerShell scripting support | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| SysPrep support1 | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Support for Data-tier application component operations – extract, deploy, upgrade, delete |
Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Policy automation (check on schedule and change) | Yes | Yes | Yes | Yes | |||
| Performance data collector | Yes | Yes | Yes | Yes | |||
| Able to enroll as a managed instance in a multi-instance management | Yes | Yes | Yes | Yes | |||
| Standard performance reports | Yes | Yes | Yes | Yes | |||
| Plan guides and plan freezing for plan guides | Yes | Yes | Yes | Yes | |||
| Direct query of indexed views (using NOEXPAND hint) | Yes | Yes | Yes | Yes | |||
| Automatic indexed view maintenance | Yes | Yes | Yes | Yes | |||
| Distributed partitioned views | Yes | Partial. Distributed Partitioned Views are not updatable | Partial. Distributed Partitioned Views are not updatable | Partial. Distributed Partitioned Views are not updatable | Partial. Distributed Partitioned Views are not updatable | Partial. Distributed Partitioned Views are not updatable | Partial. Distributed Partitioned Views are not updatable |
| Parallel indexed operations | Yes | ||||||
| Automatic use of indexed view by query optimizer | Yes | ||||||
| Parallel consistency check | Yes | ||||||
| SQL Server Utility control point | Yes | ||||||
| Contained Databases | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Development Tools | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Microsoft Visual Studio Integration | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| SQL Server Developer Studio | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Intellisense (Transact-SQL and MDX) 1 | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| SQL Server Data Tools (SSDT) | Yes | Yes | Yes | Yes | Yes | ||
| SQL query edit and design tools1 | Yes | Yes | Yes | ||||
| Version control support1 | Yes | Yes | Yes | ||||
| MDX edit, debug, and design tools1 | Yes | Yes | Yes | ||||
| Programmability | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Common Language Runtime (CLR) Integration | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Native XML support | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| XML indexing | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| MERGE & UPSERT Capabilities | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| FILESTREAM support | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| FileTable | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Date and Time datatypes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Internationalization support | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Full-text and semantic search | Yes | Yes | Yes | Yes | Yes | ||
| Specification of language in query | Yes | Yes | Yes | Yes | Yes | ||
| Service Broker (messaging) | Yes | Yes | Yes | No (Client only) | No (Client only) | No (Client only) | No (Client only) |
| Web services (HTTP/SOAP endpoints) | Yes | Yes | Yes | Yes | |||
| TSQL endpoints | Yes | Yes | Yes | Yes | |||
| Integration Services | |||||||
|
Feature
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| SQL Server Import and Export Wizard | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Built-in data source connectors | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| SSIS designer and runtime | Yes | Yes | Yes | ||||
| Basic Transforms | Yes | Yes | Yes | ||||
| Basic data profiling tools | Yes | Yes | Yes | ||||
| Change Data Capture Service for Oracle by Attunity | Yes | ||||||
| Change Data Capture Designer for Oracle by Attunity | Yes | ||||||
| Integration Services – Advanced Adapters | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| High performance Oracle destination | Yes | ||||||
| High performance Teradata destination | Yes | ||||||
| SAP BW source and destination | Yes | ||||||
| Data mining model training destination adapter | Yes | ||||||
| Dimension processing destination adapter | Yes | ||||||
| Partition processing destination adapter | Yes | ||||||
| Change Data Capture components by Attunity | Yes | ||||||
| Connector for Open Database Connectivity (ODBC) by Attunity | Yes | ||||||
| Integration Services – Advanced Transforms | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Persistent (high performance) lookups | Yes | ||||||
| Data mining query transformation | Yes | ||||||
| Fuzzy grouping and lookup transformations | Yes | ||||||
| Term extractions and lookup transformations | Yes | ||||||
| Master Data Services | |||||||
|
Feature
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Master Data Services database | Yes | Yes | |||||
| Master Data Manager web application | Yes | Yes | |||||
| Data Warehouse | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Create cubes without a database | Yes | Yes | Yes | ||||
| Auto-generate staging and data warehouse schema | Yes | Yes | Yes | ||||
| Change data capture | Yes | ||||||
| Star join query optimizations | Yes | ||||||
| Scalable read-only Analysis Services configuration | Yes | ||||||
| Parallel query processing on partitioned tables and indices | Yes | ||||||
| xVelocity memory optimized columnstore indexes | Yes | ||||||
| Analysis Services | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Scalable Shared Databases (Attach/Detach, Read only databases) | Yes | Yes | |||||
| High Availability | Yes | Yes | Yes | ||||
| Programmability (AMO, ADOMD.Net, OLEDB, XML/A, ASSL) | Yes | Yes | Yes | ||||
| BI Semantic Model (Multidimensional) | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Semi-additive Measures | Yes | Yes | No1 | ||||
| Hierarchies | Yes | Yes | Yes | ||||
| KPIs | Yes | Yes | Yes | ||||
| Perspectives | Yes | Yes | |||||
| Actions | Yes | Yes | Yes | ||||
| Account intelligence | Yes | Yes | Yes | ||||
| Time Intelligence | Yes | Yes | Yes | ||||
| Custom rollups | Yes | Yes | Yes | ||||
| Writeback cube | Yes | Yes | Yes | ||||
| Writeback dimensions | Yes | Yes | |||||
| Writeback cells | Yes | Yes | Yes | ||||
| Drillthrough | Yes | Yes | Yes | ||||
| Advanced hierarchy types (Parent-Child, Ragged Hiearchies) | Yes | Yes | Yes | ||||
| Advanced dimensions (Reference dimensions, many-to-many dimensions | Yes | Yes | Yes | ||||
| Linked measures and dimensions | Yes | Yes | |||||
| Translations | Yes | Yes | Yes | ||||
| Aggregations | Yes | Yes | Yes | ||||
| Multiple Partitions | Yes | Yes | Yes, up to 3 | ||||
| Proactive Caching | Yes | Yes | |||||
| Custom Assemblies (stored procs) | Yes | Yes | Yes | ||||
| MDX queries and scripts | Yes | Yes | Yes | ||||
| Role-based security model | Yes | Yes | Yes | ||||
| Dimension and Cell-level Security | Yes | Yes | Yes | ||||
| Scalable string storage | Yes | Yes | Yes | ||||
| MOLAP, ROLAP, HOLAP storage modes | Yes | Yes | Yes | ||||
| Binary and compressed XML transport | Yes | Yes | Yes | ||||
| Push-mode processing | Yes | Yes | |||||
| Direct Writeback | Yes | Yes | |||||
| Measure Expressions | Yes | Yes | |||||
| BI Semantic Model (Tabular) | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Hierarchies | Yes | Yes | |||||
| KPIs | Yes | Yes | |||||
| Semi-additive Measures | Yes | Yes | |||||
| Perspectives | Yes | Yes | |||||
| Translations | Yes | Yes | |||||
| DAX calculations, DAX queries, MDX queries | Yes | Yes | |||||
| Row-level Security | Yes | Yes | |||||
| Partitions | Yes | Yes | |||||
| In-Memory and DirectQuery storage modes (Tabular only) | Yes | Yes | |||||
| PowerPivot for SharePoint | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| SharePoint farm integration based on shared service architecture | Yes | Yes | |||||
| Usage reporting | Yes | Yes | |||||
| Health monitoring rules | Yes | Yes | |||||
| PowerPivot Gallery | Yes | Yes | |||||
| PowerPivot Data Refresh | Yes | Yes | |||||
| PowerPivot Data Feeds | Yes | Yes | |||||
| Data Mining | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Standard Algorithms | Yes | Yes | Yes | ||||
| Data Mining Tools (Wizards, Editors Query Builders) | Yes | Yes | Yes | ||||
| Cross Validation | Yes | Yes | |||||
| Models on Filtered Subsets of Mining Structure Data | Yes | Yes | |||||
| Time Series: Custom Blending Between ARTXP and ARIMA Methods | Yes | Yes | |||||
| Time Series: Prediction with New Data | Yes | Yes | |||||
| Unlimited Concurrent DM Queries | Yes | Yes | |||||
| Advanced Configuration & Tuning Options for Data Mining Algorithms | Yes | Yes | |||||
| Support for plug-in algorithms | Yes | Yes | |||||
| Parallel Model Processing | Yes | Yes | |||||
| Time Series: Cross-Series Prediction | Yes | Yes | |||||
| Unlimited attributes for Association Rules | Yes | Yes | |||||
| Sequence Prediction | Yes | Yes | |||||
| Multiple Prediction Targets for Naïve Bayes, Neural Network and Logistic Regression | Yes | Yes | |||||
| Reporting Services Features | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Supported catalog DB SQL Server edition | Standard or higher | Standard or higher | Standard or higher | Web | Express | ||
| Supported data source SQL Server edition | All SQL Server editions | All SQL Server editions | All SQL Server editions | Web | Express | ||
| Report server | Yes | Yes | Yes | Yes | Yes | ||
| Report Designer | Yes | Yes | Yes | Yes | Yes | ||
| Report Manager | Yes | Yes | Yes | Yes | Yes | ||
| Role based security | Yes | Yes | Yes | Yes | Yes | ||
| Word Export and Rich Text Support | Yes | Yes | Yes | Yes | Yes | ||
| Enhanced gauges and charting | Yes | Yes | Yes | Yes | Yes | ||
| Export to Excel, PDF, and Images | Yes | Yes | Yes | Yes | Yes | ||
| Custom authentication | Yes | Yes | Yes | Yes | Yes | ||
| Report as data feeds | Yes | Yes | Yes | Yes | Yes | ||
| Model support | Yes | Yes | Yes | Yes | |||
| Create custom roles for role-based security | Yes | Yes | Yes | ||||
| Model Item security | Yes | Yes | Yes | ||||
| Infinite click through | Yes | Yes | Yes | ||||
| Shared component library | Yes | Yes | Yes | ||||
| Email and file share subscriptions and scheduling | Yes | Yes | Yes | ||||
| Report history, execution snapshots and caching | Yes | Yes | Yes | ||||
| SharePoint Integration | Yes | Yes | Yes | ||||
| Remote and non-SQL data source support1 | Yes | Yes | Yes | ||||
| Data source, delivery and rendering, RDCE extensibility | Yes | Yes | Yes | ||||
| Data driven report subscription | Yes | Yes | |||||
| Scale out deployment (Web farms) | Yes | Yes | |||||
| Alerting2 | Yes | Yes | |||||
| Power View2 | Yes | Yes | |||||
| Reporting Services : Report Server Database Server Edition Requirements | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Use this edition of the Database Engine instance to host the database | Standard, Business Intelligence Enterprise, editions (local or remote) | Standard, Business Intelligence Enterprise, editions (local or remote) | Standard, Enterprise editions (local or remote) | Web edition (local only) | Express with Advanced Services (local only). | ||
| Business Intelligence Clients | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Report Builder | Yes | Yes | Yes | ||||
| Data Mining Addins for Excel and Visio 2010 | Yes | Yes | Yes | ||||
| PowerPivot for Excel 2010 | Yes | Yes | |||||
| Master Data Services Add-in for Excel | Yes | Yes | |||||
| Spatial and Location Services | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Spatial indexes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Planar and Geodetic datatypes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Advanced spatial libraries | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Import/export of industry-standard spatial data formats | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Additional Database Services | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| SQL Server Migration Assistant | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Database mail | Yes | Yes | Yes | Yes | |||
| Other Components | |||||||
|
Feature Name
|
Enterprise | Business Intelligence | Standard | Web | Express with Advanced Services | Express with Tools | Express |
| Data Quality Services | Yes | Yes | |||||
| StreamInsight | StreamInsight Premium Edition | StreamInsight Standard Edition | StreamInsight Standard Edition | StreamInsight Standard Edition | |||
| StreamInsight HA | StreamInsight Premium Edition | ||||||
Tomado de http://msdn.microsoft.com/en-us/library/cc645993.aspx
Configuration Wizard SharePoint 2010 vs SharePoint 2013 December 10, 2012
Posted by juanpablo1manrique in SharePoint, SharePoint2013.Tags: SharePoint
add a comment
Continuando con las comparaciones
| SharePoint 2010 | SharePoint 2013 | |
Access Services 2010Allows viewing, editing, and interacting with Access Services 2010 databases in |
X | |
Access ServicesAllows viewing, editing, and interacting with Access Services databases in a browser. |
X | X |
Application Registry ServiceBackwards compatible Business Data Connectivity API. |
X | |
App Management ServiceAllows you to add SharePoint Apps from the SharePoint Store or the App Catalog. |
X | |
Business Data Connectivity ServiceEnabling this service provides the SharePoint farm with the ability to upload BDC |
X | X |
Excel Services ApplicationAllows viewing and interactivity with Excel files in a browser. |
X | X |
Lotus Notes ConnectorSearch connector to crawl the data in the Lotus Notes server. |
X | X |
Machine Translation ServicePerforms automated machine translation. |
X | |
Managed Metadata ServiceThis service provides access to managed taxonomy hierarchies, keywords and social |
X | X |
PerformancePoint Service ApplicationSupports the monitoring and analytic capabilities of PerformancePoint Services such |
X | X |
PowerPoint Conversion Service ApplicationEnables the conversion of PowerPoint presentations to various formats. |
X | |
Search Service ApplicationIndex content and serve search queries. |
X | X |
Secure Store ServiceProvides capability to store data (e.g. credential set) securely and associate it |
X | X |
State ServiceProvides temporary storage of user session data for SharePoint Server components. |
X | X |
Usage and Health data collectionThis service collects farm wide usage and health data and provides the ability to |
X | X |
User Profile Service ApplicationAdds support for My Sites, Profiles pages, Social Tagging and other social computing |
X | X |
Visio Graphics ServiceEnables viewing and refreshing of Visio Web Drawings. |
X | X |
Web Analytics Service ApplicationWeb Analytics Service Application |
X | |
Word Automation ServicesProvides a framework for performing automated document conversions. |
X | X |
Work Management Service ApplicationThis service provides task aggregation across work management systems. |
X | |
Workflow Service ApplicationThis service connects SharePoint to an external workflow service |
X |
SharePoint 2013. The site feature being activate has a dependency on hidden Site Collection scope Feature November 22, 2012
Posted by juanpablo1manrique in Install, SharePoint.Tags: install, SharePoint
add a comment
Y aqui empezamos con SharePoint 2013,
Al intentar activar el feature de Performance Point de SharePoint 2013 me aparecio este error, muy poco diciente,
SharePoint 2013. The site feature being activate has a dependency on hidden Site Collection scope Feature ‘FeatureDefinition/15/05891451-f0c4-4d4e-81b1-0dabd840bad4’ (ID:’05891451-f0c4-4d4e-81b1-0dabd840bad4). Hidden features cannot beauto-activated across scopes. There may be one or more visible site Collection scoped features that auto-activate the dependent hidden feature.
Me puse en la tarea de ver que feature era el que estaba haciendo falta, y encontre BICenter Data Connections Feature,
lo active y al intentar activar nuevamente el Feature de Performance Point este funciono correctamente,
Bueno eso fue todo,
saludos
Archivos ashx y asmx en Empty SharePoint Project November 22, 2012
Posted by juanpablo1manrique in SharePoint.Tags: Developer, SharePoint
add a comment
Me he encontrado con este problema al intentar agregar a un proyecto un archivo ashx y asmx en un Empty SharePoint Project, de sharepoint para que se despliegue en un archivo .wsp
- 1. Debe estar ubicado en Layouts, para lo cual debemos mapear la carpeta en el proyecto,
- 2. Una estrategia es tener un sitio web normal crear el archivo asmx o ashx y luego copiarlo y pegarlo al proyecto de sharepoint esto debido a que la opción de agregar un item no nos da la posibilidad de agregar este tipo de items
- 3. Se comnpila el proyecto y se le da deploy, al hacer esto nos encontramos con el siguiente error Could not create type ‘MyProject.Handler1’.
- 4. Para encontrar la solucion de este problema di bastantes vueltas pero lo encontre de la siguiente manera.
- a. Dentro del proyecto de Sharepoint cree un Visual Web Part el cual en la cabecera tiene una línea <%@ Assembly Name=”$SharePoint.Project.AssemblyFullName$” %>
- b.Esta línea permite que luego de hacer deploy, los archivos que quedan en 14 (C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\TEMPLATE\CONTROLTEMPLATES) esta linea se convierte en <%@ Assembly Name=”MyProject, Version=1.0.0.0, Culture=neutral, PublicKeyToken=7bf1drt64fd3c7da7″ %>
- c. Pero con los archivos asmx y ashx no sucede lo mismo, para este caso fue necesario tomar esta línea y agregarla directamente al archivo, al hacer esto se logro el objetivo luego de hacer deploy de la solucion la misma ya funcionaba correctamente. y es posible utilizar los servicios
Happy SharePoint Coding!!
Try to install windows server 2012 in VMware WorkStation 7.1.1 November 22, 2012
Posted by juanpablo1manrique in Hyper-V, IT, VMware, Windows 2012.Tags: VMWare, Windows2012
add a comment
Hola amigos
En estoy días estuve tratando de instalar Windows 2012 en VMware, pero al intentarlo me desplegaba un error que decia,
Your pc ran into a problem and needs to restart. We’re just collecting some error info, and then we’ll restart for you
If You’d Like To Know More, You Can Search Online Later For This Error: SYSTEM_THREAD_EXCEPTION_NOT_HANDLED
Investigando sobre el tema encontre que desafortunadamente VMware WorkStation no soporta Windows 8 ni Windows 2012 server para poderlo hacer se debe tener VMWare 8 o 9
http://communities.vmware.com/thread/404525
Por ahi me consegui en VMWare 9 que posee soporte para virtualización y efectivamente funciono
Saludos
Language of database does not match language of site October 6, 2012
Posted by juanpablo1manrique in SharePoint.5 comments
Al intentar crear el PWA desde el central administrator
Application Management -> Manage Service Application -> [project application] -> Create Project Web App Site
Aparece un error Failed – see the Application event Log
Al revisar en los archivos de Logs se detecta ek siguiente error
Microsoft.Office.Project.Server.Administration.ProvisionException: Language of database does not match language of site
Solucion
Para resolver este problema, ejecute estos scripts en las bases de datos que estoy migrando
USE ProjectServer_Published
SELECT WADMIN_DEFAULT_LANGUAGE from dbo.MSP_WEB_ADMIN
USE ProjectServer_Draft
SELECT WADMIN_DEFAULT_LANGUAGE FROM dbo.MSP_WEB_ADMIN
USE ProjectServer_Archive
SELECT WADMIN_DEFAULT_LANGUAGE from dbo.MSP_WEB_ADMIN
El resultado fue 3082 o sorpresa estamos en Español asi que fue al central administrator a intentar provisionar de nuevo y seleccione español Ahi se demoro un poco y finalmente funciono
Microsoft.Office.Project.Server.Administration.ProvisionException: Mismatched databases October 6, 2012
Posted by juanpablo1manrique in SharePoint.3 comments
Al intentar crear el PWA desde el central administrator
Application Management -> Manage Service Application -> [project application] -> Create Project Web App Site
Aparece un error Failed – see the Application event Log
Al revisar en los archivos de Logs se detecta ek siguiente error
Microsoft.Office.Project.Server.Administration.ProvisionException: Mismatched databases
Solucion
Aqui fue necesario entrar a las propiedades de la base de datos y verificar en las propiedades extendidas que los GUID coincidieran en las 4 bases de datos, se igualaron todos en nuestras bases de datos ProjectServer_Published, ProjectServer_Draft, ProjectServer_Archive, ProjectServer_Reporting
Luego de corregido este problema se procedio nuevamente a ejecutar el proceso de creación del PWA pero se presento este nuevo inconveniente
New-SPProjectWebInstance : The PWA URL specified is in use in another PWA site or pending provisioning job. October 6, 2012
Posted by juanpablo1manrique in SharePoint.2 comments
En el proceso de migración de la granja al intentar correr el comando
New-SPProjectWebInstance -Url http://project.contoso.com/litware -AdminAccount “CONTOSO\Administrator” -PrimaryDbserver “DEMO2010A” -PublishedDbname “Litware_Published” -ArchiveDbname “Litware_Archive” -DraftDbname “Litware_Draft” -ReportingDbserver “DEMO2010A” -ReportingDbname “Litware_Reporting”
Aparecio este error
New-SPProjectWebInstance : The PWA URL specified is in use in another PWA site or pending provisioning job.
La solución
Este proceso finalmente lo lleve acabo desde el Central administrator. Ingresando por Service application, application project y dando en New Project web site, aqui aparecio en los LOGS el error de ir a revisar el Log en donde encontre
Microsoft.Office.Project.Server.Administration.ProvisionException: Mismatched databases
New-SPProjectWebInstance : Service Application not found. October 6, 2012
Posted by juanpablo1manrique in SharePoint.2 comments
En el proceso de migración de la granja al intentar correr el comando
New-SPProjectWebInstance -Url http://project.contoso.com/litware -AdminAccount “CONTOSO\Administrator” -PrimaryDbserver “DEMO2010A” -PublishedDbname “Litware_Published” -ArchiveDbname “Litware_Archive” -DraftDbname “Litware_Draft” -ReportingDbserver “DEMO2010A” -ReportingDbname “Litware_Reporting”
Aparecio este error
New-SPProjectWebInstance : Service Application not found.
La solución
En este caso faltaba ingresar al central administrator y subir los servicios de Project Server 2010
Services on server y dar start en Project Application Service
Otro paso que faltaba realizar era el de crear el service application
Manage Service applications y crear un service application de project
Migración de Project Server 2007 a Project Server 2010 October 6, 2012
Posted by juanpablo1manrique in SharePoint.1 comment so far
Hola Amigos
He tenido el gusto de realizar una migración de Project Server 2007 a Project Server 2010, y pues aqui les comento mi experiencia con el tema
Antes de empezar, es necesario leer estos excelentes links que encontre
- http://technet.microsoft.com/en-us/library/ee662496
- http://technet.microsoft.com/en-us/library/ee662499(office.14)
- http://technet.microsoft.com/en-us/library/ee662500(office.14)
En este caso propusieron migrar project server en 2 pasos pero el segundo no me funciono y toco hacerlo desde el central administrator igual se los comparto http://blogs.msdn.com/b/chrisfie/archive/2010/05/27/how-to-upgrade-from-project-server-2007-to-project-server-2010-in-10min.aspx
El proceso de migración seleccionado para este caso fue FullDatabase Attach, dentro de esto encontre este link en donde se describen algunos issues bastante comunes
Y pues como siempre me surgieron varios problemas, aqui les comparto la solución
- New-SPProjectWebInstance : Service Application not found.
- New-SPProjectWebInstance : The PWA URL specified is in use in another PWA site or pending provisioning job.
- Microsoft.Office.Project.Server.Administration.ProvisionException: Mismatched databases
- Language of database does not match language of site
Saludos
Letras y Números 
