SQL Server

The following article gives instructions on how to configure Sharepoint Search to index a Lotus Domino Database http://blogs.msdn.com/enterprisesearch/archive/2007/10.aspx http://blogs.msdn.com/enterprisesearch/archive/2007/10/18/how-to-setup-the-moss-2007-protocol-handler-for-lotus-notes-to-search-multiple-domino-databases-part-1-of-3.aspx http://blogs.msdn.com/enterprisesearch/archive/2007/10/21/how-to-setup-the-moss-2007-protocol-handler-for-lotus-notes-to-search-multiple-domino-databases-part-2.aspx http://blogs.msdn.com/enterprisesearch/archive/2007/10/23/how-to-troubleshoot-moss-2007-protocol-handler-for-lotus-notes-and-other-tips-tricks-part-3-of-3.aspx Comunidad Windows

HKLM\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{AC76BA86-7AD7-1033-7B44-A81000000003}

If you found the following problem when you try to execute an ASPX that its referenced inside MOSS you should follow the following instructions to correct it. Request for the permission of type 'System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed. First, change the settings to run with medium trust, but I don’t recommend this if you aren't on a safe environment. The other way is change the minimaltrust.config file (found at C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\CONFIG, the file is named wss_minimaltrust.config) and add the SQL Client Assembly. SecurityClass Name="SqlClientPermission" Description="System.Data.SqlClient.SqlClientPermission, System.Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" in the security classes section and then IPermission class="SqlClientPermission"...

If you try to create an Analysis View in Project Server and you get the error "Unable to connecto to server" check you have configured the following in Internet Explorer 1) Make sure that "Access Data Sources Across Domains" is enabled in IE security settings for the zone of the Project Server. 2) Make sure that "Microsoft Office Web Components" & "Microsoft SQL Server 2005 Analysis Services 9.0 OLE DB Provider" are installed on the client computer. See the section "Requirements for building and viewing cubes in Project Web Access" in this document for more details: http://technet2.microsoft.com/Office/en-us/library/86910044-701c-4b02-89d7-e094e9cb7dcd1033.mspx?mfr=true Regards, Eduardo Castro Comunidad Windows - Costa Rica

Un sitio de IIS en el cual se le asigno un host header solicita autenticación y despues de varios intentos dice 401, pero si se accede desde un servidor remoto si funciona, para resolver esto debe seguir los pasos indicados en este artículo http://support.microsoft.com/kb/896861 Method 1: Disable the loopback check Follow these steps: Click Start , click Run , type regedit, and then click OK . In Registry Editor, locate and then click the following registry key: HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa Right-click Lsa , point to New , and then click DWORD Value . Type DisableLoopbackCheck, and then press ENTER. Right-click DisableLoopbackCheck , and then click Modify . In the Value data box, type 1, and then click OK . Quit Registry Editor, and then restart your computer. Back to the top Method 2: Specify host names To specify the host names that are mapped to the loopback address and can connect to Web sites on ...

Para configurarlo se tiene que copiar el contenido del directorio C:\Program Files\Microsoft SQL Server\MSSQL.1\OLAP\bin\isapi en un directorio en Inetpub Despues se tiene que crear un directorio virtual para ese nuevo directorio, en la configuracion del directorio virtual se tiene que autorizar la extension .dll para que sea procesada por msmdpump.dll   Se debe configurar la seguridad. Por ultimo se tiene que autorizar la extension msmdpump.dll dentro del IIS para esto hay que ir al IIS y Web Service Extensions autorizar el msmdpump.dll tal y como se ve en la siguiente pantalla Despues de eso podra acceder al Analisys Service via web por ejemplo /olap/msmdpump.dll">http://<server_name>/olap/msmdpump.dll Mas detalles en http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/CISQL2005ASCS.mspx http://www.microsoft.com/technet/prodtechnol/sql/2005/httpssas.mspx

