June 2009


Si se crea un KPI con MDX en un cubo de SQL Server, cuando dicha información se despliega en Performance Point Server 2007, en lugar del valor del KPI se muestra una etiqueta que dice ERROR para las columnas de value y goal tal y como se muestra en la siguiente figura:

image

PAra solucionarlo primero es recomendable instalar el SP2 de Performance Point, más detalles en http://office.microsoft.com/download/afile.aspx?AssetID=AM103381121033, además se debe verificar que el Application Pool del SharePoint y el application pool del Monitoring Server están configurados adecuadamente. Para más detalles consultar http://technet.microsoft.com/en-us/library/bb905547.aspx

 

Saludos,

Eduardo Castro – Microsoft SQL Server

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

Advertisements

Si desea configurar un servidor de SQL Server en 32 bits y desea que el sistema operativo reconozca 32GB de RAM, puede tomar en cuenta las siguientes consideraciones.

Si usted desea mantener el sistema operativo en 32 bits, entonces su opción es tener Windows 2003 Enterprise configurado con PAE. Consulte lo siguiente:

PAE Mode http://www.microsoft.com/whdc/system/platform/server/PAE/pae_os.mspx
PAE is the second method supported to access memory above 4 GB; this method has been widely implemented. PAE maps up to 64 GB of physical memory into a 32-bit (4 GB) virtual address space using either 4-KB or 2-MB pages. The Page directories and the page tables are extended to 8 byte formats, allowing the extension of the base addresses of page tables and page frames to 24 bits (from 20 bits). This is where the extra four bits are introduced to complete the 36-bit physical address.

Windows supports PAE with 4-KB pages. PAE also supports a mode where 2-MB pages are supported. Many of the UNIX operating systems rely on the 2 MB-page mode. The address translation is done without the use of page tables (the PDE supplies the page frame address directly).

Para configurar PAE en Windows 2003 puede consultar este artículo http://msdn.microsoft.com/en-us/library/ms791485.aspx

Este es un ejemplo de cómo configurar PAE en Windows 2003

Primer Boot.ini:

[boot loader]

timeout=0

default=multi(0)disk(0)rdisk(0)partition(1)\WINNT

[operating systems]

multi(0)disk(0)rdisk(0)partition(1)\WINNT=” Windows Server 2003, Enterprise” /fastdetect

Cambie el Boot.ini de la siguiente forma:

[boot loader]

timeout=0

default=multi(0)disk(0)rdisk(0)partition(1)\WINNT

[operating systems]

multi(0)disk(0)rdisk(0)partition(1)\WINNT=” Windows Server 2003, Enterprise” /fastdetect /PAE

Si lo desea realizar por medio del commando Bootcfg utilice lo siguiente:

bootcfg /raw "/pae" /A /ID 1

 

Saludos,

Eduardo Castro – Microsoft SQL Server

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

La herramienta ForeFront Client Security y Windows Live One Care, pasaron las pruebas de antivirus, pueden ver todo el reporte en http://www.icsalabs.com/icsa/topic.php?tid=d3a8$95695e0b-40700fe6$8dd1-8fc093ea

 

Saludos,

Eduardo Castro – Microsoft SQL Server

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

 

 

May 2009 Testing Report

Desktop/Server Monthly Detection (4.0)

