Viewing 15 posts - 16 through 30 (of 312 total)
I made the changes based on your recommendations so now the plain report is displayed when I use https://server/ReportServer but then I get HTTP Error 404. The requested resource is...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
September 22, 2023 at 1:12 pm
I followed this RSExecRole document, recreated the role, granted all necessary permissions, restarted reporting server but getting the same error. I have admin rights on the server. The service...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
January 27, 2021 at 6:13 pm
This role doesn't exist on Dev and Prod but I am able to manage the subscription. However, I am going to create this role as well as grant permissions
NT**** already...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
January 26, 2021 at 4:02 pm
I just checked log_reuse_wait_desc and it shows 'AVAILABILITY_REPLICA'. I know now what's causing this.
Thanks for the help.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
September 18, 2020 at 2:22 pm
Hi,
if you got this error next time, just take a look at this query:
SELECT
name AS DatabaseName,
log_reuse_wait_desc AS LogBlocking,
...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
May 5, 2020 at 12:13 pm
Sorry, found a solution. We have a DAG and someone was working on DR server so DBs is out of sync and that's what causing the issue.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
May 4, 2020 at 2:19 pm
Sue_H, screenshots which I shared last week were from the Extended events session for the Always on health.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
February 3, 2020 at 2:37 pm
I believe we have 4 servers (Node1, Node2, node3 and node4) in one subnet. All physical servers. Environment details.
Node1 act as a primary for 1st AG. Node 2, Node 3...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
January 27, 2020 at 3:58 pm
This is the patch level we are on.
Microsoft SQL Server 2016 (SP2-CU10) (KB4524334) - 13.0.5492.2 (X64)
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
January 24, 2020 at 12:14 pm
TDE.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
January 3, 2020 at 3:31 pm
I tried this method and it worked. I turned off the encryption, dropped the encryption on the database, took the backup, restore the database on the secondary with norecovery, join...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
January 3, 2020 at 3:09 pm
Replacing the file worked, however; I am not able to join the DBs into AG.
I took the full backup and then the log backup of the database on a primary...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
January 3, 2020 at 2:22 pm
Replacing a file worked. Thanks!
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
January 3, 2020 at 1:41 pm
Just restarted the SQL Server service and it helped.
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
January 2, 2020 at 1:20 pm
I mean I just didn't run just DBCC shrinkfile. This is the complete command I ran for all 8 files but still no luck.
USE [tempdb]
GO
DBCC SHRINKFILE (N'tempdev'...
"He who learns for the sake of haughtiness, dies ignorant. He who learns only to talk, rather than to act, dies a hyprocite. He who learns for the mere sake of debating, dies irreligious. He who learns only to accumulate wealth, dies an atheist. And he who learns for the sake of action, dies a mystic."[/i]
January 2, 2020 at 12:25 pm
Viewing 15 posts - 16 through 30 (of 312 total)