Posts

Showing posts from 2008

MOSS Search and Lotus

uninstall script

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

MOSS SQL SqlClient Request for the permission type

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"

Configurar creaciones Vistas Analisis en Project Server - Analysis View Create in Project Server

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 Explorer1) 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 CastroComunidad Windows - Costa Rica

Pide autentencación un sitio con Host Header

Image
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ículohttp://support.microsoft.com/kb/896861Method 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\LsaRight-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 topMethod 2: Specify host names To specify the host names that are mapped to the loopback address and can connect to Web sites on your computer, follow these steps: Click Start, click Run, ty…

Configurar Analisis Services por HTTP

Image
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 InetpubDespues 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.dllSe 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 pantallaDespues de eso podra acceder al Analisys Service via web por ejemplo /olap/msmdpump.dll">http://<server_name>/olap/msmdpump.dllMas detalles en http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/CISQL2005ASCS.mspxhttp://www.microsoft.com/technet/prodtechnol/sql/2005/httpssas.mspx

Conexion de Cubos en Project Server

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.0Se 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 repositorioSldsEduardo CastroComunidad WindowsCosta Rica

MOSS Sharepoint documento anonimos piden autenticacion

Para evitar este problema siga los siguientes pasosEn Central Administration-Authentication Providers se eliminó la opción Enable Client IntegrationEn 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,COPY,GETLIB,PROPPATCH,MKCOL,DELETE…

Material de la charla sobre Internet Explorer 8

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

Infrastructure Update for Microsoft Office Servers (KB951297)

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=enSldsEduardo CastroComunidad Windows – http://comunidadwindows.orgTechnorati Tags: ,

Recursos de SharePoint

Excelente lista de recursos creada por Joel Olesonhttp://blogs.msdn.com/joelo/archive/2007/10/12/sharepoint-deployment-essentials-and-resources.aspxSharePoint Deployment Essentials and ResourcesWith 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 TemplateInformation Security and Use Policies SamplesConfiguration Management Considerations (Recent blog post)Tips on Site Collection Sizing, Tips on Database Sizing, Tips on List…

Custom Membership Provider para Forms Authentication y MOSS

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,
LastLockedOutDate DateTime,
FailedPasswordAttempt…