N
Neile Bermudes
Hi all
I've been asked to set up a share on one of our production SQL servers. I have, but I cannot seem to get to the share remotely 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 failover cluster and i don't want to hard code any server names into jobs, connection strings, packages etc - everything should point to the alias 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 wherever I can.
Thanks
Continue reading...
I've been asked to set up a share on one of our production SQL servers. I have, but I cannot seem to get to the share remotely 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 failover cluster and i don't want to hard code any server names into jobs, connection strings, packages etc - everything should point to the alias 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 wherever I can.
Thanks
Continue reading...