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 |
|
bsteelio
Starting Member
3 Posts |
 Posted - 2008-05-09 : 15:06:03
|
| Hi All, I am calling a stored proc through a job that calls a second stored proc on a different server. Replication is setup between the two servers, both systems are set in Mixed auth mode and both server services start using the same domain account. The problem is the job fails calling the second stored proc with this message:Login failed for user 'Administrator'. [SQLSTATE 28000] (Error 18456). The step failed.I get the same message regardless of the user set to run the job or how I configure the Remote Server options. (Not using Linked Servers due to Replication setup prior to my up and commance. If that matters.)Any ideas? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-09 : 15:54:13
|
| Might work with Linked server |
 |
|
|
bsteelio
Starting Member
3 Posts |
Posted - 2008-05-09 : 16:24:27
|
| Thanks for the reply! However, since the Remote Server connection was established with replication, I get an "Already Exists" when trying to add it as a Link Server and a "Can not be deleted" when trying to delete it as a Remote Server. It appears to be permissions related but changing the Remote Login Name\Local Login Name does not appear to change a thing except to break the replication. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-05-09 : 16:29:22
|
| You can still use a linked server, just use an alias name instead. You might also try an openquery since you can specify the credentials in the query. You should try SQL authentication just in case.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Database maintenance routines:http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx |
|
|
|
bsteelio
Starting Member
3 Posts |
Posted - 2008-05-09 : 17:54:50
|
| I never thought about an alias but that did it! Thanks! |
|
|
|
|
|
|
Querying a remote server with replication