Posts

Showing posts from September, 2007

Limpiar log de bd con mirroring

Estos comandos permiten limpar el log de una bd que tiene mirroring configurado



USE XXX
GO
CHECKPOINT
GO
BACKUP LOG [XXX] TO [XXX_TLOG] WITH NOFORMAT, INIT, NAME = N'XXX-Transaction Log Backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
GO
DBCC SHRINKFILE(XXX_Log, 1)
GO



Vea que se hace shink sobre el log no sobre la BD.

Error en IIS Could not create a Disk Cache Sub-directory

Cuando se presenta este error en IIS:

Error: The Template Persistent Cache initialization failed for Application Pool ‘DefaultAppPool’ because of the following error: Could not create a Disk Cache Sub-directory for the Application Pool. The data may have additional error codes..

Este error se presenta en Windows Server 2003 por falta de configuración de seguridad en Windows. Se tiene que dar permisos de full access a las cuentas IIS_WPG y Network Services, en seguridad de los siguientes directorios,

%systemroot%\System32\Inetsrv\ASP Compiled Templates
%systemroot%\IIS Temporary Compressed Files

Problemas de Virtual PC

This can happen if changes on one virtual computer are saved while changed on a different virtual computer are not saved, which causes the system account password to become unsynchronized. To disable system account password changes on London, add the RefusePasswordChange D_Word value of 1 in the Registry at HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Netlogon\Parameters. To prevent system account password change requests on Miami and Acapulco, set the DisablePasswordChange value to 1 at HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Netlogon\Parameters.

Microsoft IAG

IAG es una solución de seguridad de Microsoft para proveer acceso remoto basado en SSL, para más información ingresen a

http://www.microsoft.com/forefront/edgesecurity/iag/default.mspx

Microsoft's Intelligent Application Gateway (IAG) 2007 is the comprehensive, secure remote access gateway that provides secure socket layer (SSL)-based application access and protection with endpoint security management. Read the resources listed below to learn how IAG 2007 enables granular access control, authorization, and deep content inspection from a broad range of devices and locations to a wide variety of line-of-business, intranet, and client/server resources.

• Control Access
Secure, browser-based access to corporate applications and data from more locations and more devices.

• Protect Assets
Ensure the integrity and safety of network and application infrastructure by blocking malicious traffic and attacks.

• Safeguard Information
Comprehensive policy enforcement helps drive compliance with legal …

Fecha de expiracion desde VB.NET

Imports System.DirectoryServices
Imports System.Reflection

Public Shared Function PasswordExpiration() As DateTime


Dim user As DirectoryEntry
Dim root As DirectoryEntry
Dim rootDSE As DirectoryEntry


Dim defaultContext As String


Dim maxPwdVal As Object
Dim pwdLastSetVal As Object


Dim pwdLastSet As Int64
Dim pwdLastSetDate As DateTime
Dim pwdExpirationDate As DateTime
Dim maxPwd As TimeSpan


rootDSE = New DirectoryEntry("LDAP://RootDSE")


defaultContext = DirectCast(rootDSE.Properties("defaultNamingContext").Value, System.String)


'change this to point to the user you wish to check
user = New DirectoryEntry("LDAP://cn=pruebas,cn=Users," + defaultContext)
root = New DirectoryEntry("LDAP://" + defaultContext)


pwdLastSetVal = user.Properties("pwdLastSet").Value
maxPwdVal = root.Properties("maxPwdAge").Value


Obtener la fecha de expiracion de los passwords

Para obtener la fecha de expiracion de los password del usuario se puede utilizar el siguiente codigo.

'========================================
' First, get the domain policy.
'========================================
Dim oDomain As IADsContainer
Dim oUser As IADsUser
Dim maxPwdAge As LargeInteger

'========================================
' Declaring numDays as Currency, due to a
' large number calculation.
'========================================
Dim numDays As Currency

strDomainDN = "YOURDOMAIN"
strUserDN = strDomainDN & "/CN=John Doe,CN=Users,DC=YOURDOMAIN,DC=COM"

Set oDomain = GetObject("LDAP://" & strDomainDN)
Set maxPwdAge = oDomain.Get("maxPwdAge")

'========================================
' Calculate the number of days that are
' held in this value.
'========================================
numDays = ((maxPwdAge.HighPart * 2 ^ 3…