Tag: SQL

RSA Authentication manager 7.1 Bug

RSA Authentication manager 7.1 has a nasty bug in it that I ran into recently. When running RSA Authentication Manager 7.1 on Windows it creates 1 or 2 .sql file every minute containing SQL Statements. They build up very quickly and are not removed by RSA by default. In time this could lead into serious issues like i.e. one or more of the RSA services might not be able to (re)start anymore!

clip_image001workarround until that time:
Short term solution:

· reboot the machine in safe mode

· rename the c:\windows\temp to c:\windows\temp_old

· create a fresh new c:\windows\temp

· reboot in normal mode

Long term solution:

· create a standard plain text cmd file named, for example, ‘cleanup.cmd’, and add to it the following lines: del c:/windows/temp/dbmgmt*.sql

· save the file

· launch windows scheduler and have the cmd file run once a day

You might also decide to apply 7.1 SP4. In SP4 the bug is Solved.

Windows Anti-Virus Exclusion List

 

One place on the web where you can find an updated list of ALL the AV exclusions you might want to configure for Windows Server.

Enterprise Configuration Recommendations:

Windows:

  • KB822158 Virus scanning recommendations for Enterprise computers that are running currently supported versions of Windows

Windows / Active Directory:

Cluster:

Forefront: Considerations when using antivirus software on FF Edge Products

FRS:

SQL:

IIS:

DHCP:

SCOM / MOM:

Config Manager 2007:

Hyper-V:

Exchange:

SharePoint:

SMS:

ISA:

Windows Update:

SBS:

MED-V

System Center:

Data Protection Manager:

App-V

Source: http://social.technet.microsoft.com/wiki/contents/articles/953.aspx

Data Protection Manager 2010 error ID 30140 Details: Internal error code: 0x80990D11

I get the following error in DPM Management console on a SQL2000 server that is protected with DPM 2010

Affected area:           

Occurred since:          8/20/2011 4:01:13 AM

Description:    Recovery point creation jobs for SQL Server 2000 database ?????? on ???? have been failing. The number of failed recovery point creation jobs = 3.

If the datasource protected is SharePoint, then click on the Error Details to view the list of databases for which recovery point creation failed. (ID 3114)

DPM tried to do a SQL log backup, either as part of a backup job or a recovery to latest point in time job. The SQL log backup job has detected a discontinuity in the SQL log chain for  SQL Server 2000 database ???? since the last backup. All incremental backup jobs will fail until an express full backup runs. (ID 30140 Details: Internal error code: 0x80990D11)

More information

Recommended action:           If you see this failure as part of a backup job, then in the Protection task area, select the SQL Server database and click Create recovery point. Choose express full backup. Alternately, you can wait for the next scheduled express full backup to run.

If this failure occurs as part of a recovery job, then try to recover from another point in time.

Review the Application Event Viewer logs on the computer running SQL Server for more details.

Ensure that this database is not already protected by another backup application.

Create a recovery point…

Resolution:     To dismiss the alert, click below

Inactivate alert

Solution:

DPM tried to do a SQL log backup, either as part of a backup job or a recovery to latest point in time job. The SQL log backup job has detected a discontinuity in the SQL log chain for SQL Server 2005 database database <name database> since the last backup. All incremental backup jobs will fail until an express full backup runs. (ID 30140 Details: Internal error code: 0x80990D11)

Resolution: It seemed that the problem was that there were also backups performed straight from the SQL Management Studio. Stopping these backups resolved the issue. See also http://support.microsoft.com/kb/970642

System Center Operations Manager 2012 Beta is released

Overview

System Center Operations Manager 2012 provides the monitoring component of cloud and datacenter solutions, to help you manage your datacenter and cloud environments by:

  • Delivering flexible and cost effective enterprise-class monitoring and diagnostics while reducing the total cost of ownership by leveraging commodity hardware, with standard configurations to monitor heterogeneous environments.
  • Helping to ensure the availability of business-critical applications and services through market-leading .NET application performance monitoring and diagnostics plus JEE application health monitoring.
  • Providing a comprehensive view of datacenters, and private and public clouds.

Feature Summary

  • Predictable performance and availability of critical applications
    • End-to-end views of application health and topology
    • Establishment of application service-level delivery (SLAs)
    • Precise identification of application errors
  • Flexible and cost-effective infrastructure monitoring
    • In-depth monitoring, diagnostics, and reporting for heterogeneous environments
    • Integrated network device monitoring and alerts
    • Simplified management infrastructure
  • Comprehensive monitoring for your datacenter and cloud—on your terms
    • Integrated physical, virtual, and cloud management
    • Common console across datacenter and clouds
    • Rich reporting

