Microsoft SQL Server unknown for SQL Server 2014 Instances

Thanks for developing and sharing this powerful tool. I have found that for SQL Server 2014 It's not generating the product name as Microsoft SQL Server 2014 in Database Engine Config file. Sample ...

Id #25 | Release: None | Updated: Mar 27 at 6:46 AM by szubair1 | Created: Mar 27 at 6:46 AM by szubair1

module RDS-Manager causes issue Win10 PS 5

Hi all, just noticed a minor issue which isn't directly related to the Power Doc solution. If you're using Windows 10 and PS Version 5 you'll get a Null reference exception if you have the module...

Id #24 | Release: None | Updated: Nov 3, 2016 at 4:16 PM by Feleryan | Created: Nov 3, 2016 at 4:16 PM by Feleryan

Exception calling "SizeOf" with "1" argument(s):

Hi, Thanks for this project. I just tested it on a sql 2012 server and couldn't go beyond this error: Instance name is server\sp2013 (server is netbios servername). The tool is using a fqn. S...

Id #23 | Release: None | Updated: Nov 18, 2016 at 5:23 PM by KenScoggin | Created: Oct 19, 2016 at 8:02 PM by SpRambler

Question

I am trying to put this in a job. So when someone wants an updated inventory. Then can just run the sql agent job,. I got it all working except the conversion to excel. Has any one tried this? or h...

Id #22 | Release: None | Updated: May 27, 2016 at 6:40 PM by kendalvandyke | Created: Apr 1, 2016 at 11:45 PM by dyard12

Named SQL Instance is Reported as Disabled

The named SQL instance is reported ad disabled when it is running if the default instance is disabled.

Id #21 | Release: None | Updated: Dec 22, 2015 at 10:50 PM by kendalvandyke | Created: Sep 8, 2015 at 1:20 PM by JKL

Computername - forced to put into comma delimited format

Another issue I have come across is the requirement of Get-SqlServerInventoryToClixml.ps1 forcing a user to put the ComputerName parameter into a comma delimited format. In the situation I am in, ...

Id #20 | Release: None | Updated: Mar 11, 2016 at 4:58 PM by kendalvandyke | Created: Aug 26, 2015 at 11:03 PM by AfterSunrise

Exception calling "EndInvoke" with "1" argument(s)

While I would like to report that I have used this product, unfortunately, it has failed every time I have attempted to use it. Specifically, I am getting the following error and need an immediate...

Id #19 | Release: None | Updated: May 27, 2016 at 6:38 PM by kendalvandyke | Created: Aug 26, 2015 at 10:42 PM by AfterSunrise

No valid module

Hi, I seem to be failing at the first hurdle. I downloaded, unblocked and extracted the zip to c:\tools\sql doc. I open PS ISE and type .\Get-SqlServerInventoryToClixml.ps1 -ComputerName 'domai...

Id #18 | Release: None | Updated: May 27, 2016 at 6:46 PM by kendalvandyke | Created: Aug 26, 2015 at 10:33 PM by JGP

Problem with databases having 6.5 compatibility level

probably a minor issue as these scenarios are going to disappear soon (hopefully), but if you have a database with compatiblity level 6.5 on a SQL Server 2000 instance, the following error is risen...

Id #17 | Release: None | Updated: May 27, 2016 at 6:47 PM by kendalvandyke | Created: Aug 6, 2015 at 9:30 AM by ghotz

): Exception calling "EndInvoke" with "1" argument(s):

I love this script. It provides a ton of useful infomation. Thank you for creating it. I'm receiving the following error and I'm not sure what is causing it. It seems to be an access or permissi...

Id #16 | Release: None | Updated: May 27, 2016 at 6:48 PM by kendalvandyke | Created: Jul 13, 2015 at 7:18 PM by alsmi8009