Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-12-11 : 09:42:59
|
| Ike writes "Hi,Is there a way to link a server with a different password for SA using sp_addlinkedserver? If so, how? I use "EXEC sp_addlinkedserver @server = @linkedServer" in my TSQL (I change the server name in the variable). I tried using the "@provider" and "@provstr" parameters but I kept receiving a "Server: Msg 15429, Level 16, State 1, Procedure sp_addlinkedserver, Line 72'(null)' is an invalid product name." error. If the password is the same, I use the "EXEC sp_addlinkedserver @server = @linkedServer" with no trouble." |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2001-12-11 : 14:01:47
|
| How about EXEC sp_addlinkedserver @server = @linkedServer, @srvproduct ='SQL_SERVER', @provider = 'SQLOLEDB', @datasrc = @linkedServer, @catalog = 'mydb' |
 |
|
|
|
|
|
Linked Server using spAddLinkedServer