Sunday, December 07, 2008

uninstall script

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

Friday, December 05, 2008

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"
version="1"
Unrestricted="true"



on the named permissions set.

Thursday, December 04, 2008

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 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

Pide autentencación un sitio con Host Header

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:
  1. Click Start, click Run, type regedit, and then click OK.
  2. In Registry Editor, locate and then click the following registry key:

    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa

  3. Right-click Lsa, point to New, and then click DWORD Value.
  4. Type DisableLoopbackCheck, and then press ENTER.
  5. Right-click DisableLoopbackCheck, and then click Modify.
  6. In the Value data box, type 1, and then click OK.
  7. 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 your computer, follow these steps:
  1. Click Start, click Run, type regedit, and then click OK.
  2. In Registry Editor, locate and then click the following registry key:

    HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Lsa\MSV1_0

  3. Right-click MSV1_0, point to New, and then click Multi-String Value.
  4. Type BackConnectionHostNames, and then press ENTER.
  5. Right-click BackConnectionHostNames, and then click Modify.
  6. In the Value data box, type the host name or the host names for the sites that are on the local computer, and then click OK.
  7. Quit Registry Editor, and then restart the IISAdmin service

Slds

Eduardo Castro

Comunidad Windows  - Costa Rica

Configurar Analisis Services por HTTP

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

 

image

image image

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

image

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

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.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

SQL Server 2016 Stretch Databases

El SQL Server Stretch Database permite que los datos históricos o de bitácoras puedan ser movidos hacia Azure, específicamente permite mover...