Skip to content

WSUS 3.0 : Connecting, Managing and Moving SUSDB as Internal Database

Like you should know, WSUS gives you the choice, at the moment of installation, to choose a database instance where you would like to keep the WSUS database (SUSDB): Internal database (formerly known as SQL Server embedded), an existing database or an existing database on a remote computer. Sometimes, for example if you are just spiking about WSUS and you don’t want to install any version of SQL Server, you best choice would be the Internal Database option. But what happens if you change your mind later and you want to change the location of that internal database to a different drive? Or simply executing other tasks on the database, like generating a backup or shrinking? Fortunately there’s a way to connect to that DB without having to re install WSUS: Using SQL Server Management Studio Note: If you don’t have it, you can download the stand alone tool for SQL 2005 version: Microsoft SQL Server Management Studio Express; or you can download SQL Server 2008 Express Edition (the latest of the free SQL Server versions, includes among the tools the SQL Server 2008 Management Studio Express). 1. Open SQL Server Management Studio. In my case, I’m using SQL Server 2008 Express Edition.   2. Using the connection window, connect to this instance: \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query   3. You should see now in Object Explorer the database instance connection. Right-click on SUSDB –> Tasks –> Detach   4. Check the options for […]

Read More →

More Free eBooks: Windows Server 2008 Server Core and SQL Server 2005 Integration Services

Two more new and completely free eBooks from MS Press are available for download: Windows Server 2008 Server Core Administrator’s Pocket Consultant On this book you’ll find: Introduction to Server Core Deploying Server Core Initial Configurations Installing Roles and Features Local and Remote Management Detailed description of all roles available: Active Directory and DNS Hyper-V DHCP File and Print Services Web Server Others Maintaining Server Core Did you give Windows Server Core a chance already? On the obvious security reasons that you can find to install it; you’ll see other benefits like having a small footprint operating system, licensing price, great performance to take advantage all the features on the mentioned roles, including Hyper-V clustering. You can start on this book to get a nice introduction and to know all the possibilities with Server Core. And again, on the devs side (but it is also quite useful for IT guys) you’ll find a SQL Server 2005 book: SQL Server 2005 Integration Services Step-by-Step For another free eBook (“Virtualization Solutions”) still available, click here. Enjoy! Cheers!

Read More →

Experiencing Lenovo W500 with Windows 7

  Also check the updated post using Windows 7 RC: Experiencing Lenovo W500 with Windows 7 (RC) – Part II   Well finally my wait was over on the last week, I could finally get my self a fresh new laptop with all the horse power that I was wanting for :) This new toy of mine is the Lenovo ThinkPad W500. This fine solid piece of machine it’s not actually a brand new model (around 6 moths older now on their firsts models). My own model (4063-33Y) fits perfectly on most of power users looking for a nice laptop with a better performance. A few highlights of this notebook (full hardware review at this CNET link): Core 2 Duo T9400 (2.53 GHz) VPro Technology 4GB RAM DDR3 160GB 7200rpm HD 15.4in 1680×1050 LCD ATI™ Mobility FireGL™ V5700 512MB Before I even received this notebook I knew that Windows 7 was going to be the first operating system to be installed. So, I want to tell you about my experience so far working with Windows 7 inside this laptop. Installation No problems here, the installation process executed without any problem. The version selected was the 64 bits. Note: This is a cool link about why to use Windows 7 with a 64bits architecture. Drivers After the Windows 7 installation, almost every “important” device was automatically configured: Video, wireless, Ethernet card and audio. But if you check the Device Manager, you’ll […]

Read More →

Infrastructure Planning and Design: Complete Package