Vendor Product OS Criteria Pass/Fail
+/- ALWIL Software Avast 4 Win XP Pro Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 4.8.1335 5/15/2009 5/15/2009 Passed
On-Demand Scan of Wild List 4.8.1335 5/15/2009 5/15/2009 Passed
+/- ALWIL Software Avast 4 Server Edition Win 2003 Server Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 4.8 5/13/2009 5/14/2009 Passed
On-Demand Scan of Wild List 4.8 5/13/2009 5/14/2009 Passed
+/- Authentium Command Antivirus for Windows Win XP Pro Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 4.95.2 5/13/2009 5/14/2009 Passed
On-Demand Scan of Wild List 4.95.2 5/13/2009 5/14/2009 Passed
+/- AVG Technologies AVG Antivirus Professional Edition Win XP Pro Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.5.336 5/14/2009 5/14/2009 Passed
On-Access Detection of Wild List 8.1.660 5/14/2009 5/14/2009 Failed
On-Demand Scan of Wild List 8.5.336 5/14/2009 5/14/2009 Passed
On-Demand Scan of Wild List 8.1.660 5/14/2009 5/14/2009 Failed
+/- AVG Technologies AVG File Server Edition Win 2000 Server Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.5.339 5/20/2009 5/20/2009 Passed
On-Demand Scan of Wild List 8.5.339 5/20/2009 5/20/2009 Passed
+/- AVG Technologies AVG File Server Edition Win 2003 Server Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.5.336 5/14/2009 5/14/2009 Passed
On-Demand Scan of Wild List 8.5.336 5/14/2009 5/14/2009 Passed
+/- AVG Technologies AVG Professional Vista 32-bit Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.5.339 5/18/2009 5/18/2009 Passed
On-Demand Scan of Wild List 8.5.339 5/18/2009 5/18/2009 Passed
+/- AVG Technologies AVG Professional Vista 64-bit Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.5.339 5/18/2009 5/18/2009 Passed
On-Demand Scan of Wild List 8.5.339 5/18/2009 5/18/2009 Passed
+/- Avira GmbH AntiVir Windows Workstation Linux Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 2.1.12-161 5/14/2009 5/18/2009 Passed
On-Demand Scan of Wild List 2.1.12-161 5/14/209 5/18/2009 Passed
+/- BitDefender SRL BitDefender Antivirus Vista 32-bit Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 12.0.12 5/11/2009 5/11/2009 Passed
On-Demand Scan of Wild List 12.0.12 5/11/2009 5/11/2009 Passed
+/- BullGuard Ltd. BullGuard Win 2000 Pro Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 7.25481 5/18/2009 5/20/2009 Passed
On-Demand Scan of Wild List 7.25481 5/18/2009 5/20/2009 Passed
+/- BullGuard Ltd. Bullguard Internet Security Vista 32-bit Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.1.637.0 5/12/2009 5/12/2009 Passed
On-Access Detection of Wild List 8.1.637.0 5/12/2009 5/12/2009 Failed
On-Demand Scan of Wild List 8.1.637.0 5/12/2009 5/12/2009 Passed
On-Demand Scan of Wild List 8.1.637.0 5/12/2009 5/12/2009 Failed
+/- BullGuard Ltd. Bullguard Internet Security Vista 64-bit Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.1.637.0 5/12/2009 5/12/2009 Passed
On-Demand Scan of Wild List 8.1.637.0 5/12/2009 5/12/2009 Passed
+/- CA, Inc. CA Anti-Virus Vista 32-bit Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 9.0.0.17 5/26/2009 5/11/2009 Passed
On-Access Detection of Wild List 9.0.0.174 5/8/2009 5/11/2009 Failed
On-Demand Scan of Wild List 9.0.0.174 5/26/2009 5/11/2009 Passed
On-Demand Scan of Wild List 9.0.0.174 5/8/2009 5/11/2009 Failed
+/- CA, Inc. CA Anti-Virus Win XP Home Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 9.0.0.175 5/26/2009 5/15/2009 Passed
On-Access Detection of Wild List 9.0.0.174 5/15/2009 5/15/2009 Failed
On-Demand Scan of Wild List 9.0.0.174 5/15/2009 5/15/2009 Passed
+/- CA, Inc. CA Anti-Virus for the Enterprise Linux Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 7.1.2885 5/27/2009 5/27/2009 Passed
On-Access Detection of Wild List 7.1.2885 5/16/2009 5/18/2009 Failed
On-Demand Scan of Wild List 7.1.2885 5/27/2009 5/27/2009 Passed
On-Demand Scan of Wild List 7.1.2885 5/16/2009 5/18/2009 Failed
+/- CA, Inc. CA Anti-Virus for the Enterprise Win 2000 Pro Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.1.660.0 5/26/2009 5/26/2009 Passed
On-Demand Scan of Wild List 8.1.660.0 5/26/2009 5/26/2009 Passed
+/- CA, Inc. CA Anti-Virus for the Enterprise Win 2000 Server Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.1.660.0 5/26/2009 5/15/2009 Passed
On-Access Detection of Wild List 8.1.660.0 5/15/2009 5/15/2009 Failed
On-Demand Scan of Wild List 8.1.660.0 5/26/2009 5/15/2009 Passed
On-Demand Scan of Wild List 8.1.660.0 5/15/2009 5/15/2009 Failed
+/- CA, Inc. CA Anti-Virus for the Enterprise Win 2003 Server Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.1.660.0 5/26/2009 5/26/2009 Passed
On-Demand Scan of Wild List 8.1.660.0 5/26/2009 5/26/2009 Passed
+/- CA, Inc. CA Anti-Virus for the Enterprise Win XP Pro Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.1.660 5/22/2009 5/15/2009 Passed
On-Access Detection of Wild List 8.1.660 5/14/2009 5/15/2009 Failed
On-Demand Scan of Wild List 8.1.660 5/22/2009 5/15/2009 Passed
On-Demand Scan of Wild List 8.1.660 5/14/2009 5/15/2009 Failed
+/- ESET, LLC ESET NOD32 Antivirus Vista 64-bit Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 3.0.672.0 5/18/2009 5/18/2009 Passed
On-Demand Scan of Wild List 3.0.672.0 5/18/2009 5/18/2009 Passed
+/- ESET, LLC ESET NOD32 Antivirus Win XP Pro Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 3.0.667.0 5/15/2009 5/15/2009 Passed
On-Demand Scan of Wild List 3.0.667.0 5/15/2009 5/15/2009 Passed
+/- F-Secure Corporation F-Secure AntiVirus Internet Security Vista 32-bit Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.0 build 101 5/11/2009 5/11/2009 Passed
On-Demand Scan of Wild List 8.0 build 101 5/11/2009 5/11/2009 Passed
+/- F-Secure Corporation F-Secure AntiVirus Internet Security Win XP Pro Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.10 build 14240 5/15/2009 5/15/2009 Passed
On-Demand Scan of Wild List 8.10 build 14240 5/15/2009 5/15/2009 Passed
+/- IBM Internet Security Systems Proventia Desktop Endpoint Security Win XP Pro Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 9.0.226.2270 5/14/2009 5/14/2009 Passed
On-Demand Scan of Wild List 9.0.226.2270 5/14/2009 5/14/2009 Passed
+/- Kaspersky Lab ZAO Kaspersky Internet Security Vista 32-bit Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.0.0.357 5/12/2009 5/13/2009 Passed
On-Demand Scan of Wild List 8.0.0.357 5/12/2009 5/13/2009 Passed
+/- Kaspersky Lab ZAO Kaspersky Internet Security Win XP Pro Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.0.0.506 5/18/2009 5/18/2009 Passed
On-Demand Scan of Wild List 8.0.0.506 5/18/2009 5/18/2009 Passed
+/- McAfee, Inc. VirusScan Win XP Home Desktop/Server Monthly Detection Fail
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 13.3.127 5/20/2009 5/20/2009 Failed
On-Demand Scan of Wild List 13.3.127 5/20/2009 5/20/2009 Failed
+/- McAfee, Inc. VirusScan Enterprise Vista 32-bit Desktop/Server Monthly Detection Fail
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.7.0i 5/11/2009 5/12/2009 Failed
On-Access Detection of Wild List 8.5.0i 5/11/2009 5/12/2009 Failed
On-Demand Scan of Wild List 8.7.0i 5/18/2009 5/18/2009 Failed
+/- McAfee, Inc. VirusScan Enterprise Vista 64-bit Desktop/Server Monthly Detection Fail
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.7.0i 5/18/2009 5/18/2009 Failed
On-Demand Scan of Wild List 8.7.0i 5/18/2009 5/18/2009 Failed
+/- McAfee, Inc. VirusScan Enterprise Win 2003 Server Desktop/Server Monthly Detection Fail
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.7.0 5/13/2009 5/14/2009 Failed
On-Demand Scan of Wild List 8.7.0 5/13/2009 5/14/2009 Failed
+/- McAfee, Inc. VirusScan Enterprise Win XP Pro Desktop/Server Monthly Detection Fail
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.7.0i 5/26/2009 5/27/2009 Failed
On-Demand Scan of Wild List 8.7.0i 5/26/2009 5/27/2009 Failed
+/- Microsoft Corporation Microsoft ForeFront Client Security Vista 32-bit Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 1.5.1958.0 5/10/2009 5/11/2009 Passed
On-Access Detection of Wild List 1.5.1958.0 5/10/2009 5/11/2009 Failed
On-Demand Scan of Wild List 1.5.1958.0 5/10/2009 5/11/2009 Passed
On-Demand Scan of Wild List 1.5.1958.0 5/10/2009 5/11/2009 Failed
+/- Microsoft Corporation Microsoft ForeFront Client Security Win 2000 Pro Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 1.5.1958.0 1.57.1651.0 5/20/2009 Passed
On-Demand Scan of Wild List 1.5.1958.0 1.57.1651.0 5/20/2009 Passed
+/- Microsoft Corporation Microsoft ForeFront Client Security Win 2003 Server Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 1.5.1958.0 1.57.1329.0 5/14/2009 Passed
On-Demand Scan of Wild List 1.5.1958.0 1.57.1329.0 5/14/2009 Passed
+/- Microsoft Corporation Microsoft ForeFront Client Security Win XP Pro Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 1.5.1955.0 5/19/2009 5/19/2009 Passed
On-Demand Scan of Wild List 1.5.1955.0 5/19/2009 5/19/2009 Passed
+/- Microsoft Corporation Windows Live OneCare Vista 64-bit Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 2.5.2900.24 5/12/2009 5/13/2009 Passed
On-Demand Scan of Wild List 2.5.2900.20 5/18/2009 5/19/2009 Passed
+/- Norman Norman Virus Control Win 2003 Server Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 5.99 6/3/2009 6/8/2009 Passed
On-Access Detection of Wild List 5.99 6/1/2009 6/1/2009 Failed
On-Access Detection of Wild List 5.99 6/1/2009 5/26/2009 Failed
On-Access Detection of Wild List 5.99 5/26/2009 5/26/2009 Failed
On-Demand Scan of Wild List 5.99 6/3/2009 6/8/2009 Passed
On-Demand Scan of Wild List 5.99 6/1/2009 6/1/2009 Failed
On-Demand Scan of Wild List 5.99 5/26/2009 5/26/2009 Failed
+/- Panda Security Panda AntiVirus Pro 2009 Win XP Pro Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.00.00 5/19/2009 5/20/2009 Passed
On-Access Detection of Wild List 8.00.00 5/19/2009 5/20/2009 Failed
On-Demand Scan of Wild List 8.00.00 5/19/2009 5/20/2009 Passed
On-Demand Scan of Wild List 8.00.00 5/19/2009 5/20/2009 Failed
+/- Panda Security Panda for Desktops Win XP Pro Desktop/Server Monthly Detection Fail
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 4.02.32 5/14/2009 5/15/2009 Failed
On-Demand Scan of Wild List 4.02.32 5/14/2009 5/15/2009 Failed
+/- Panda Security Panda for FileServers Win 2003 Server Desktop/Server Monthly Detection Fail
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 8.02.32 5/14/2009 5/14/2009 Failed
On-Demand Scan of Wild List 8.02.32 5/14/2009 5/14/2009 Failed
+/- Panda Security Panda Internet Security 2009 Win XP Pro Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 14.00.00 5/13/2009 5/13/2009 Passed
On-Demand Scan of Wild List 14.00.00 5/13/2009 5/13/2009 Passed
+/- PC TOOLS PC Tools Antivirus Win XP Pro Desktop/Server Monthly Detection Fail
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 6.0.0.19 6/2/2009 6/2/2009 Failed
On-Access Detection of Wild List 6.0.0.19 5/15/2009 5/15/2009 Failed
On-Access Detection of Wild List 6.0.0.19 5/15/2009 5/15/2009 Failed
On-Demand Scan of Wild List 6.0.0.19 6/2/2009 6/2/2009 Failed
On-Demand Scan of Wild List 6.0.0.19 5/15/2009 5/15/2009 Failed
On-Demand Scan of Wild List 6.0.0.19 5/15/2009 5/15/2009 Failed
+/- Radialpoint Radialpoint Internet Security Suite v.6.0 Win XP Home Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 6.0.4.27425 5/19/2009 5/20/2009 Passed
On-Demand Scan of Wild List 6.0.4.27425 5/19/2009 5/20/2009 Passed
+/- Radialpoint RadialPoint Internet Security Suite v.7.0 Vista 32-bit Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 7.0.22.31377 5/12/2009 5/13/2009 Passed
On-Demand Scan of Wild List 7.0.22.31377 5/12/2009 5/13/2009 Passed
+/- Symantec Corporation Norton Antivirus Win XP Pro Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 16.5.0.134 5/14/2009 5/14/2009 Passed
On-Demand Scan of Wild List 16.5.0.134 5/14/2009 5/14/2009 Passed
+/- Symantec Corporation Norton Antivirus 2009 Vista 64-bit Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 16.5.0.134 5/12/2009 5/13/2009 Passed
On-Demand Scan of Wild List 16.5.0.134 5/12/2009 5/13/2009 Passed
+/- Symantec Corporation Symantec Endpoint Protection Vista 32-bit Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 11.0.780.1109 5/19/2009 6/12/2009 Passed
On-Demand Scan of Wild List 11.0.780.1109 5/19/2009 6/12/2009 Passed
+/- Symantec Corporation Symantec Endpoint Protection Win 2003 Server Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 11.0.780.1109 5/14/2009 5/15/2009 Passed
On-Demand Scan of Wild List 11.0.780.1109 5/14/2009 5/15/2009 Passed
+/- Symantec Corporation Symantec Endpoint Protection Win XP Pro Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 11.0.780.1109 5/19/2009 5/21/2009 Passed
On-Demand Scan of Wild List 11.0.780.1109 5/19/2009 5/21/2009 Passed
+/- VirusBuster VirusBuster Win XP Pro Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 5.3.157 6/10/2009 6/11/2009 Passed
On-Access Detection of Wild List 5.3.157 6/4/2009 6/4/2009 Failed
On-Access Detection of Wild List 5.3.157 5/19/2009 5/20/2009 Failed
On-Demand Scan of Wild List 5.3.157 6/10/2009 6/11/2009 Passed
On-Demand Scan of Wild List 5.3.157 6/4/2009 6/4/2009 Failed
On-Demand Scan of Wild List 5.3.157 5/19/2009 5/20/2009 Failed
+/- Webroot Software, Inc. Webroot AntiVirus (WAV) Win XP Home Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 6.1.0 Build 128 6/8/2009 6/8/2009 Passed
On-Access Detection of Wild List 6.0.2.39 6/2/2009 6/3/2009 Failed
On-Access Detection of Wild List 6.0.2.39 5/19/2009 5/20/2009 Failed
On-Demand Scan of Wild List 6.1.0 Build 128 6/8/2009 6/8/2009 Passed
On-Demand Scan of Wild List 6.0.2.39 6/2/2009 6/3/2009 Failed
On-Demand Scan of Wild List 6.0.2.39 5/19/2009 5/20/2009 Failed
+/- Webroot Software, Inc. Webroot Internet Security Essentials (WISE) Win XP Pro Desktop/Server Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of Wild List 6.1.0 Build 128 6/8/2009 6/8/2009 Passed
On-Access Detection of Wild List 6.1.0 Build 128 6/3/2009 6/3/2009 Failed
On-Access Detection of Wild List 6.1.0 Build 128 5/26/2009 5/26/2009 Failed
On-Access Detection of Wild List 6.1.0 Build 128 5/26/2009 5/26/2009 Failed
On-Demand Scan of Wild List 6.1.0 Build 128 6/8/2009 6/8/2009 Passed
On-Demand Scan of Wild List 6.1.0 Build 128 6/3/2009 6/3/2009 Failed
On-Demand Scan of Wild List 6.1.0 Build 128 5/26/2009 5/27/2009 Failed

