Re: linked server to another SQL SERVER via an aliased name
From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 10/14/05
- Next message: Jasper Smith: "Re: Questions creating new database role"
- Previous message: Jasper Smith: "Re: Sql-authentication and Query Analyser/EM"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 14 Oct 2005 20:03:45 +0100
If you specify @srvproduct='SQL Server' then this message is correct however
you can still use an alias by setting up a client alias on the server using
the Client Network Utility (Start>Run>cliconfg). You can then use that as
the @server parameter.
-- HTH Jasper Smith (SQL Server MVP) http://www.sqldbatips.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "kevin" <kevin@discussions.microsoft.com> wrote in message news:8BF766F9-71DB-4D8D-97B0-DF81FF2F37BC@microsoft.com... > using SqlServer 2K > I want to create a linked server to another SQL SERVER 2K box, but I do > not > want to use the actual server name as @server as this is dev and I have no > idea what the final server name will be. I would prefer to use an alias > thus > making my SP portable. > > per BOL(Transact-SQL Reference - System Store Procedures - > sp_addlinkedserver) I should be able to do this and even copied this from > example A2, somewhat :). > > Can I do this, or is BOL a big fat lier? > > This > EXEC sp_addlinkedserver > @server='TP4', > @srvproduct='SQL Server', > @provider = 'SQLOLEDB', > @datasrc = 'LV3KDEV02', > @catalog = 'TruePayV3_0_Migration' > returns this error > Server: Msg 15428, Level 16, State 1, Procedure sp_addlinkedserver, Line > 67 > You cannot specify a provider or any properties for product 'SQL Server'.
- Next message: Jasper Smith: "Re: Questions creating new database role"
- Previous message: Jasper Smith: "Re: Sql-authentication and Query Analyser/EM"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
