Re: Moving Non-Clustered to Clustered

Thanks for the help, but I am still having trouble finding exactly how to do
it.

Is it just as simple as redirecting the TCP/IP traffic to the correct
ip/port, like a dyn dns service or is there more to it?

Sorry if we are being obtuse, but neither I, nor my Net Admin, can seem to
find anything in BOL, or at MS or online about setting up a SQL Instance with
DNS SRV records.

--
Ryan S
SQL DBA
1Jn5:12


"Geoff N. Hiten" wrote:

You do it by using DNS SRV records. SRV records allows for an arbitary
service to use DNS to map a name to an IP Address and Port number.

When you cut over, create a "Bitter" and "Silver" record that points to the
new clustered instance names.

--
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP




"Ryan S" <RyanS@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:EA78A067-5C48-4C17-9819-064C8399BF0F@xxxxxxxxxxxxxxxx
Hi,

I have been looking for the last few hours for how to move a non-clustered
environment to a clustered environment without having to change the
connection strings of any of our applications. I'm not finding it
anywhere.

It's been a while since I did this, and I thought we could have a virtual
name for both instances that are the same as the old computer names (I.E.
Instance 1 is called "Bitter" and instance 2 is called "silver" from the
apps, even if the actual names are ClustName\Instance1 &
Clustname\Instance2).

Is this possible, and can someone point me to where I can find how to do
this, if it is?

Thanks,
--
Ryan S
SQL DBA
1Jn5:12


.

Relevant Pages

  • Re: KB948110 causes server breakdown
    ... I'm not talking about DNS, more specifically I'm asking if you installed the DNS patches when you installed the SQL patch? ... Then I though to go backwards and try to fix another problem which appeared with SHAREPOINT 2.0. ... SQL instance was not starting for Sharepoint and I though that they might somehow be related with the problem with the POP3 manager. ...
    (microsoft.public.windows.server.sbs)
  • Re: NewBie ASP.NET on a PDC securiy sugestions
    ... are about 25, I am running SQL, and imail, and DNS on the server. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: slow DNS caused extreme SQLS memory pressure+CPU?
    ... RAM in my 64-bit SQL Server box. ... The DNS problem occurring at almost the same time is simply ... The CPU on the SQLS ...
    (comp.databases.ms-sqlserver)
  • Re: SQL 2000 Maintenance Plan Email Notifications
    ... Andrew J. Kelly SQL MVP ... > client open, frequently locks up, won't work in a clustered environment, ... > notifications can break if you start editing your maintenance plans. ...
    (microsoft.public.sqlserver.setup)
  • Re: query sql or dns?
    ... I'm no expert but, I'd probably say, query the SQL table...... ... > I also dump all of our dns entries daily in to a sql database. ... > The .asp lists all the ip addresses as a 'link' to a javascript popup ...
    (microsoft.public.inetserver.asp.general)