Register and Linked Servers

See more:

SQL-Server-2005

SQL

SQL-Server

Hi,

/*** CREATING LINKED SERVERS***/

-- drop Linked servers if exist
IF EXISTS(SELECT name FROM sys.servers
	WHERE name = N'AVSERVER\MBWIN')
	Exec sp_dropserver 'AVSERVER\MBWIN', 'droplogins'
go

IF EXISTS(SELECT name FROM sys.servers
	WHERE name = N'SWSERVER\MBWIN')
	Exec sp_dropserver 'SWSERVER\MBWIN', 'droplogins'
go

-- this will create a link with servers as specified
EXEC sp_addlinkedserver   
    @server='AVSERVER\MBWIN', 
    @srvproduct='',
    --@provider='SQLNCLI',	--'SQLOLEDB'
    @provider='SQLOLEDB',
    @datasrc='AVSERVER'

EXEC sp_addlinkedsrvlogin
    @useself='FALSE',
    @rmtsrvname='AVSERVER\MBWIN',
    @rmtuser='sa',
    @rmtpassword='mbwin'
go

PRINT 'LINKING TO SWSERVER FOR SEOUL TRANSACTIONS...'
GO

EXEC sp_addlinkedserver   
    @server='SWSERVER\MBWIN', 
    @srvproduct='',
    --@provider='SQLNCLI',   --'SQLOLEDB'
    @provider='SQLOLEDB',
    @datasrc='SWSERVER'

EXEC sp_addlinkedsrvlogin
    @useself='FALSE',
    @rmtsrvname='SWSERVER\MBWIN',
    @rmtuser='sa',
    @rmtpassword='mbwin'
go

PRINT 'LINKED SERVERS STABLISHED...'
GO

On top is my script, to stablish linked on AVSERVER and SWSERVER.
Do I still need to register in SSMS?