Server side redirection to another instance of SQL Server?

10-12-2007, 03:08 PM

Hi!

SQL Server 2005 will be installed next to SQL Server 2000 which
is the default instance.

Is it possible to have a server side redirection so that all
clients will be redirected to SQL Server 2005 instead of 2000?

I know of client side server aliases, but then this alias has to
be set on every client. Otherwise, the connection string of all
clients will have to be adjusted :-(

Can you give me a hint?

Thank you in advance,
Franz.

10-12-2007, 09:17 PM

If the connection strings are using the servername simply change the entry
in DNS to point to the IP of the other instance.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Franz Lang" <FL_FEE@newsgroup.nospam> wrote in message
news:475d06fd$0$90275$...
> Hi!
>
> SQL Server 2005 will be installed next to SQL Server 2000 which is the
> default instance.
>
> Is it possible to have a server side redirection so that all clients will
> be redirected to SQL Server 2005 instead of 2000?
>
> I know of client side server aliases, but then this alias has to be set on
> every client. Otherwise, the connection string of all clients will have to
> be adjusted :-(
>
> Can you give me a hint?
>
> Thank you in advance,
> Franz.

10-12-2007, 10:37 PM

If the connection strings are using the servername simply change the entry
in DNS to point to the IP of the other instance.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Franz Lang" <FL_FEE@newsgroup.nospam> wrote in message
news:475d06fd$0$90275$...
> Hi!
>
> SQL Server 2005 will be installed next to SQL Server 2000 which is the
> default instance.
>
> Is it possible to have a server side redirection so that all clients will
> be redirected to SQL Server 2005 instead of 2000?
>
> I know of client side server aliases, but then this alias has to be set on
> every client. Otherwise, the connection string of all clients will have to
> be adjusted :-(
>
> Can you give me a hint?
>
> Thank you in advance,
> Franz.

10-12-2007, 10:41 PM

Andrew J. Kelly schrieb:
> If the connection strings are using the servername simply change the
> entry in DNS to point to the IP of the other instance.

I forgot to mention that the new instance will be installed on
the same machine. Otherwise, your suggestion would have worked well.

11-12-2007, 12:11 AM

Andrew J. Kelly schrieb:
> If the connection strings are using the servername simply change the
> entry in DNS to point to the IP of the other instance.

I forgot to mention that the new instance will be installed on
the same machine. Otherwise, your suggestion would have worked well.

11-12-2007, 03:44 PM

No, not really. Each instance has an associated port number tied to it. The
default for the default instance is 1433. For a named instance it is
something else. If you add the port number it will point to the correct
instance.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Franz Lang" <FL_FEE@newsgroup.nospam> wrote in message
news:475d645a$0$90272$...
> Andrew J. Kelly schrieb:
>> If the connection strings are using the servername simply change the
>> entry in DNS to point to the IP of the other instance.
>
> I forgot to mention that the new instance will be installed on the same
> machine. Otherwise, your suggestion would have worked well.

11-12-2007, 03:45 PM

No, not really. Each instance has an associated port number tied to it. The
default for the default instance is 1433. For a named instance it is
something else. If you add the port number it will point to the correct
instance.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Franz Lang" <FL_FEE@newsgroup.nospam> wrote in message
news:475d645a$0$90272$...
> Andrew J. Kelly schrieb:
>> If the connection strings are using the servername simply change the
>> entry in DNS to point to the IP of the other instance.
>
> I forgot to mention that the new instance will be installed on the same
> machine. Otherwise, your suggestion would have worked well.

11-12-2007, 03:53 PM

Andrew J. Kelly schrieb:
> No, not really. Each instance has an associated port number
> tied to it. The default for the default instance is 1433. For
> a named instance it is something else.

Yes, I knew that.

> If you add the port number it will point to the correct
> instance.

If I added the port number where?

Franz.

11-12-2007, 03:53 PM

Andrew J. Kelly schrieb:
> No, not really. Each instance has an associated port number
> tied to it. The default for the default instance is 1433. For
> a named instance it is something else.

Yes, I knew that.

> If you add the port number it will point to the correct
> instance.

If I added the port number where?

Franz.

11-12-2007, 03:54 PM

No, not really. Each instance has an associated port number tied to it. The
default for the default instance is 1433. For a named instance it is
something else. If you add the port number it will point to the correct
instance.

--
Andrew J. Kelly SQL MVP
Solid Quality Mentors

"Franz Lang" <FL_FEE@newsgroup.nospam> wrote in message
news:475d645a$0$90272$...
> Andrew J. Kelly schrieb:
>> If the connection strings are using the servername simply change the
>> entry in DNS to point to the IP of the other instance.
>
> I forgot to mention that the new instance will be installed on the same
> machine. Otherwise, your suggestion would have worked well.

10-12-2007, 03:08 PM	#1
Franz Lang Guest Posts: n/a	Server side redirection to another instance of SQL Server? Hi! SQL Server 2005 will be installed next to SQL Server 2000 which is the default instance. Is it possible to have a server side redirection so that all clients will be redirected to SQL Server 2005 instead of 2000? I know of client side server aliases, but then this alias has to be set on every client. Otherwise, the connection string of all clients will have to be adjusted :-( Can you give me a hint? Thank you in advance, Franz.

10-12-2007, 09:17 PM	#2
Andrew J. Kelly Guest Posts: n/a	Re: Server side redirection to another instance of SQL Server? If the connection strings are using the servername simply change the entry in DNS to point to the IP of the other instance. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "Franz Lang" <FL_FEE@newsgroup.nospam> wrote in message news:475d06fd$0$90275$... > Hi! > > SQL Server 2005 will be installed next to SQL Server 2000 which is the > default instance. > > Is it possible to have a server side redirection so that all clients will > be redirected to SQL Server 2005 instead of 2000? > > I know of client side server aliases, but then this alias has to be set on > every client. Otherwise, the connection string of all clients will have to > be adjusted :-( > > Can you give me a hint? > > Thank you in advance, > Franz.

10-12-2007, 10:37 PM	#3
Andrew J. Kelly Guest Posts: n/a	Re: Server side redirection to another instance of SQL Server? If the connection strings are using the servername simply change the entry in DNS to point to the IP of the other instance. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "Franz Lang" <FL_FEE@newsgroup.nospam> wrote in message news:475d06fd$0$90275$... > Hi! > > SQL Server 2005 will be installed next to SQL Server 2000 which is the > default instance. > > Is it possible to have a server side redirection so that all clients will > be redirected to SQL Server 2005 instead of 2000? > > I know of client side server aliases, but then this alias has to be set on > every client. Otherwise, the connection string of all clients will have to > be adjusted :-( > > Can you give me a hint? > > Thank you in advance, > Franz.

10-12-2007, 10:41 PM	#4
Franz Lang Guest Posts: n/a	Re: Server side redirection to another instance of SQL Server? Andrew J. Kelly schrieb: > If the connection strings are using the servername simply change the > entry in DNS to point to the IP of the other instance. I forgot to mention that the new instance will be installed on the same machine. Otherwise, your suggestion would have worked well.

11-12-2007, 12:11 AM	#5
Franz Lang Guest Posts: n/a	Re: Server side redirection to another instance of SQL Server? Andrew J. Kelly schrieb: > If the connection strings are using the servername simply change the > entry in DNS to point to the IP of the other instance. I forgot to mention that the new instance will be installed on the same machine. Otherwise, your suggestion would have worked well.

11-12-2007, 03:44 PM	#6
Andrew J. Kelly Guest Posts: n/a	Re: Server side redirection to another instance of SQL Server? No, not really. Each instance has an associated port number tied to it. The default for the default instance is 1433. For a named instance it is something else. If you add the port number it will point to the correct instance. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "Franz Lang" <FL_FEE@newsgroup.nospam> wrote in message news:475d645a$0$90272$... > Andrew J. Kelly schrieb: >> If the connection strings are using the servername simply change the >> entry in DNS to point to the IP of the other instance. > > I forgot to mention that the new instance will be installed on the same > machine. Otherwise, your suggestion would have worked well.

11-12-2007, 03:45 PM	#7
Andrew J. Kelly Guest Posts: n/a	Re: Server side redirection to another instance of SQL Server? No, not really. Each instance has an associated port number tied to it. The default for the default instance is 1433. For a named instance it is something else. If you add the port number it will point to the correct instance. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "Franz Lang" <FL_FEE@newsgroup.nospam> wrote in message news:475d645a$0$90272$... > Andrew J. Kelly schrieb: >> If the connection strings are using the servername simply change the >> entry in DNS to point to the IP of the other instance. > > I forgot to mention that the new instance will be installed on the same > machine. Otherwise, your suggestion would have worked well.

11-12-2007, 03:53 PM	#8
Franz Lang Guest Posts: n/a	Re: Server side redirection to another instance of SQL Server? Andrew J. Kelly schrieb: > No, not really. Each instance has an associated port number > tied to it. The default for the default instance is 1433. For > a named instance it is something else. Yes, I knew that. > If you add the port number it will point to the correct > instance. If I added the port number where? Franz.

11-12-2007, 03:54 PM	#10
Andrew J. Kelly Guest Posts: n/a	Re: Server side redirection to another instance of SQL Server? No, not really. Each instance has an associated port number tied to it. The default for the default instance is 1433. For a named instance it is something else. If you add the port number it will point to the correct instance. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "Franz Lang" <FL_FEE@newsgroup.nospam> wrote in message news:475d645a$0$90272$... > Andrew J. Kelly schrieb: >> If the connection strings are using the servername simply change the >> entry in DNS to point to the IP of the other instance. > > I forgot to mention that the new instance will be installed on the same > machine. Otherwise, your suggestion would have worked well.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

New To Site?	Need Help?
Register to Participate Meet our Staff Refer Forum Rules Contact Us	Frequently Asked Questions Did you forget your password? Mark Forums Read

Server side redirection to another instance of SQL Server?

Microsoft SQL Server