ECM (4.0)

Vendor Product OS Criteria Pass/Fail
+/- Microsoft Corporation Microsoft ForeFront Security for SharePoint Windows Server 2003 ECM Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of the ECM Test Set 10.1.0802.0 05/21/2009 5/21/2009 Passed
On-Demand Detection of the ECM Test Set 10.1.0802.0 05/21/2009 5/21/2009 Passed
On-Demand Detection of the ECM Test Set 10.1.0802.0 05/21/2009 5/21/2009 Passed
+/- Microsoft Corporation Microsoft ForeFront Security for SharePoint Windows Server 2008 ECM Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of the ECM Test Set 10.1.0802.0 05/20/2009 5/20/2009 Passed
On-Demand Detection of the ECM Test Set 10.1.0802.0 05/20/2009 5/20/2009 Passed

Gateway Monthly Detection (4.0)

Vendor Product OS Criteria Pass/Fail
+/- Anchiva Systems, Inc. Anchiva 206 Appliance Gateway Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
Mail On-Access 206 5/13/2009 5/13/2009 Passed
Mail On-Access 206 5/13/2009 5/13/2009 Failed
+/- Fortinet, Inc. Fortigate Appliance Gateway Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
Mail On-Access 3600 05/26/2009 5/12/2009 Passed
Mail On-Access 3600 05/12/2009 5/12/2009 Failed
+/- Secure Computing Corporation Webwasher Linux Gateway Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
Mail On-Access 6.7.1 build 3376 06/02/2009 5/14/2009 Passed
Mail On-Access 6.7.1 build 3376 05/14/2009 5/14/2009 Failed

