I received the following trying to detach the msdb database in SQL Server 2005 : Cannot detach an opened database when the server is in minimally configured mode I was trying to move msdb according to kb224071. I finally found why. When I opened my query in SQL Server Management Studio (SSMS) I was connecting to msdb database by default. Event if I do a use master; after that, it was too late, I always got an error doing a sp_detach_bd 'msdb'; So here's the trick : Click new query on the tool bar of SSMS Click on the Options >> buton in the Connect to Server dialog Select the Connection Properties tab Type master in the Connect
Last night I spent a few hours trying to follow the kb224071's instructions to move the MSDB system database but was always getting the following error trying to connect with the -c -m -T3608 startup options : Login failed for user '******'. Reason: Server is in single user mode. Only one administrator can connect at this time. [CLIENT: *.*.*.*] But nobody else was using the database ! Seems that I was wrong. When I looked again at my error log I saw this line : Login succeeded for user 'NT AUTHORITY\SYSTEM'. Connection: trusted. [CLIENT: *.*.*.*] Then I tried the same thing in virtual without a cluster and everything worked fine, so I got a little suspicious about the
I misted that news, but looks like FastCGI has bean released to manufacturing. Read more and download : FastCGI Extension for IIS6.0 FastCGI for IIS7
So far, we have made available 12 different Extensions as CTP, Go Live, or RTW releases. Each one is completely free and integrates fully with IIS 7.0. We even released versions of the FTP and WebDAV extensions for IIS 6.0, although you’ll see us do that less often in the future because we feel strongly that IIS 7.0 should be the Web platform of choice so that’s where we’ll concentrate our efforts. Here’s the full list: Deployment Web Deployment Tool [Go Live] (x86) and (x64) Management PowerShell Provider for IIS7 [CTP] (x86) and (x64) Administration Pack for IIS7 [CTP] (x86) and (x64) Database Manager for IIS7 [CTP] (x86) and (x64) IIS Manager for Remote Administration [RTW] (x86) and
Updated in december 2008 (see at the end)
I've been playing with Database Mail in my SQL 2005 Cluster for a few days now. I always get the following errors :
Database Mail Log:
Log Database Mail (Database Mail Log)
Last Modified By sa
Message : Activation failure.
EventViewer Application Log: Event Type: Information
Event ID: 9724
User: N/A
Description: The activated proc [dbo].[sp_sysmail_activate] running on queue msdb.dbo.ExternalMailQueue output the following: 'Error executing extended stored procedure: Invalid Parameter' Last night I found a solution and I though it would be a good idea to share it.
As you know SQL Server use an external program to process mail : DatabaseMail90.exe. As I understand it, when SQL launch
Oh dear. The Chicken Little contingent is out in full force. Break out your Kevlar helmets, everyone, because the sky is falling on Windows! At last week’s Black Hat conference in Las Vegas, researchers Alexander Sotirov and Mark Dowd presented a paper that outlined some new attack vectors they had discovered targeting some security features introduced in different versions of Windows XP and Windows Vista. It’s a fascinating paper, rich in technical detail and hewing to the Black Hat tradition of providing clues that others can follow to discover, exploit, and ultimately fix vulnerabilities in widely used computer code. Read Ed Boot's article at blogs.zdnet.com
As a tech writer, one of my biggest pet peeves is the plethora of bad advice littered across almost every web site dedicated to system tweaking. Besides the tweaks that simply don't work, some of them will actually cause your computer to run even slower—or worse. Let's examine some of the most offensive myths out there regarding PC performance tweaking, and debunk them once and for all. Read the complete article at lifehacker.com
These days application virtualization is a hot topic. Michael Pietroforte form 4sysops blog has produce a list of advantage and of disadvantage for the new technology : The advantages of application virtualization The disadvantages of application virtualization
For a few days I'm not able to check for new updates from my WSUS server, I always get an error 8024400E. Strangely if I check for updates from Microsoft Update I've got no error. A few computers (and servers) at my location got the same problem. Today I've tired the workaround published by Cecilia Cole (WSUS Program Manager) and it WORKED ! Many thanks Cecilia, Source : Client/Server Synchronization issues