System requirements

Supported Operating Systems: Windows 7, Windows Server 2003 Service Pack 2, Windows Server 2008 R2, Windows Server 2008 Service Pack 2, Windows Vista Service Pack 2, Windows XP Service Pack 3

  • Other Software:
    • Any server role
      • .NET 3.5 or 4.0
    • Management Server, Reporting Server, Web Console, Gateway Server
      • Windows Server 2008 R2 (64 bit)
    • Operational & Data Warehouse
      • SQL 2008 SP1 and above
      • SQL Collation – SQL_Latin1_General_CP1_CI_AS
    • Agent
      • Windows Server 2003 SP2 and above
      • Windows Server 2008 SP2 and above
      • Windows Server 2008 R2
      • Windows XP Professional SP3 and above
      • Windows Vista SP2 and above
      • Windows 7

    Supported Hardware Configuration:

    • Operations Manager Operations database: 4 GB of RAM or higher, 50 GB of available hard disk space
    • Management server: 2 GB of RAM or more, 20 GB of available hard disk space
    • Operations console: 2 GB of RAM or more, 20 GB of available hard disk space
    • Reporting data warehouse: 4 GB of RAM or more, 100 GB of available hard disk space
    • Reporting server: 2 GB or more, 20 GB of available hard disk space
    • gateway server: 2 GB of RAM or more, 20 GB of available hard disk space
    • Web console server: 2 GB of RAM or more, 20 GB of available hard disk space
    • Audit database: 4 GB of RAM or more, 100 GB of available hard disk space
    • Management server with audit collector: 2 GB of RAM or more, 50 GB of available hard disk space
    • Management server with Agentless Exception Monitoring file share: 2 GB of RAM or more, 30 GB of available hard disk space
    • Agent: Please refer to the recommended hardware requirement required by the operating system.

Download the beta HERE

Microsoft Assessment and Planning (MAP) 6.0 Beta: Accelerate the adoption of Microsoft private and public cloud platforms

Planning your journey to the cloud just got a bit easier. The next release of the Microsoft Assessment and Planning (MAP) Toolkit—version 6.0 Beta—includes assessment capabilities to evaluate workloads for both public and private cloud platforms. With MAP 6.0 Beta, you now have the ability to identify workloads and estimate the infrastructure size and resources needed for both Windows Azure and Hyper-V Fast Track. Also new to MAP 6.0 Beta is the Office 365 client assessment, enhanced VMware inventory, and Oracle schema discovery and reporting. Expanded assessment and discovery capabilities from MAP help you streamline planning for your next migration project. Plan what’s next with MAP.

New features and benefits from MAP 6.0 Beta release help you:

· Analyze your portfolio of applications for a move to the Windows Azure Platform

· Accelerate planning to private cloud with Hyper-V Cloud Fast Track onboarding

· Identify migration opportunities with enhanced heterogeneous server environment inventory

· Assess your client environment for Office 365 readiness

· Determine readiness for migration to Windows Internet Explorer 9

· Discover Oracle database schemas for migration to SQL Server

Download the beta materials on Connect:http://go.microsoft.com/fwlink/?LinkId=219165

System Center Data Protection Manager 2010 Doesn’t Detect Tape Drives In Library

I’ve used System Center Data Protection Manager (DPM) since the 2007 beta, primarily for SharePoint and SQL backups & Exchange Backups.  At a customer they have one  DPM server which backs up to disk and additionally to a HP MSL2024 Tape Library for long term protection. The runs Windows Server 2008 R2 with DPM 2010 since its release.

After updating de DPM Server with SP1 for Windows 2008 R2 en updated the drivers. I had some issues with DPM. What I found was that although DPM installed correctly it couldn’t see  all the tape drives in the VTL. All the tape drives were visible in Device Manager and none were showing errors. I use the RECOMMENDED * HP StorageWorks Tape Drivers for Windows

In the DPM console under Management -> Libraries, the library was listed, but Total Drives was 0, rather than the expected 2. The DPM console showed the following error:

image

I followed the instructions to remap the drives here: http://technet.microsoft.com/en-us/library/bb795782.aspx. The DPMLA.xml file produced by the tool was correct, showing the correct SCSI IDs, serial numbers etc. but DPM still couldn’t see the drives.

