Re: manual installation of sqlce server agent on iis 6.0
From: Kevin Collins \(MS - SQL Mobile\) (kevincol_at_online.microsoft.com)
Date: 09/15/04
- Next message: Kevin Collins \(MS - SQL Mobile\): "Re: SQL SQL Server 2005 Mobile Edition Web Cast..."
- Previous message: Helen Warn: "RE: SQL SQL Server 2005 Mobile Edition Web Cast..."
- In reply to: Kevin Collins \(MS - SQL Mobile\): "Re: manual installation of sqlce server agent on iis 6.0"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 15 Sep 2004 12:25:03 -0700
Here you go...
Configuring IIS Manually for Replication and RDA
Configuring Microsoft® Internet Information Services (IIS) for either
replication or RDA involves the following steps:
1.. Create a virtual directory using IIS:
1.. Specify an alias name for the virtual directory.
2.. Specify the location for the content folder for the virtual
directory. A copy of the SQL Server CE 2.0 Agent (sscesa20.dll) must reside
in this directory.
Note:
The name of the computer running IIS, the virtual directory, and the
SQL Server CE v2.0 Agent (sscesa20.dll) must be specified as part of the
InternetURL property for connectivity. For example, the following URL
accesses SQL Server CE Agent for replication or RDA:
http://www.northwindtraders.com/sqlce/sscesa20.dll
Note:
For IIS 6.0 (Windows 2003 Server), you add the SQL Server CE 2.0 Agent
as a Web Service Extension and set it to Allowed
1.. Configure IIS authentication using IIS. Edit the properties of the
virtual directory created in Step 1. SQL Server CE supports provides three
authentication options:
a.. Anonymous access
b.. Basic authentication
c.. Integrated Windows authentication
2.. Configure IIS authorization using Windows Explorer.
Note:
If the computer running IIS has a FAT file system, you can skip this
step. SQL Server CE replication or RDA works with a FAT file system, but it
is not secure. It is recommended that you use NTFS.
"Kevin Collins (MS - SQL Mobile)" <kevincol@online.microsoft.com> wrote in
message news:e7SmgB1mEHA.2612@TK2MSFTNGP15.phx.gbl...
> We don't have official documentation on this as it is all done in the MMC
> plug-in.
>
> Let me try to remember what I had to do before the plug in was available
> and
> get back to you.
>
>
> "Tony" <nospam> wrote in message
> news:OewmekvmEHA.1692@TK2MSFTNGP10.phx.gbl...
>> Thank you,
>> but I can't run the SQL Server CE MMC plugin because I need an automated
>> installation process for customers.
>> I tried to add the SQL CE ISAPI.DLL to IIS 6.0, but with no success. Is
>> there any manual how to do that? thanks.
>>
>>
>> "Kevin Collins (MS - SQL Mobile)" <kevincol@online.microsoft.com> wrote
>> in
>> message news:OtP0ysbmEHA.3868@TK2MSFTNGP11.phx.gbl...
>>> You should really use the automated installation to do the installation
>>> on Win2003. The reason that you are seeing this problem is because
>>> Win2003 restricts ISAPI.DLL's. You have to manually go into IIS 6.0 and
>>> add the SQL CE ISAPI.DLL to get this to work.
>>>
>>> The easiest way to is to run the SQL Server CE MMC plug in to create the
>>> virtual directory and everything will be done in a secure manner.
>>>
>>>
>>> "Tony" <Tony@discussions.microsoft.com> wrote in message
>>> news:CA6DB540-77BD-4529-A4F0-BA0B33E0E989@microsoft.com...
>>>> Hi, I use a manual installation of the sql ce server agent. On iis 5.1
>>>> it
>>>> works properly. But on a win 2003 server machine I can't access the
>>>> sscesa20.dll. I think, I have to allow the isapi dll to run. when I
>>>> allow
>>>> "All unknown ISAPI Extensions" on the Web Service Extensions Settings,
>>>> it
>>>> works. But this opens Security holes. Is there a way to allow the
>>>> specifig
>>>> isapi dll to run? thanks.
>>>
>>>
>>
>>
>
>
begin 666 note.gif
M1TE&.#EA"@`*`+,)`/\$`/]=6L;#QM;3UO_/`(2&A(R.C ```/__SO___P``
M`````````````````````"'Y! $```D`+ `````*``H```0HT,@Y1 `&Z7T(
AWEIW)!E'C.16G$.2(L-1((5;%D-H@_H+HH>@,.B*```[
`
end
- Next message: Kevin Collins \(MS - SQL Mobile\): "Re: SQL SQL Server 2005 Mobile Edition Web Cast..."
- Previous message: Helen Warn: "RE: SQL SQL Server 2005 Mobile Edition Web Cast..."
- In reply to: Kevin Collins \(MS - SQL Mobile\): "Re: manual installation of sqlce server agent on iis 6.0"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
