创建distributor遇到的问题
在命令行状态下执行如下语句准备创建distributor,
sqlcmd -S TECHADV\TECHADV2005 -U sa -P XXXXX -Q "declare @workingdir varchar(1000) create table #sqldataroot (Value sysname, Dataroot varchar(1000)) insert into #sqldataroot exec master.dbo.xp_instance_regread N'HKEY_LOCAL_MACHINE', N'SOFTWARE\Microsoft\Microsoft SQL Server\MSSQL.2\Setup', N'SQLDataRoot' select @workingdir = Dataroot + '\repldata' from #sqldataroot exec sp_adddistpublisher @publisher = 'TECHADV\TECHADV2005', @distribution_db = 'distribution' , @security_mode = 1, @working_directory = @workingdir"
遇到如下错误
(0 rows affected)
Msg 15007, Level 16, State 1, Server TECHADV\TECHADV2005, Procedure sp_addremotelogin, Line 56 'distributor_admin' is not a valid login or you do not have permission.
Msg 14075, Level 16, State 1, Server TECHADV\TECHADV2005, Procedure sp_MSrepl_adddistpublisher, Line 694 The Publisher could not be created at this time.
请问如何解决?