Si se presenta el siguiente error Error: The connection string to repository needs to be specified in the 9.0 server properties (see <DSO>…</DSO> section in msmdsrv.ini file from Analysis Services 9.0   Se debe a lo siguiente: el usuario con el cual se ejecta el Project Service Queue y el SharePoint Shared Service Provider deben tener acceso a lo siguiente: - Full control sobre el repositorio MSOLAPReports$ -Debe estar configurado el DSO Remote Connection String -Deben tener derechos de administrador en el OLAP Server,esto es desde el análisis services -Deben Tener derechos de escribir en la BD de repositorio   Slds Eduardo Castro Comunidad Windows Costa Rica

  Para evitar este problema siga los siguientes pasos En Central Administration-Authentication Providers se eliminó la opción Enable Client Integration En el web.config del sitio de Internet se borro la siguiente línea del web.config <add verb="OPTIONS,PROPFIND,PUT,LOCK,UNLOCK,MOVE,COPY,GETLIB,PROPPATCH,MKCOL,DELETE,(GETSOURCE),(HEADSOURCE),(POSTSOURCE)" path="*" type="Microsoft.SharePoint.ApplicationRuntime.SPHttpHandler, Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" /> Esta linea estaba en esta seccion del web.config <httpHandlers> <remove verb="GET,HEAD,POST" path="*" /> <add verb="GET,HEAD,POST" path="*" type="Microsoft.SharePoint.ApplicationRuntime.SPHttpHandler, Microsoft.SharePoint, Version=12.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c" /> <add verb="OPTIONS,PROPFIND,PUT,LOCK,UNLOCK,MOVE,COP...

En esta dirección encontrarán el material sobre la charla IE8 realizada el 29 de octubre.   http://comunidadwindows.org/files/folders/ie8/default.aspx   Slds   Eduardo Castro – http://comunidadwindows.org

Si tienen instalado Windows Sharepoint Services, Sharepoint Office Server o Project Server 2007 deben instalar el Infrastruture Update el cual agrega estabilidad y rendimiento a estos productos, está disponible en esta dirección http://www.microsoft.com/downloads/details.aspx?FamilyId=3811C371-0E83-47C8-976B-0B7F26A3B3C4&displaylang=en   Slds   Eduardo Castro Comunidad Windows – http://comunidadwindows.org   Technorati Tags: wss , moss

Excelente lista de recursos creada por Joel Oleson   http://blogs.msdn.com/joelo/archive/2007/10/12/sharepoint-deployment-essentials-and-resources.aspx SharePoint Deployment Essentials and Resources With a number of recent simplified releases I wanted to share what I'd call the SharePoint Deployment Essentials... First My Simplified Favorites, then some more verbose resources.  My latest attempt at capturing the best is in this SharePoint Deployment Essentials Guide , something I recommend as a must have for both the business stakeholders, the project manager, and the entire deployment team. Deployment Essentials (My Recommendations) Governance Checklist Guide (I consider this a deployment checklist) MOSS Deployment Project Plan Sample ( Project 2003 format , Project 2007 format ) Governance/Business/Service Plan Template Information Security and Use Policies Samples Configuration Management Considerations (Recent blog post) Tips on Site Collection Sizi...

  El siguiente es un ejemplo de código de Microsoft sobre cómo implementar un Membership Provider personalizado.   using System.Web.Security; using System.Configuration.Provider; using System.Collections.Specialized; using System; using System.Data; using System.Data.Odbc; using System.Configuration; using System.Diagnostics; using System.Web; using System.Globalization; using System.Security.Cryptography; using System.Text; using System.Web.Configuration; /* This provider works with the following schema for the table of user data. CREATE TABLE Users ( PKID Guid NOT NULL PRIMARY KEY, Username Text (255) NOT NULL, ApplicationName Text (255) NOT NULL, Email Text (128) NOT NULL, Comment Text (255), Password Text (128) NOT NULL, PasswordQuestion Text (255), PasswordAnswer Text (255), IsApproved YesNo, LastActivityDate DateTime, LastLoginDate DateTime, LastPasswordChangedDate DateTime, CreationDate DateTime, IsOnLine YesNo, IsLockedOut YesNo,...