MS SQLCE - Configuring SQL Server CE 2.0 RDA and IIS 6.0

Author

Configuring SQL Server CE 2.0 RDA and IIS 6.0

MMMV

2005-09-30, 11:23 am

Configuring SQL Server CE 2.0 RDA and IIS 6.0

Hi,

Is there somebody who can helpme with this?

I can not configure successfully SQL Server CE Agent (sscesa20.dll) on
windows 2003 server. Both,Sql Server 2000 SP3a and IIS 6.0, are
installed on same computer. I installed SQL Server tools successfully
(sqlce20sql2ksp3a.exe compatible with SQL Server 2000 SP3a) on path
c:\program files\Microsoft SQL Server CE 2.0\server.

I create ssce folder inside c:\inetpub and copy in the files
sscesa20.dll from c:\program files\Microsoft SQL Server CE 2.0\server
and sscerelay.exe from C:\Archivos de programa\Microsoft SQL Server CE
2=2E0\Relay (this file is copied from my own computer where i installed
SQL Server CE Client).

Then I set the security properties for ssce folder and sscesa20.dll
file (adding IUSR_...(Read&Execute, List folder content,Read,
Write),SERVICE (full access), SYSTEM (full access) and Administrators
(full access) users). After that I create virtual directory in IIS 6.0
manager:

=B7 Alias: ssce
=B7 Path: c:\inetpub\ssce
=B7 Enabled Anonimous Access
=B7 Enabled Execute (such as ISAPI application or CGI)

until this point all is wonderfull, but when i tried "http://<IP
SERVER>/ssce/sscesa.dll" in IE, the following message error is
displayed:

"Cannot be found the page..."

The response for success tried must be:

"SQL Server CE Agent"

Thanks in advance

Manuel Mons=E1lvez V.

Darren Shaffer

2005-09-30, 8:23 pm

your IIS virtual directory must have permissions for
Scripts & Executables. RDA does work with SQL
Server 2000 SP3 and Sql CE - you just have a configuration
issue.

--
Darren Shaffer
..NET Compact Framework MVP
Principal Architect
Connected Innovation
www.connectedinnovation.com

"MMMV" <manuel.monsalvez@gmail.com> wrote in message
news:1128096036.776750.40060@g49g2000cwa.googlegroups.com...
Configuring SQL Server CE 2.0 RDA and IIS 6.0

Hi,

Is there somebody who can helpme with this?

I can not configure successfully SQL Server CE Agent (sscesa20.dll) on
windows 2003 server. Both,Sql Server 2000 SP3a and IIS 6.0, are
installed on same computer. I installed SQL Server tools successfully
(sqlce20sql2ksp3a.exe compatible with SQL Server 2000 SP3a) on path
c:\program files\Microsoft SQL Server CE 2.0\server.

I create ssce folder inside c:\inetpub and copy in the files
sscesa20.dll from c:\program files\Microsoft SQL Server CE 2.0\server
and sscerelay.exe from C:\Archivos de programa\Microsoft SQL Server CE
2.0\Relay (this file is copied from my own computer where i installed
SQL Server CE Client).

Then I set the security properties for ssce folder and sscesa20.dll
file (adding IUSR_...(Read&Execute, List folder content,Read,
Write),SERVICE (full access), SYSTEM (full access) and Administrators
(full access) users). After that I create virtual directory in IIS 6.0
manager:

· Alias: ssce
· Path: c:\inetpub\ssce
· Enabled Anonimous Access
· Enabled Execute (such as ISAPI application or CGI)

until this point all is wonderfull, but when i tried "http://<IP
SERVER>/ssce/sscesa.dll" in IE, the following message error is
displayed:

"Cannot be found the page..."

The response for success tried must be:

"SQL Server CE Agent"

Thanks in advance

Manuel Monsálvez V.

MMMV

2005-09-30, 8:23 pm

