SQL Server

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.

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

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.

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

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

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