Groupware Monthly Detection (4.0)

Vendor Product OS Criteria Pass/Fail
+/- GFI Software LTD MailSecurity Microsoft Exchange 2000 Groupware Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of the Mail Test Set 10.0 Build 20060721 05/14/2009 5/14/2009 Passed
+/- McAfee, Inc. Groupshield Lotus Domino Groupware Monthly Detection Fail
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of the Mail Test Set 5.3 05/14/2009 5/14/2009 Failed
+/- McAfee, Inc. Groupshield Microsoft Exchange 2000 Groupware Monthly Detection Fail
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of the Mail Test Set 6.0.616.102 05/13/2009 5/14/2009 Failed
+/- Microsoft Corporation Microsoft ForeFront Security for Exchange Server Exchange 2007 on Windows Server 2003 Groupware Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of the Mail Test Set 10.0.0566.0 05/18/2009 5/18/2009 Passed
+/- Microsoft Corporation Microsoft ForeFront Security for Exchange Server Exchange 2007 on Windows Server 2008 Groupware Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of the Mail Test Set 10.1.0746.0 05/21/2009 5/21/2009 Passed
+/- Symantec Corporation Mail Security Lotus Domino Groupware Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of the Mail Test Set 7.5.0.19 05/13/2009 5/14/2009 Passed
+/- Symantec Corporation Mail Security Microsoft Exchange Groupware Monthly Detection Pass
Test Details:

