|
|
|
|||||||
| Notices |
 |
|
|
Thread Tools | Display Modes |
11-12-2007, 03:55 PM
|
#11 |
|
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, 04:03 PM
|
#12 |
|
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, 04:04 PM
|
#13 |
|
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, 04:22 PM
|
#14 |
|
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, 04:30 PM
|
#15 |
|
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, 04:38 PM
|
#16 |
|
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, 04:45 PM
|
#17 |
|
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, 05:13 PM
|
#18 |
|
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. |
|
|
|
| Thread Tools | |
| Display Modes | |
|
|
< Windows Help - MS Office Help - Hardware Support >
| New To Site? | Need Help? |
Linear Mode
