SetDatabaseConnection WMIMethodException Error
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 12%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMH%3C/text%3E%3C/svg%3E)
Mike Horton
5
Reputation points
I'm using a slightly modified version of the script found here: https://blog.aelterman.com/2018/01/03/complete-automated-configuration-of-sql-server-2017-reporting-services/. The modification is that I'm pointing to (local)\SQLExpress on line 41 as the SQL namespace is under computername\SQLEXPRESS. This has worked fine until no when I'm trying to set up Reporting Services using SQL Reporting Services 2022. Now when I run the line $configset.SetDatabaseConnection("(local\SQLExpress", ReportServer", 2, "","") it returns an Exception calling "SetDatabaseConnection" : "" and then further down FullyQualifiedErrorId : WMIMethodException"", "") Has something changed in scripting out the Report Server?
Windows for business | Windows Server | User experience | PowerShell
SQL Server | Other
{count} vote
-
Viorel 126.1K Reputation points2024-05-06T19:41:06.95+00:00 Maybe you should write
$configset.SetDatabaseConnection("(local)\SQLExpress", .... -
Mike Horton 5 Reputation points
2024-05-06T22:30:13.16+00:00 Viorel.. Say what? Sorry that's a typo in my original post.. I am calling $configset.SetDatabaseConnection("(local)\SQLExpress", ReportServer", 2, "","")
-
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(73.60000000000001, 15%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)
Chen, Dong 0 Reputation points2024-05-09T20:12:11.2033333+00:00 I got the same issue using WMI method to configure the database connection. The problem is the latest SSRS released on 5/1. The version before that one works without any issues. Can we get a ticket open to fix this issue?
-
Erland Sommarskog 131.4K Reputation points MVP Volunteer Moderator2024-05-09T20:15:07.9533333+00:00 What are the full error messages you are getting?
-
Chen, Dong 0 Reputation points
2024-05-09T20:35:47.62+00:00 It just says Exception calling "SetDatabaseConnection" : "" in PowerShell.
But when use the C# to call the same function, the error message is "Error message is unavailable. Source: WinMgmt" -
Erland Sommarskog 131.4K Reputation points MVP Volunteer Moderator
2024-05-09T20:41:46.0333333+00:00 That's certainly not very helpful.
There have been changes all through Microsoft to have connections to default to be encrypted, and this error may be related to such a change. But if that is the case, the component that experiences the error swallows and reports this nonsense.
I think your best option is to open a support case.
Sign in to comment
Sign in to answer