SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,852 questions
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
0
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?
{count} votes
-
Viorel 112.9K Reputation points2024-05-06T19:41:06.95+00:00 Maybe you should write
$configset.SetDatabaseConnection("(local)\SQLExpress", .... -
Mike Horton 0 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 102.2K Reputation points MVP2024-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 102.2K Reputation points MVP
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