Issue encountered with Idera SQLdm installation

 

We currently use Idera  SQL Diagnostic Manager to monitor our SQL instances. I got my laptop from the company running Windows 7 and pre-imaged. Although every time I tried to install SQLdm, ran into same issue. It started with installation fine but then suddenly fail within few seconds. Looked through Windows Error Logs but couldn’t determine anything till I noticed one thing in error logs. It kept on pointing out faulting application IDriver.exe is the main culprit.

I researched on the internet and couldn’t figure out what would be the main reason. After multiple hours of research, I told a snapshot of the machine and decided to rename C:\PROGRAM~2\COMMON~1\INSTAL~1\Driver\1150 to C:\PROGRAM~2\COMMON~1\INSTAL~1\Driver\1150-1. I started SQLdm install again and it created a new folder and the install was successful. I am open to suggestions if there is another way to resolve this.

Thanks!

One Feature I really like in SSMS 2012 – Close Existing Connections

I always used to get frustrated whenever I was doing restores in SSMS 2008 and previous versions where I would get blocked because databases had connections and I cannot get exclusive lock. I would have to script out and add

1. Set Single User with rollback immediate
2. Restore database
3. Set database to multiuser mode

With SSMS 2012 GUI, they already include the option to drop all connections and run the restore(Basically setting single user and multiuser) . It runs pretty seamless and worth it.

This Feature works with SQL 2012, SQL 2008 R2, SQL 2008, and SQL 2005. I haven’t much opportunity to test on SQL 2000 and prior versions. This option didn’t come up for

Here is a screenshot

 

Thanks!