Very Computer

I tried everything with SQL Server CE Version 1.1 so today I installed
Version 2.0, created the virtual directory on IIS and even registered the
files sscesa20.dll and sscerp20.dll on the IIS server.

The server was restarted and a client browser on the development computer
and Pocket PC is showing the message "SQL Server CE Server Agent".  I am
using anonymous authentication for testing.

I am still getting a 28010 error occurring when the Replication Object 'Run'
Method is called in eVB code.
A previous command in my code calls the Initialize method without error.

The security of IIS, NTFS and SQL appears OK.

I am running SQL2K, IIS5.0 and Windows 2000 Server on the same server.

Has anyone had this error and have advise as to the way to solve it?

Thanks,
Adam

Hi Adam,

Enumerate all of you errors if you are not already. There may be a more
specific error under the covers.

I see this when I have permissions problems. Create a new snapshot directory
for your publication, c:\snapshot. Rerun the snapshot agent. Do not change
any ACLS on the share for now.

If that does not work, use the Connectivity Wizard to setup your virtual
directory. Choose defaults for everything and Anonymous authentication. See
if that helps.

--
Brad

This posting is provided "AS IS" with no warranties, and confers no rights.

Quote:> I tried everything with SQL Server CE Version 1.1 so today I installed
> Version 2.0, created the virtual directory on IIS and even registered the
> files sscesa20.dll and sscerp20.dll on the IIS server.

> The server was restarted and a client browser on the development computer
> and Pocket PC is showing the message "SQL Server CE Server Agent".  I am
> using anonymous authentication for testing.

> I am still getting a 28010 error occurring when the Replication Object
'Run'
> Method is called in eVB code.
> A previous command in my code calls the Initialize method without error.

> The security of IIS, NTFS and SQL appears OK.

> I am running SQL2K, IIS5.0 and Windows 2000 Server on the same server.

> Has anyone had this error and have advise as to the way to solve it?

> Thanks,
> Adam

It is the only error that is given.

I created a new snapshot directory, e:\SnapShot, It was
shared as SnapShot and the share had permissions for
everyone.  The SnapShot location in SQL was changed from
\\ServerName\ReplData to \\ServerName\SnapShot.  The
Snapshot Agent was started and it completed successfully.  
BUT I still got the same error.

I used the 'Virtual Directory Creation Wizard' to create a
new Alias to the same folder that ssce20 is placed.  I
used anonymous authentication.  That did not solve it
either.

There don't seem to be many more options?

Quote:>-----Original Message-----
>Hi Adam,

>Enumerate all of you errors if you are not already. There
may be a more
>specific error under the covers.

>I see this when I have permissions problems. Create a new
snapshot directory
>for your publication, c:\snapshot. Rerun the snapshot

agent. Do not change
development computer

Quote:>> and Pocket PC is showing the message "SQL Server CE

Server Agent".  I am

Quote:>> using anonymous authentication for testing.

>> I am still getting a 28010 error occurring when the
Replication Object
>'Run'
>> Method is called in eVB code.
>> A previous command in my code calls the Initialize

method without error.

Quote:

>> The security of IIS, NTFS and SQL appears OK.

>> I am running SQL2K, IIS5.0 and Windows 2000 Server on
the same server.

>> Has anyone had this error and have advise as to the way
to solve it?

>> Thanks,
>> Adam

>.

28010 error  is SSCE_M_CANTCOCREATERECONERROR which means that sscesa20.dll
can't cocreate the reconciler com object.
Registering  sscerp20.dll manually  on the server  is not enougth - you need
to install all the server tools on the IIS machine.

--
Gil Lapid Shafriri
SQL Server for CE

----------------------------------------------------------------------------
-------------------------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights

Quote:> I tried everything with SQL Server CE Version 1.1 so today I installed
> Version 2.0, created the virtual directory on IIS and even registered the
> files sscesa20.dll and sscerp20.dll on the IIS server.

> The server was restarted and a client browser on the development computer
> and Pocket PC is showing the message "SQL Server CE Server Agent".  I am
> using anonymous authentication for testing.

> I am still getting a 28010 error occurring when the Replication Object
'Run'
> Method is called in eVB code.
> A previous command in my code calls the Initialize method without error.

> The security of IIS, NTFS and SQL appears OK.

> I am running SQL2K, IIS5.0 and Windows 2000 Server on the same server.

> Has anyone had this error and have advise as to the way to solve it?

> Thanks,
> Adam