Sample Header Ad - 728x90

MS SQL Server alias and DNS server

0 votes
1 answer
128 views
I have a MS SQL Server S hosting a MS SQL Server instance I. I would like another machine M to be able to connect to that instance remotely via the TCP port P. I created an alias A = S\I,P on both S and M using the C:\Windows\SysWOW64\cliconfg.exe tool. S and M can both use the alias A properly. If I wanted another machine M2 to be able to connect to that MS SQL Server instance too, I would need to create an alias on M2 like I did on machines S and M. Is there a way to do it in the DNS server (Microsoft DNS Manager)? I don't see how it could be done because basically: - I would need the DNS server to register the fact that A is an alias for S\I,P - and when a client machine C on the network uses A, I would need the DNS server to "resolve" that alias for C. If it cannot be done using a DNS server, is there a way to do it in a centralized way (that is to say: having some sort of service on the network that "translates" A into S\I,P when a client machine asks for it) ?
Asked by Léa Massiot (101 rep)
Mar 6, 2024, 05:15 PM
Last activity: Mar 6, 2024, 06:23 PM