Viewing 15 posts - 106 through 120 (of 199 total)
It is exactly the same as any regular SQL server, and has the exact same requirements as any other AD member server.
The AD sites need to be configured correctly, DNS...
August 1, 2023 at 5:40 pm
Its 1033 pages, I already started going down that thought train then saw he posted its size.
That close to the lower limit for it rebuilding in indexOptimize, (which...
August 1, 2023 at 5:02 pm
Its 1033 pages, I already started going down that thought train then saw he posted its size.
That close to the lower limit for it rebuilding in indexOptimize, (which is actually...
July 31, 2023 at 7:09 pm
haha good find. That is a type of fun problem that could easily take hours to figure out
July 26, 2023 at 5:49 pm
That weakly suggests a Windows auth problem - the single label name may be a registered SPN but the fully qualified name is not. But you haven't said what client...
July 26, 2023 at 5:10 pm
The cluster is more than likely failed, you will have to force quorum. 2012 R2 introduced dynamic quorum, but it can't lose most of the votes at the same time....
July 25, 2023 at 3:37 pm
Is there some sort of host based nips/firewall installed other than defender?
July 24, 2023 at 5:17 pm
If you have done your due diligence, you have to shrug it off. Very few organizations do as a whole and many IT Professionals do not do it personally.
Being aware...
July 24, 2023 at 5:04 pm
oh and use something like portqryv2.exe from the monitoring SQL server to check if it is actually listening
July 24, 2023 at 3:57 pm
check if UDP 1434 is open - not sure if that was included in 'checking if the network settings are correct.'
Also confirm if the correct network profile is active. If...
July 24, 2023 at 3:56 pm
Why is the SQL Service account an admin on the server? That is a very poor security practice.
When I was first accidentally becoming a DBA, a lot of...
July 21, 2023 at 9:08 pm
Actually, I forgot about a PowerShell module that would make this very easy: ImportExcel
It is in the PS Gallery now so you can install it from a computer with an...
July 21, 2023 at 9:03 pm
I have had zero luck with that tool. I've attempted to use it in a few cases I had a confusing kerberos problems but ended up chasing new errors related...
July 21, 2023 at 6:50 pm
You can do that with SSIS as well. Actually I think this would be pretty painful to do without SSIS and would be difficult to support an maintain in xp_cmdshell...
July 21, 2023 at 3:31 pm
If you don't see a logon failure event in the instance logs, that is 100% a developer problem to diagnose.
July 19, 2023 at 7:43 pm
Viewing 15 posts - 106 through 120 (of 199 total)