I found the solution to the problem on the DPM forum here: http://social.technet.microsoft.com/Forums/en-US/dpmtapebackuprecovery/thread/1d599443-7bf6-437a-bf12-52847fa7c8e5/ What I did is update the tape drive driver to the Inbox LTO driver as described on the forum and below:

1) Open device manager
2) Locate the tape drive
3) Right-click and look at the properties.
3) Under the DRIVER tab, select UPDATE DRIVER
a) Select the Install from list or specific location (Advanvced) – next.
b) Select Don’t search. I will choose the driver to install. – next.
c) Uncheck the Show comtabile hardware checkbox.
d) Highlight LTO under the manufacturer.
e) Highlight the LTO tape drive under model – then next.
f) This should install the Microsoft ltotape.sys driver.
4) Rescan the tape library in the DPM console – try to take another backup.

After following the above steps, all the two tape drives were visible in the DPM console.

System Center Virtual Machine Manager 2012 Beta Evaluation

System Center Virtual Machine Manager 2012 delivers industry leading fabric managment, virtual machine management and services deployment in private cloud environments. Virtual Machine Manager 2012 offers key new features that include hypervisor creation and management, network management, storage management, private cloud creation, self-service usage and service creation. It features deep investments in server application virtualization, service design and service modeling all of which can be used to efficiently offer an on-premises private cloud.

Feature Summary

  • Fabric Management
    • Hyper-V and Cluster Lifecycle Management – Deploy Hyper-V to bare metal server, create Hyper-V clusters, orchestrate patching of a Hyper-V Cluster
    • Third Party Virtualization Platforms – Add and Manage Citrix XenServer and VMware ESX Hosts and Clusters
    • Network Management – Manage IP Address Pools, MAC Address Pools and Load Balancers
    • Storage Management – Classify storage, Manage Storage Pools and LUNs
  • Resource Optimization
    • Dynamic Optimization – proactively balance the load of VMs across a cluster
    • Power Optimization – schedule power savings to use the right number of hosts to run your workloads – power the rest off until they are needed
    • PRO – integrate with System Center Operations Manager to respond to application-level performance monitors
  • Cloud Management
    • Abstract server, network and storage resources into private clouds
    • Delegate access to private clouds with control of capacity, capabilities and user quotas
    • Enable self-service usage for application administrator to author, deploy, manage and decommission applications in the private cloud
  • Service Lifecycle Management
    • Define service templates to create sets of connected virtual machines, os images and applica tion packages
    • Compose operating system images and applications during service deployment
    • Scale out the number of virtual machines in a service
    • Service performance and health monitoring integrated with System Center Operations Manager
    • Decouple OS image and application updates through image-based servicing
    • Leverage powerful application virtualization technologies such as Server App-V

System Requirements

  • Supported Operating Systems:Windows 7 Enterprise;Windows 7 Professional;Windows 7 Ultimate;Windows Server 2008 R2;Windows Server 2008 R2 Datacenter;Windows Server 2008 R2 Enterprise
    • Windows Server 2008 R2 (full installation) Standard, Enterprise, Datacenter x64
    • Windows 7 Professional, Enterprise, Ultimate x32, x64
    • Windows Remote Management (WinRM) 2.0
    • Windows PowerShell 2.0
    • Microsoft .NET Framework 3.5 Service Pack 1 (SP1)
    • Windows Automated Installation Kit (AIK) for Windows 7
    • SQL Server 2008 or SQL Server 2008 R2 Standard, Enterprise, and Datacenter
    • Windows Deployment Services (WDS) – (Version on Windows Server 2008 R2)
    • Windows Software Update Services (WSUS) 3.0 SP2 64bit

Download System Center Virtual Machine Manager 2012 Beta Evaluation HERE

Group Policy Preferences Data Sources Failed with error 0x80070057

clip_image002
Group Policy Data Sources is voltooid.

Aanvullende gegevens:

Het voorkeursitem computer ‘Nordined’ in het groepsbeleidsobject ‘De naam van de policy {54A928D5-EAA8-421B-9F12-066B350B6671}’ is niet toegepast, omdat het is mislukt met foutcode ‘0x80070057 De parameter is onjuist.’%%100790273

Oplossing:

clip_image004

clip_image006

Edit Datasources.xml
<?xml version="1.0" encoding="utf-8"?>