Test Version Signature Test Date Pass/Fail
On-Access Detection of the Mail Test Set 5.0.3.360 05/14/2009 5/14/2009 Passed

HP ha publicado una guía sobre recomendaciones para realizar consolidación de servidores SQL Server, los escenarios cubiertos en esa guía son los siguientes:

  • Consolidar múltiples bases de datos dentro un único servidor
  • Consolidar varias instancias de SQL Server en menos servidores físicos
  • Consolidar SQL Server por medio de la virtualización

La guía la pueden bajar de la siguiente dirección

http://windowsitpro.com/essential/index.cfm?fuseaction=show&guid=4a8c98eb-a186-49b1-ab69-cf52f0307c2b&code=EPDedHPBladesEG01_062209

Download Now

 

Saludos,

Eduardo Castro – Microsoft SQL Server

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

En esta dirección http://www.jumpstarttv.com/ podrán encontrar una serie de videos para aprender sobre SQL Server.

SQL Server Authentication Modes  

SQL Server Authentication Modes

Date Featured: June 18, 2009

Author: Brian Kelley

Length: 3 Minutes 27 Seconds

Rating: 3.91

Description: Do you know your options for logging in (authenticating) to a SQL Server? Brian discusses the options and in later videos dig…

Using the File System Task in SSIS   

