Re: distributor_admin Issue....But different than normal
- From: "Joseph" <josephsheppard@xxxxxxxxx>
- Date: 15 Jan 2007 14:10:14 -0800
Thanks, Hilary...There certainly was a difference...
I followed your instructions, and I'm going to take another stab at
setting distribution up.
You are the man! I'm going to have my boss order your book....
-Joseph
Hilary Cotter wrote:
What happens when you do a select @@servername?
Does it match what you get when you issue a xp_cmdshell 'hostname'?
if not you need to do the following
sp_dropserver @server='oldServername'
sp_addserver @server='NewServerName', @local='LOCAL'
Then restart SQL Server.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Joseph" <josephsheppard@xxxxxxxxx> wrote in message
news:1168894392.883101.309200@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I am having the common "distributor_admin does not exist" error when
trying to set up a machine as its own distributor. (First time after
setting up about 200 distributors). I get this whether I'm doing it
remotely, or on the machine itself.
The wrinkle is that the login "distributor_admin" does not exist at all
on the potential publisher (who, again, is going to be its own
distributor).
Do I need to reinstall MS-SQL to get that login created? Or can I do
it by hand somehow?
Or am I barking up the wrong tree?
Thank you!
-Joseph
.
- References:
- distributor_admin Issue....But different than normal
- From: Joseph
- Re: distributor_admin Issue....But different than normal
- From: Hilary Cotter
- distributor_admin Issue....But different than normal
- Prev by Date: Re: distributor_admin Issue....But different than normal
- Next by Date: Snapshot frequency
- Previous by thread: Re: distributor_admin Issue....But different than normal
- Next by thread: Snapshot frequency
- Index(es):
Relevant Pages
|