<DataSources clsid="{380F820F-F21B-41ac-A3CC-24D4F80F067B}"><DataSource clsid="{5C209626-D820-4d69-8D50-1FACD6214488}" name="WARD" image="2" changed="2011-03-02 09:04:35" uid="{2E9E5014-DEA3-4B65-AD9A-B8A6C602E576}" userContext="1" removePolicy="0"><Properties action="U" userDSN="0" dsn="WARD" driver="SQL Server" description="Ward" username="" cpassword=""><Attributes><Attribute name="SERVER" value="SQLSERVERNAME"/><Attribute name="TRUSTED_CONNECTION" value="Yes"/><Attribute name="DATABASE" value="DATABASENAAM"/></Attributes></Properties></DataSource>

</DataSources>

Delete username="" and cpassword=""
<?xml version="1.0" encoding="utf-8"?>

<DataSources clsid="{380F820F-F21B-41ac-A3CC-24D4F80F067B}"><DataSource clsid="{5C209626-D820-4d69-8D50-1FACD6214488}" name="WARD" image="2" changed="2011-03-02 09:04:35" uid="{2E9E5014-DEA3-4B65-AD9A-B8A6C602E576}" userContext="1" removePolicy="0"><Properties action="U" userDSN="0" dsn="WARD" driver="SQL Server" description="Ward" ><Attributes><Attribute name="SERVER" value="SQLSERVERNAME"/><Attribute name="TRUSTED_CONNECTION" value="Yes"/><Attribute name="DATABASE" value="DATABASENAAM"/></Attributes></Properties></DataSource>

Now the policy is deployed succesvol Open-mouthed smile

Microsoft Assessment and Planning Toolkit 5.5

The Microsoft Assessment and Planning Toolkit (MAP) is an agentless, automated, multi-product planning and assessment tool for quicker and easier desktop and server migrations. MAP provides detailed readiness assessment reports and executive proposals with extensive hardware and software information, and actionable recommendations to help organizations accelerate their IT infrastructure planning process, and gather more detail on assets that reside within their current environment. MAP also provides server utilization data for Hyper-V server virtualization planning; identifying server placements, and performing virtualization candidate assessments, including ROI analysis for server consolidation with Hyper-V.

MAP helps make the following IT planning projects faster and easier:

  • Migration to Windows 7, Windows Server 2008 R2, and Microsoft Office 2010
  • Migration to Windows 7 compatible versions of Internet Explorer
  • Migration to cloud-based services
  • Server virtualization with Hyper-V
  • SQL Server consolidation and migration to SQL Server 2008 R2
  • Assessment of current software usage and client access history for simplified software asset management
  • PC security assessment and migration to Microsoft Forefront Client Security

You can use MAP to inventory the following technologies:

  • Windows 7
  • Windows Vista
  • Windows XP Professional
  • Office 2010 and previous versions
  • Windows Server 2008 or Windows Server 2008 R2
  • Windows Server 2003 or Windows Server 2003 R2
  • Windows 2000 Professional or Windows 2000 Server
  • VMware ESX
  • VMware ESXi
  • VMware Server
  • Linux variants
  • LAMP application stack discovery
  • SQL Server 2008
  • SQL Server 2008 R2
  • MySQL
  • Oracle
  • Sybase

Download MAP 5.5 HERE

Microsoft Lync Error: Microsoft.Rtc.Common.Data.SqlConnectionException Cannot open database xds requested by the login. The login failed. Login failed for user Domain\administrator.

Lync

Error:

An error occurred: Microsoft.Rtc.Common.Data.SqlConnectionException Cannot open database xds requested by the login. The login failed. Login failed for user CONTOSO\administrator.

When Installing Lync there is automatically added a firewall rule that opend the port for the SQL Server Service

Solution:

Create a Windows Firewall port exceptions to enable access to the SQL Server Browser service, follow these steps:

    1. Click Start, and then click Control Panel.
    2. Open the Windows Firewall program.
    3. Click Change Settings to open the Windows Firewall Settings dialog box.
    4. Make sure that Windows Firewall is turned on, and then click the Exceptions tab.
    5. Click Add port to open the Add a port dialog box.
    6. Enter a name for the port exception, such as SQL Server Browser Service.
    7. Make sure that UDP is selected, and then enter UDP port number 1434. This is the default port that the SQL Server Browser service listens on.
    8. Click OK two times to close the Windows Firewall Settings dialog box
Translate »