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 |
|
dlcollison
Starting Member
8 Posts |
 Posted - 2007-01-30 : 15:19:31
|
| Hi All ...I have been following the MS on-line tutorials to get replication setup between SQL Server 2005 and SQL Server Compact Edition. I get to the point where I run the Configure Web Synchronization and it is running through the process where it is doing the automated configuration of the shared directory - assigning users etc.I have attempted this step with a user account that I expressly created for snapshots and with the Administrator account and get the following error message:* The operation completed successfully. (Exception from HRESULT: 0x80070000)At first, I thought this was a rights issue due to the fact that I was using an account that I manually created. However, by using the Administrator account (test only until I can figure this out) that should have removed any rights issues associated with accessing the shared directory where the snapshot will reside.Any help in getting this figured out will be greatly appreciated.David L. Collison Any day above ground is a good day! |
|
|
MohammedU
Posting Yak Master
145 Posts |
|
|
dlcollison
Starting Member
8 Posts |
Posted - 2007-01-31 : 10:29:25
|
| I setup the account as Sysadmin as indicated in the link that you provided and still end up receiving the same error.I have also attempted the following: 1. I have disabled Publishing and Distribution for the database and then reconfigured. 2. I have dropped the Snapshot Agent. 3. I have dropped and recreated the virtual folder off the Default Web Site. 4. I have switched between the Administrator account and a specific account I created to manage activity on the snapshots. 5. I have switched between the DB SA account and a specific DB account that I created to manage activity on the snapshots. 6. I have modified the rights of the DOMAIN Users Administrator and the specific account I created to have "Full Control" rights to the snapshot directory and to the virtual directory. 7. I have modified the DB rights of the DB users to have db_owner, db_datareader, db_datawriter. 8. I have attempted to manually create the virtual directory and assign the appropriate rights to the user and then run the Wizard and no luck.Whatever I try I continue to get the error:The operation completed successfully. (Exception from HRESULT: 0x80070000)(mscorlib)I don't know how anyone else has gotten this to work, but if they could shed some light on the subject I would greatly appreciate.David L. Collison Any day above ground is a good day! |
 |
|
|
Rauken
Posting Yak Master
108 Posts |
Posted - 2007-02-07 : 09:54:20
|
| What kind of replication are you setting up? |
|
|
|
dlcollison
Starting Member
8 Posts |
Posted - 2007-02-07 : 12:13:43
|
| Rauken ...I'm attempting to replicate data between SQL Server 2005 running on Win 2003 Server and SQL Server 2005 Compact Edition that will be loaded on a handheld. Several tables/fields need to be replicated for use on the handheld where information will be added/updated and then needs to sync back to the server database.I'm stuck on the step where I need to setup IIS for Merge Replication based on the MS Library article msdn2.microsoft.com/en-us/library/bb226707.aspx. I walk through the wizard and hit the button to complete the wizard. The Wizard then attempts to run through several steps to setup the share via IIS and fails with the error message given in my 1st post.David L. Collison Any day above ground is a good day! |
|
|
|
dlcollison
Starting Member
8 Posts |
Posted - 2007-02-12 : 09:53:59
|
| Folks ...I finally ended up initiating an incident with Microsoft on this issue and have found a resolution to the problem.1) You must create a Network share - I was forced to use the NET SHARE command from a Command Prompt - for whatever reason, the system would not recognize the share created via Windows.2) Next, during the Wizard, you get to the screen labeld "Snapshot Share Access". In this window, I had browsed to the physical directory directory where the snapshot exists - THIS IS NOT VALID (note to MS - remove the Browse function). Here, you must enter the share created in the previous step - \\ComputerName\ShareNameThe wizard then completes normally.Side note, during all of this, MS tech support had me delete the Snapshot and recreate the snapshot. Once I deleted the snapshot and was attempting to recreate the snapshot, I began receiving errors that certain system tables did not exist. I was forced to manually remove the replication functionality by opening SQL Server Management Studio and executing the following:1) USE <dbName>2) EXEC sp_removedbreplication '<dbName>'I was then able to recreate the snapshot.Hope this helps others out who are having similar issues.David L. Collison Any day above ground is a good day! |
|
|
|
|
|
|
|
|
Help - Replication SQL 2005 -> Compact Edition