Creating SQL server 2016 listener

hi,

I am right now try to create a SQL server 2016 listener by reading this:

https://www.sqlshack.com/alwayson-availability-groups-how-to-setup-ag-between-a-clustered-and-standalone-instance-part-3/

question is :

1)  in the article above:

" To create a listener, we will also need an IP and Computer in the AD, and don’t forget that the cluster computer should have full access to the SQL Server computer account."

I am now have and IP address and a computer name (name only), is that mean that Computer name must exists in the AD for it to works? currently that computer name is not register in the AD.

now I am created a SQL 2016 AOG in a domain less configuration and I am not sure if listener will work in this case.

2) to create the listener, should/must the SQL server need to join the AD too ?

3)
when creating the listener on the wizard shown in the link above:

"A new window will be opened. Fill the “Listener DNS Name” with the name of your AD Computer Name. In our case SQLSRVAG01. In the “Port” field, choose an adequate port, something that is not being used.

what is listener DNS name ?  the listener name I have ? e.g. SQLSERVERListener ? do I need domain surfix for it?  

I can't create one using that name only and the error is :

listener error.
LVL 1
marrowyungSenior Technical architecture (Data)Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vitor MontalvãoMSSQL Senior EngineerCommented:
It's the listener name already created in the Active Directory (AD)?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
marrowyungSenior Technical architecture (Data)Author Commented:
hi,

it is just a name i reserved for the listener. so is that mean this name, virtual name, MUST register in AD?  so this also means SQL server has to join domain too ?
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
You shouldn't pre register nothing. The SQL Server service account should have write permissions in the active directory to create the listener name (DNS entry).
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

marrowyungSenior Technical architecture (Data)Author Commented:
so this means the add listener wizard will create the respective name and register in AD itself ?
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Yes. The error you're getting it looks to me that is because the listener name has been already created.
0
marrowyungSenior Technical architecture (Data)Author Commented:
" The error you're getting it looks to me that is because the listener name has been already created. "

I thought it is a WSFC depending service error ?
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Read the error again. It says "The DNS name may have been taken or have a conflict with existing name services...".
WSFC only means that your using a cluster.
0
marrowyungSenior Technical architecture (Data)Author Commented:
"WSFC only means that your using a cluster. "

yeah, but AOG is depending on this, right?

" listener name has been already created. "

so this means we have to remove it from AD and then let Add listener wizard to recreate it ?
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
so this means we have to remove it from AD and then let Add listener wizard to recreate it ?
Correct.
0
marrowyungSenior Technical architecture (Data)Author Commented:
I am checking on this ! as I am installed SQL server in domain less environment and I just worry about I can't change it to join back AD, which should solve all problem, agree?
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Sorry, I don't have experience in installing SQL Server in a domain less environment so I can't confirm that you won't have issues.
0
marrowyungSenior Technical architecture (Data)Author Commented:
yeah, tks for it anyway!  I think this configuration gives trouble, I probably join back domain very soon !
0
marrowyungSenior Technical architecture (Data)Author Commented:
I researched a lot, it seems that it is all related to AD, without AD, SQL listener can't create!

but it is funny that with SQL 2016 domain less AOG, SQL listener still relies on AD!!
0
marrowyungSenior Technical architecture (Data)Author Commented:
tks.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL

From novice to tech pro — start learning today.