Yes, I set IIS virtual directory permissions for
Scripts & Executables, but it does not work yet.

Have you got any other idea?

The machine have windows 2003 server, it seems many security properties
changed from windows 2000 server.

Manuel Monsalvez.

Darren Shaffer ha escrito:

> your IIS virtual directory must have permissions for
> Scripts & Executables. RDA does work with SQL
> Server 2000 SP3 and Sql CE - you just have a configuration
> issue.
>
> --
> Darren Shaffer
> .NET Compact Framework MVP
> Principal Architect
> Connected Innovation
> www.connectedinnovation.com
>
>
> "MMMV" <manuel.monsalvez@gmail.com> wrote in message
> news:1128096036.776750.40060@g49g2000cwa.googlegroups.com...
> Configuring SQL Server CE 2.0 RDA and IIS 6.0
>
> Hi,
>
> Is there somebody who can helpme with this?
>
> I can not configure successfully SQL Server CE Agent (sscesa20.dll) on
> windows 2003 server. Both,Sql Server 2000 SP3a and IIS 6.0, are
> installed on same computer. I installed SQL Server tools successfully
> (sqlce20sql2ksp3a.exe compatible with SQL Server 2000 SP3a) on path
> c:\program files\Microsoft SQL Server CE 2.0\server.
>
> I create ssce folder inside c:\inetpub and copy in the files
> sscesa20.dll from c:\program files\Microsoft SQL Server CE 2.0\server
> and sscerelay.exe from C:\Archivos de programa\Microsoft SQL Server CE
> 2.0\Relay (this file is copied from my own computer where i installed
> SQL Server CE Client).
>
> Then I set the security properties for ssce folder and sscesa20.dll
> file (adding IUSR_...(Read&Execute, List folder content,Read,
> Write),SERVICE (full access), SYSTEM (full access) and Administrators
> (full access) users). After that I create virtual directory in IIS 6.0
> manager:
>
> =B7 Alias: ssce
> =B7 Path: c:\inetpub\ssce
> =B7 Enabled Anonimous Access
> =B7 Enabled Execute (such as ISAPI application or CGI)
>
> until this point all is wonderfull, but when i tried "http://<IP
> SERVER>/ssce/sscesa.dll" in IE, the following message error is
> displayed:
>
> "Cannot be found the page..."
>
> The response for success tried must be:
>
> "SQL Server CE Agent"
>=20
>=20
> Thanks in advance
>=20
> Manuel Mons=E1lvez V.

Ola Ekelund

2005-10-27, 7:52 am

>The machine have windows 2003 server, it seems many security properties

Yes, IIS 6 on Win 2003 have some different security settings, since I'm not
sitting on a Win 2003 server right now I can't guide you but as far is I
remember there is some right click and something about security per
application/virtual directory. And then you point out the ISAPI dll and
something with allow.

Little fuzzy but maybe a clue.

--
Ola Ekelund
SoftConsult SWEDEN

MMMV

2005-10-27, 7:52 am

Thanks Ola.

I solved the problem. I formatted the Hard Disc, and reinstalled
Windows 2003 Server, SP1 para windows 2003 server, IIS 6.0, SQL Server
2000, SP3a para SQL server 2000, SQL Server CE tools, in that order. I
not installed the Active directory service (probably here was the
problem). The first time than I installed windows server 2003 the
installation program cannot found some files. The second time, I used
another CD disc for won server 2003.

Manuel Mons=E1lvez V.

Ola Ekelund ha escrito:

>
> Yes, IIS 6 on Win 2003 have some different security settings, since I'm n=
ot
> sitting on a Win 2003 server right now I can't guide you but as far is I
> remember there is some right click and something about security per
> application/virtual directory. And then you point out the ISAPI dll and
> something with allow.
>
> Little fuzzy but maybe a clue.
>=20
>=20
> --=20
> Ola Ekelund
> SoftConsult SWEDEN

Sponsored Links