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 |
|
purisqlserver
Yak Posting Veteran
73 Posts |
 Posted - 2002-01-20 : 23:32:56
|
| Hi,I have set up a publisher and subscriber on two different systems for transactional replication with windows 2000 and sqlserver 2000.The configuration of publisher and subscriber is fine, the database for replication is shown on subscriber with only system tables. On performing a snapshot on the publisher, the following error is shown-" The specificed @job-id(some number) is not found".what could be error??????Thanx in advance.... |
|
|
JamesH
Posting Yak Master
149 Posts |
Posted - 2002-01-21 : 08:27:31
|
| Did you by chance un-subscribe the publication? Look under SQLJobs and see if the snapshot Agent still exists if you unsubscibed, it may have removed your agent. If so, unsubscribe all publications for that subscriber then try re-subscribing to your publisher.Hope this helps,JamesH. |
 |
|
|
purisqlserver
Yak Posting Veteran
73 Posts |
Posted - 2002-01-21 : 09:03:16
|
| Now, the error is not coming up, but the snap shot is never getting started whatsoever.In sqljobs, the snapshot has the status failed.?????? |
|
|
|
JamesH
Posting Yak Master
149 Posts |
Posted - 2002-01-21 : 09:09:19
|
| What's the error in the history (expanded view) and the event log? JamesH. |
|
|
|
purisqlserver
Yak Posting Veteran
73 Posts |
Posted - 2002-01-22 : 00:17:36
|
| The error in job history was......"The job failed. Unable to determine if the owner (DOMAIN\naveen) of job TECH-7-Northwind-Northwindp-TECH-7-NWR-06D136F0-325F-4653-B9F8-58F6A5D7EFD3 has server access (reason: Could not obtain information about Windows NT group/user 'DOMAIN\naveen'. [SQLSTATE 42000] (Error 8198))."we changed the authentication to sa, the replication is working fine.Thanx a lot. |
|
|
|
|
|
|
Replication-eerror