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 - 2005-08-03 : 08:04:03
|
| Junk writes "I tried to execute a remote stored procedure with 'exec sysname.databasename.owner.storedprocname'. Initially I added remote server with sp_addlinkedserver option. It got added in sysserver table. After this when i tried to execute the procedure it said 'Login faile for user ....'. Since in my system sql server authenticates with a different username,password and in the remote system there is a different username,password. Please let me know how to resolve this." |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-08-03 : 15:07:34
|
| Welcome to SQLTeam Junk ... "Junk"?Errrmmm ... couldn't you be bothered with a proper name for the question form in return for me allocating time to answer from my extremely busy schedule?You can use a SQL Login for the remote database as part of configuring a Linked Server (but if you do this ALL queries that use the Linked Server will use the configured login, rather than a user-specific login),Hopefully that will solve the problemKristen |
 |
|
|
|
|
|
Executing remote stored procedure