This is, no doubt, one great link to share with the community. Whenever you are planning to implement any kind of technology or solution on your company regarding to Windows Server, you’ll need to take a look at these documents. Infrastructure Planning and Design The Infrastructure Planning and Design (IPD) guides will help and guide you among the design process giving you all the tools and scenarios needed for a correct design. The new document available is the complete planning and design for System Center Data Protection Manager 2007 SP1. Another interesting thing about it, is that the download also includes for each technology not only the document of IPD but also a great PowerPoint that can help you around with maybe a small presentation for your team or management in your company.   Overview Infrastructure Planning and Design guides share a common structure, including: Definition of the technical decision flow through the planning process. Listing of decisions to be made and the commonly available options and considerations. Relating the decisions and options to the business in terms of cost, complexity, and other characteristics. Framing decisions in terms of additional questions to the business to ensure a comprehensive alignment with the appropriate business landscape. These guides complement product documentation by focusing on infrastructure design options. Each guide leads the reader through critical infrastructure design decisions, in the appropriate order, evaluating the available options for each decision against its impact on […]

Read More →

Troubleshooting WDS: Event ID 257 – 258 – 266 – 513

Windows Deployment Services depends and works directly with Active Directory and DHCP, meaning that if any of those two servers are significantly modified, then probably you will not be able to start the WDS service and get the events ID: Event Viewer from WDS Server Event 257: An error occurred trying to start the Windows Deployment Services server. Event 258: An error occurred trying to start the Windows Deployment Services image server. Event 266: An error occurred while to refreshing settings. Event 513: An error occurred trying to initialize provider WDSImgSrv from C:\Windows\system32\WdsImgSrv.dll. Windows Deployment Services server will be shutdown. Disclaimer Please note that the following possible reasons, are related when all those events appear simultaneously and with the same descriptions. Event ID 513 can also appear regarding to a PXE provider error: “An error occurred while trying to initialize provider WDSPXE from C:\Windows\system32\wdspxe.dll. Windows Deployment Services server will be shutdown”. This particular error could happen for several reasons, like installing on the same server a System Center Configuration Manager PXE provider that replaces the WDS. Possible Reasons Those particular errors appeared when there were changes on Active Directory that did not were performed smoothly: – Changing a Global Catalog from Domain Controller. – Shutting down an active Domain Controller. Solution To solve this, you need to insert manually the FQDN of the domain controller working as a Global Catalog. 1 – Open the WDS snap-in and access server properties. […]

Read More →

Remote Server Administration Tools (RSAT) released for Windows 7

Well, with the Windows 7 Beta 1 released to the public recently, you now have one less excuse to try on Windows 7. You can now completely have full management of your servers using Remote Server Administration Tools. The RSAT suite is now available for Windows 7 and you can download it from here. Remember to install and start using these tools, you must use the same procedure as in Windows Vista: Install the downloaded package. Access “Turn Windows Features on or off “.  Scroll down Remote Server Administration Tools.  Select the tools you would like to add Windows 7 and click OK. RSAT installed on Windows 7 Enjoy! Cheers

Read More →

Hyper-V Server 2008 R2 Beta Available for Download!

Did you get the chance to try on the free Hyper-Visor released by Microsoft a few months ago, Hyper-V Server 2008?. Don’t get confused, this is not a version of Windows Server 2008, it’s just the hyper-visor released as a "bare-metal" operating system, based significantly on remote administration (nothing much to do locally), but the great feature is that is completely free. Now they’ve also released the R2 version of this operating system, and you can download it from here (~1.2gb). The main improvements from the previous versions: Hyper-V clustering supported! Live Migration. Processor and memory upgrades (up to 32 cores and 1TB of RAM). Includes an Hyper-V configuration utility. I had the chance to work with the first version and it’s been a great experience. Since it’s just an hyper-visor with a really small footprint, has an awesome performance on their virtual machines, including a small attack surface design. One of the significant drawbacks that I found on the first version is that Hyper-V clustering/failover was not supported, but this new release sounded like a great news when I saw that is going to support this feature. Making this free operating system with a great performance, high-available and scalable design. Give this one a chance to test it, you won’t regret it. Check a previous guide I’ve made regarding Hyper-V Server 2008 (applies as well for the R2 version): “Hyper-V Server: Installing, Configuring and Troubleshooting” Cheers!

Read More →