Showing posts with label connect. Show all posts
Showing posts with label connect. Show all posts

Monday, March 12, 2012

replication 18483 eroor

hi all...
I have a little problem.
"18483 - could not connect to server 'Newname' because distributor_admin is
not defined as a remote login at the server."
Mehmet,
Try (using 'Newname')
Use Master
go
Select @.@.Servername
This should return your current server name but if it
returns NULL then try:
Use Master
go
Sp_DropServer 'OldName'
GO
Use Master
go
Sp_Addserver 'NewName', 'local'
GO
Stop and Start SQL Services
If this is not the solution, please let me know if you are using IP
addresses for registered servers in Enterprise Manager.
Cheers,
Paul Ibison SQL Server MVP, www.replicationanswers.com
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)

Saturday, February 25, 2012

Replicating users and privileges...

Hi,
In my publisher database I have defined an user with restricted privileges.
This user is "used" by the user interface application to connect to the
database. How can I replicate this user and restrictions to the subscriber?
Should I script this on a post-snapshot script? Is any other automatic
solution?
Thanks in advance
Faustino Dina
If my email address starts with two 'f'
drop the first 'f' when mailing me.
Faustino,
there's no automatic solution for this, as we can't replicate system tables.
You could use :
a pre-snapshot script,
a post-snapshot script,
sp_addscriptexec,
DTS,
linked servers.
HTH,
Paul Ibison
(recommended sql server 2000 replication book:
http://www.nwsu.com/0974973602p.html)