Viewing 15 posts - 1 through 15 (of 51 total)
May have found an answer.
I hadn't opened SQL Server Configuration Manager since the upgrade but when I tried, I got the error:
Cannot connect to WMI provider
Googling that, I found the...
November 19, 2023 at 11:15 am
Thanks for the response. That registry hive was missing from the server after the upgrade - maybe "HKLM\SOFTWARE\Microsoft\PowerShell\1\ShellIds" got replaced by the upgrade?
However we tried recreating it previously but that...
November 19, 2023 at 10:34 am
I'd already found that and it doesn't work. If I run PowerShell, I get:
Scope ExecutionPolicy
----- ...
November 19, 2023 at 1:26 am
Hi Andreas
Yes, the file does exist and the account is able to delete the DBCC snapshot file (which is what this is) for all the other databases in this folder.
Peter
November 6, 2023 at 7:34 am
Thanks for the feedback. On our new server (which is actually PowerBI) we have moved to DNS aliases so moving forward, we'll be fine. Just need to deal with the...
June 23, 2023 at 10:55 am
Ah. That's annoying. But thanks.
Is there a way to redirect SSRS given that I don't want to uninstall it just yet.
June 16, 2023 at 7:25 pm
Sorry; phrased my question badly.
Since SSRS isn't running, *how* is it intercepting the URL? Why isn't this seen by IIS as any other HTTP request and redirected?
That's what I meant.
June 16, 2023 at 6:33 pm
So I've been doing some more investigations into the issue, running ProcMon against the PowerShell process while the task was running and found that there was a 5 second pause...
May 23, 2023 at 3:42 pm
Why do they need to see that information? It could contain sensitive data (e.g. passwords) that should not be exposed - and really doesn't provide any additional information that...
May 9, 2023 at 11:28 am
I haven't tested this but maybe it requires one of the SSIS permission roles? I think this is the relevant documentation https://learn.microsoft.com/en-us/sql/integration-services/security/integration-services-roles-ssis-service?view=sql-server-ver15
As I said not tested and...
May 9, 2023 at 11:26 am
Hi Alex. I hadn't tried it but I just have without success 🙁
April 27, 2023 at 1:57 pm
This may be a niche issue but the resolution (after logging with Microsoft) was as follows:
October 13, 2022 at 8:51 am
Yes I am an administrator on the server and the disk is not compressed.
Further investigation with Process Monitor is pointing to whichever system process is creating the "Watson_1" folder at:
C:\Program...
August 2, 2022 at 12:38 pm
Solved it! Typical, just after posting the question :-/
Need to remove "ORDER BY" from the COUNT(*) window function. Corrected line is:
COUNT(*) OVER(PARTITION BY...
July 13, 2022 at 9:08 am
Viewing 15 posts - 1 through 15 (of 51 total)