Viewing 15 posts - 1 through 15 (of 86 total)
#1. Since nobody has responded, I'll offer maybe a bump in the right direction. I've found SPN's are very important to SSRS. I'd make sure you have a domain account...
April 22, 2024 at 2:14 pm
In AD, did you give the service account the 'Trust for delegation' property?
February 26, 2024 at 7:22 pm
https://dbatools.io/ - makes this very simple
You can use 'Sync-DbaLoginPermission' (everything) or 'Export-DbaDbRole' (to get role)
December 6, 2023 at 4:35 pm
Shrink it in smaller chunks.
Google for a script to reduce it incrementally.
https://www.sqlservercentral.com/blogs/sql-database-incremental-shrink-tsql
November 20, 2023 at 5:45 pm
Shrink it in smaller chunks.
Google for a script to reduce it incrementally.
November 20, 2023 at 5:44 pm
I'm now up to 10 failovers with no sync issues. I'm also on CU22.
October 12, 2023 at 8:52 pm
I hate to possibly jinx myself, but I've had 5 failovers with no secondaries out of sync. I've turned on ADR for a bunch of my databases. Maybe about 60...
October 2, 2023 at 4:33 pm
You probably lack the SPN's for SQL server. You can check them with the Microsoft tool: https://www.microsoft.com/en-US/download/details.aspx?id=39046
The tool can even generate the commands to add the missing ones.
September 11, 2023 at 2:16 pm
Maybe install the Kerberos diag tool and see if it checks out: https://www.microsoft.com/en-US/download/details.aspx?id=39046
The SSPI error is usually associated with missing SPNs.
August 23, 2023 at 4:12 pm
Make sure your server properties/database settings/database default locations are set to the drives you expect them to be.
August 21, 2023 at 9:18 pm
Bummer, I figured mine was a fluke. Thanks for the update.
I hear you on the licensing...mine is SPLA so it is very expensive to bump up.
August 21, 2023 at 4:52 pm
I applied CU21 late in July. I had my first restarts this last weekend and both my nodes came up clean with no secondary out of sync issues. Have you...
August 21, 2023 at 4:18 pm
Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'
This usually points to Kerberos double hop issues. Check you SPN's.
You can use this tool to check it: https://www.microsoft.com/en-US/download/details.aspx?id=39046
August 14, 2023 at 1:30 pm
<sigh> Thanks for the update.
I can confirm I also get some out of sync even though both nodes are on the same patch level.
July 13, 2023 at 11:32 pm
Viewing 15 posts - 1 through 15 (of 86 total)