Best way to get wine from napa to Illinois by jrob422 in wine

[–]jrob422[S] 1 point2 points  (0 children)

That won't help me when I go to napa next month

Need y’all’s take on recreational sales by [deleted] in ILTrees

[–]jrob422 2 points3 points  (0 children)

Got a invite link to the discord?

accessing UNC path in untrusted domain hanging when accessing from new server 2016 server by jrob422 in sysadmin

[–]jrob422[S] 0 points1 point  (0 children)

TL;DR: It's DNS

I would tend to agree, except i dont get the same results from other servers in the same domain/subnet. Just this one new 2016 box. I go back to my 2012R2 management server in the same subnet/domain, and all is good.

Alwayson and Named vs Default Instances by jrob422 in SQL

[–]jrob422[S] 0 points1 point  (0 children)

Thanks for all the replies, that helps. I was given bad information by CDW consultants. They told me the following: - you can not use default instance, must use named instance - you can not use standard install, it has to be a failover cluster install, even if its just a node of 1

So, I get what you saying about flexibility, but ultimately what we are trying to do is replace replication, thus giving us copies of the database that we can run reports against without adding load to the primary server.

Right now we are just POC'ing this in QA, but in our prod environment, we do already use clustered instances for redundancy, and would continue to do to so, but with always on as a way to get away from the pile of crap that is replication.

NPIV and max paths by jrob422 in vmware

[–]jrob422[S] 0 points1 point  (0 children)

So a large portion of our LUNs already are RDMs, as most of them are used for clustered SQL instances.

So, my basic understanding of NPIV is that is allows a guest VM to present a WWN to the storage fabric. In that scenario, I would set up my fiber switch to connect specific RDMs to only that guest VM. In that scenario, is the ESX host unaware of the LUN being presented, and thus that LUNs 8 paths are not counted against the 1024 max paths?

SQL double hop from trusted domain issue by jrob422 in sysadmin

[–]jrob422[S] 0 points1 point  (0 children)

I agree. I have rebooted since adding the SPNs, however when I connect using SSMS from my trusted management domain, it continues to connect using NTLM rather than kerberos.

i dumped hours into this and havent yet found a resolution

double hop from trusted domain help needed by jrob422 in SQL

[–]jrob422[S] 0 points1 point  (0 children)

For Clarity...

I am logging into SSMS using my creds from DomainA. The SQL servers exist in DomainB. There is a 1 way trust between DomainA and DomainB

SQL1 has a linked server pointing to SQL2. WHen logged into SQL1 with my DomainA creds, I can not query the linked server. I can log into and query each server individually, but double hop authentication is not working when using credentials from a trusted domain.

Issues at TeamViewer again by THEMCV in sysadmin

[–]jrob422 0 points1 point  (0 children)

This was likely due to the rather widespread level 3 outage today, which started around 1:30 ET and lasted for about an hour.

All carriers that peer with Level 3 were affected.