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 |
|
mfemenel
Professor Frink
1421 Posts |
 Posted - 2003-03-06 : 09:38:02
|
| Trying to set up a server as a distributor but I'm getting an error back: "error 18483 Could not connect to server JCPW2DV01 because 'distributor_admin' is not defined as a remote login at the server" My first thought was that it was a permissions issue to the server. So, I created a local login caled distributor_admin and made it an admin to the server. Then, for SQL, I used this same login and made it SA. Yes, it's redundent, but I figured it couldn't hurt. After trying this, I still get the same problem. I'm stuck. Any help, as always, is appreciated.Mike"oh, that monkey is going to pay" |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2003-03-07 : 01:28:43
|
| Use this procedure sp_addremotelogin, to add remote login on the local server. Refer BOL for detail. Hope this will help.___________________________________________________________________________Success is not a destination that you ever reach. Success is the quality of your journey. |
 |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2003-03-07 : 08:41:29
|
| Thank you. I tried that too, but that wasn't it. Here's what the problem was. Way back in September the server was renamed from JCPNT001 to JCPW2DV01 but SQL was never updated with this new name. Once we ran sp_addserver and rebooted I went through it no problem. That was one hell of a day.Mike"oh, that monkey is going to pay" |
|
|
|
|
|
|
Basic Replication