Hello,
When seting up my cluster it asked for a instance name instead using the default so I gave it one and now my cluster name is BankingSQL\BankingSQL how can I change this to just BankingSQL also in a way that it doesnt mess up my cluster.
SQL Named Instances are always accessed via [VirtualServerName]\[SQL Instance Name]. You "may" be able to do something clever with a DNS PTR record but I've not tried it. I'm also not sure what effect this would have on the Cluster Service (don't do you
r testing in a production environment).
|||Assuming that you don't wish to configure a client alias (cliconfg.exe) you could use a DNS CNAME alias record. For more info look up the CNAME in the windows DNS documentation.
|||You cannot change the SQL cluster name. You will need to uninstall and
reinstall to actually cchange the name. The methods suggested will allow
users to connect uisng the name you want but will not change the actual
name.
Rand
This posting is provided "as is" with no warranties and confers no rights.
|||Actually, you need a SRV record in the DNS server. SRV records point to IP
and port numbers.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Stephen Strong" <anonymous@.discussions.microsoft.com> wrote in message
news:18DED1C1-591D-4475-A01C-4C2F6328759B@.microsoft.com...
> Assuming that you don't wish to configure a client alias (cliconfg.exe)
you could use a DNS CNAME alias record. For more info look up the CNAME in
the windows DNS documentation.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment