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