Hi all
So one of the devs asked me to set up a share on one of our production SQL servers. I have, but I cannot seem to get to the share using the DNS alias set up for the server. It does work however if you use the actual server name. Problem is, this server is part of an AlwaysOn cluster and i don't want to hard code any server names into jobs, connection strings, packages etc - everything should point to the alias (which is the AlwaysOn listener) so that in the event of a failover, we don't have to go around changing hard coded connections every where.
I've done some research and sounds like this can be resolved by adding the DisableStrictNameChecking DWORD value to the registry and setting it to 1. I have done this but unfortunately it doesn't appear to work. Is this because the server is in a cluster? Does anyone know how i can get this working? Would be ideal to use the alias/listener wherever I can.
Thanks
Doodles