Using the File System Task in SSIS

Date Featured: December 01, 2008

Author: Brian Knight

Length: 4 Minutes 6 Seconds

Rating: 4.30

Description: This video by MVP Brian Knight shows you how to use a File System Task in SSIS to rename, move or delete a file.

 

Saludos,

Eduardo Castro – Microsoft SQL Server

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

Cuando se tiene SQL Server 2008 con SP1 y se trata de instalar TFS 2008 con SP1 el instador falla la verificación para corregirlo se deben seguir los pasos que se indican en el siguente artículo:

http://support.microsoft.com/kb/969985

 

  1. Download Microsoft Visual Studio 2008 Team Foundation Server Service Pack 1 from the following Microsoft Web site:

    http://www.microsoft.com/downloads/details.aspx?FamilyId=9E40A5B6-DA41-43A2-A06D-3CEE196BFE3D (http://www.microsoft.com/downloads/details.aspx?FamilyId=9E40A5B6-DA41-43A2-A06D-3CEE196BFE3D)

  2. Download the Team Foundation Installation Guide for Microsoft Visual Studio Team System 2008 from the following Microsoft Web site:

    http://www.microsoft.com/downloads/details.aspx?FamilyID=FF12844F-398C-4FE9-8B0D-9E84181D9923&displaylang=en (http://www.microsoft.com/downloads/details.aspx?FamilyID=FF12844F-398C-4FE9-8B0D-9E84181D9923&displaylang=en)

  3. In the Installation Guide that you downloaded in step 2, follow the first five steps that are described in the "How to: Integrate the Installation of Team Foundation Server and Service Pack 1" topic.
    Note To find this topic, expand Installing Team Foundation Server and Service Pack 1 in the left pane of the Installation Guide.
  4. Open the C:\MergeFolder folder that you created in step 4 of the "How to: Integrate the Installation of Team Foundation Server and Service Pack 1" topic.
  5. Open the Hcpackage.xml file by using Notepad.
  6. Find the following entry:

    <WQL namespace="\\.\root\Microsoft\SqlServer\ComputerManagement10" query="SELECT * FROM sqlserviceadvancedproperty WHERE ServiceName='[%VSTF_SERVICENAME_MSSQL%]’ AND PropertyName=’VERSION’ AND PropertyStrValue&gt;=’10.00.1433′ AND PropertyStrValue LIKE ‘10.00.%’" action="=" count="0" />

  7. Replace the entry that you found in step 6 with the following entry:

    <WQL namespace="\\.\root\Microsoft\SqlServer\ComputerManagement10" query="SELECT * FROM sqlserviceadvancedproperty WHERE ServiceName='[%VSTF_SERVICENAME_MSSQL%]’ AND PropertyName=’VERSION’ AND PropertyStrValue&gt;=’10.00.1433′ AND PropertyStrValue LIKE ’10.%’" action="=" count="0" />

  8. Find the following entry:

    <WQL namespace="\\.\root\Microsoft\SqlServer\ComputerManagement10" query="SELECT * FROM sqlserviceadvancedproperty WHERE ServiceName='[%VSTF_SERVICENAME_MSSQL%]’ AND PropertyName=’VERSION’ AND PropertyStrValue&gt;=’10.0.1433′ AND PropertyStrValue LIKE ‘10.0.%’" action="=" count="0" />

  9. Replace the entry that you found in step 8 with the following entry:

    <WQL namespace="\\.\root\Microsoft\SqlServer\ComputerManagement10" query="SELECT * FROM sqlserviceadvancedproperty WHERE ServiceName='[%VSTF_SERVICENAME_MSSQL%]’ AND PropertyName=’VERSION’ AND PropertyStrValue&gt;=’10.0.1433′ AND PropertyStrValue LIKE ’10.%’" action="=" count="0" />

  10. Find the following entry:

    <MsiProductVersionCheck prodid="[%SQLServer2008%]" action="&lt;" version="10.1" />

  11. Replace the entry that you found in step 10 with the following entry:

    <MsiProductVersionCheck prodid="[%SQLServer2008%]" action="&lt;" version="10.2" />

  12. Save the Hcpackage.xml file.
  13. Run Setup.exe to install Visual Studio 2008 Team Foundation Server with SP1.

 

Saludos,

Eduardo Castro – Microsoft SQL Server

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

 

Para utilizar SQL 2008 con TFS 2008 debes primero aplicar el SP1 de TFS al instalador, primero tienes que bajar el SP1 desde la siguiente dirección

Download details- Visual Studio 2008 Team Foundation Server SP1

Después tienes que aplicar el SP1 al instalador de TFS 2008

  1. Copie el directorio del DVD del instalador al disco duro local
  2. Extraiga el a un directorio local con el comando  TFS90sp1-KB949786.exe /extract:<Destino del Sp1>
  3. Ejecute el siguiente comando para aplicar el Sp1 al instalador  msiexec /a <Directorio del AT>\vs_setup.msi /p <Directorio del SP1>\ TFS90sp1-KB949786.msp TARGETDIR=<Directorio del AT>
  4. Ahora ya tiene integrado el Sp1 con TFS 2008

Más información en

http://blogs.msdn.com/aabdou/archive/2008/05/13/team-foundation-server-sp1-beta-now-available.aspx

Saludos,

Eduardo Castro – Microsoft SQL Server

http://comunidadwindows.org

Costa Rica

Technorati Tags: SQL Server

LiveJournal Tags: SQL Server

del.icio.us Tags: SQL Server

Next Page »