SQLSERVER创建连接服务器

EXEC master.dbo.sp_addlinkedserver @server = N'192.168.2.2',
                                   @srvproduct = N'sqlserver',
                                   @provider = N'MSDASQL',
                                   @provstr = N'DRIVER={SQL Server Native Client 10.0};SERVER=192.168.2.2;'

EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname = N'192.168.2.2',--链接服务器名称
                                     @useself = N'FALSE',
                                     @locallogin = NULL,
                                     @rmtuser = N'sa',
                                     @rmtpassword = '123'

GO


EXEC sp_linkedservers;
--EXEC sp_dropserver '192.168.2.2'

posted on 2024-10-16 10:01 RookieBoy666 阅读(15) 评论(0) 编辑收藏举报