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
Last activity: Mar 6, 2024, 06:23 PM