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 |
|
victorsj
Starting Member
4 Posts |
 Posted - 2006-03-16 : 16:37:18
|
| I was create a new replication, but when is creating the publication, I have the next error:TITLE: New Publication Wizard------------------------------SQL Server could not create publication 'Prueba1'.------------------------------ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)------------------------------'@job_login' must be a valid Windows Login in the form : 'MACHINE\Login' or 'DOMAIN\Login'. Please see the documentation for 'sp_addpublication_snapshot'.Changed database context to 'Prueba'. (Microsoft SQL Server, Error: 21797)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.1399&EvtSrc=MSSQLServer&EvtID=21797&LinkId=20476------------------------------BUTTONS:OK------------------------------ |
|
|
mblythe
Starting Member
16 Posts |
Posted - 2006-03-16 : 19:55:30
|
| When you create a publication, you specify the Windows user under which the Snapshot Agent should run. It looks like there is an issue with the account you specified. Have you tried specifying a different account, making sure the password is correct, etc.?Michael Blythe Technical WriterSQL Server Replication - Microsoft --------------------------------------------------------------------------- This posting is provided "AS IS" with no warranties, and confers no rights. |
 |
|
|
|
|
|
Replication SQl 2005