1

Topic: To rename a linked server

It was replaced DNS a linked server. How to create new with a name of the old?

2

Re: To rename a linked server

waszkiewicz;
with DROP CREATE. To change that it is necessary

3

Re: To rename a linked server

in that if server SQL Sserver type that name is selected will be also network name. And such server already is not present. And his name is registered in thuja  requests

4

Re: To rename a linked server

waszkiewicz wrote:

  that if server SQL Sserver type that name is selected will be also network name. And such server already is not present. And his name is registered in thuja  requests

hosts

5

Re: To rename a linked server

6

Re: To rename a linked server

TaPaK wrote:

it is passed...
hosts

Garbage-with.

waszkiewicz wrote:

  that if server SQL Sserver type that name is selected will be also network name. And such server already is not present. And his name is registered in thuja  requests

And you be not lazy. Write a line of connection.

7

Re: To rename a linked server

waszkiewicz wrote:

  that if server SQL Sserver type that name is selected will be also network name. And such server already is not present. And his name is registered in thuja  requests

Well so do not select "server SQL Sserver type".
Register the necessary version of the provider and an old name.
And the present address of the new server (well or its name present)

EXEC master.dbo.sp_addlinkedserver
@server = N'imja_kakoe_nado ';
@srvproduct=N'chto_ugodno ',
@provider=N'SQLNCLI11 ',
@datasrc=N'real_server_address, port ' - or pc\inst_name

8

Re: To rename a linked server

aleks222 wrote:

it is passed...
Garbage-with.
it is passed...
And you be not lazy. Write a line of connection.

And in what a garbage? It is possible to explain with deep arguments?

9

Re: To rename a linked server

waszkiewicz wrote:

  that if server SQL Sserver type that name is selected will be also network name. And such server already is not present. And his name is registered in thuja  requests

by Pechalka, as usual, in unwillingness to think and, as consequence of it, in a spelling .
If from the very beginning made for a linked server a synonym would not have similar problems generally.

10

Re: To rename a linked server

invm,
And where this synonym can be created?

11

Re: To rename a linked server

waszkiewicz;
And, litter, a synonym essence of a DB.

12

Re: To rename a linked server

waszkiewicz wrote:

invm,
And where this synonym can be created?

In DNS generally

13

Re: To rename a linked server

wtf, at what here DNS. If someone renamed old, simply add on the same IP an old name on DNS the server.