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 |
|
SLM09
Starting Member
31 Posts |
 Posted - 2010-02-17 : 14:50:24
|
| Hi all,I have been playing around with the job scheduler in SSMS and have come across an issue. There are two servers, both have permission to communicate with one another. However, in a job I have created, I am getting an error when I try to run SQL that accesses the other server. The error is "Login failed for user "xyz" [SQLSTATE 28000][error 18456].The xyz that is listed is the login that was given to me by the other servers admin for access.Does something else need to be configured on the other server to allow this?Any ideas? Thanks |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-02-17 : 14:59:32
|
| how are you accessing the data? via linked server? if so, how did u configure the linked server security? is SPN set on both machines? |
 |
|
|
|
|
|
Setting a Job that requires another Server