August 23, 2006 at 3:14 pm
I'm using the Configure Publishing and Distrub Wizard for our inhouse server. First it warns me that I shouldn't use the system account to configure the server as a publisher. Then it continues through to the Sql Agent Properties screen where it shows me two checkboxes for either the "System Account" or "This Account" option.
Once I choose "This Account", I then enter a valid login account. At that point I get a nasty error which states :
"no mapping between account names and security ids was done"
So far I can't figure out how to get past this. Any advice for this ?
Thank you,
Bob
August 23, 2006 at 3:28 pm
Create a domain account that is also a local admin on the server and use that account.
******************
Dinakar Nethi
Life is short. Enjoy it.
******************
August 24, 2006 at 9:58 am
Thanks Dinakar. I created admin user "Replication" on the Win 2k server ("tms_server"), then created the user in Enterprise Manager as "TMS_SERVER\Replication". I was then able to get past the initial user config error.
Unfortunately, I now get an error as I click on "Finish" in the publisher wizard. The error is :
"Sql...could not configure 'TMS_SERVER' as the Distributor 'TMS_SERVER'.
"Error 18483: Could not connect to server 'TMS_SERVER' because 'distributor_admin' is not defined as a remote login at the server."
Now, I'll inspect the Win 2k server and see if I can reconfigure the "Replication" user as a remote login. I'm a little confused here as to why this is so difficult to configure replication.
As a side-note, does the following SnapShot folder default appear to be a problem ?
\\TMS_SERVER\E$\Program Files\Microsoft SQL Server\MSSQL\ReplData
Thanks again for your assistance.
Bob
August 24, 2006 at 10:46 am
make sure there is enough diskspace in that folder as it can get filled up prety quickly sometimes, especially when you reinitialize or add a new article etc.
also, the user needs to be the sysadmin on the server.
******************
Dinakar Nethi
Life is short. Enjoy it.
******************
August 24, 2006 at 11:11 am
Disk space looks fine.
I already made TMS_SERVER\Replication part of the Admin group on my Win 2k server. Is that the user you're referring to ?
Do I need to add "distributor_admin" as a user ? I don't actually see that user on the server.
Thanks,
Bob
August 24, 2006 at 5:27 pm
when you configure distribution on the node it will add the distribution_admin user for you.
******************
Dinakar Nethi
Life is short. Enjoy it.
******************
August 25, 2006 at 12:59 am
Hi,
Check the following
a. Register the server using the named-pipes (client network library) and try using the replication wizard.
b. Check whether an entry for the local server exist in sysservers table in the master database with server id=0 and name as server name
rangark.
August 25, 2006 at 1:58 pm
I tried the first suggestion, but named pipes is already enabled.
On the 2nd suggestion, I noticed that in master..sysservers my server 'TMS_SERVER' is NOT listed ! The server that is listed is :
srvid srvname
0 TMS_SERVER2
Why is TMS_SERVER2 listed when it should be named TMS_SERVER (without the "2") ? How do I changed that ? Do I update the master database ?
Thanks,
Bob
August 25, 2006 at 6:56 pm
1.You should use name pipes (SqL Server Registration - Client setup) for setting up the replication process
2. If you don't see the required values. You can go and update the values in the sysservers.
rangark
August 29, 2006 at 2:09 pm
For the first suggestion, I would need more specific steps.
For the second suggestion, when I try and update the srvname column of sysservers I get :
Server: Msg 259, Level 16, State 2, Line 1
Ad hoc updates to system catalogs are not enabled. The system administrator must reconfigure SQL Server to allow this.
August 29, 2006 at 10:04 pm
First Suggestion
On the SQL Server Client , register the server used named pipes -server name instead of using IP to connect to the server. After this ,use the wizard to setup the replication process.
Second suggestion.--further steps
1. Sp_dropserver ‘localservername’,’droplogins’
2. Add the local server back to the list by running the code
Sp_addserver ‘localservername’,’local’
rangark
September 23, 2007 at 5:27 am
Please give breif..if anyone knows about it
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply