Page 1
Page 2
5)
Now let's configure some additional properties of this new virtual directory.
Right click the 'Northwind' directory and choose 'Properties'
Click
on the Directory Security tab and take a look at the default settings by
clicking on the 'Edit' next to the Anonymous Access to get to the
Authentication Methods dialog, followed by clicking Edit again to
see the Anonymous user account - it is usually something like IUSR_PCNAME.
If you are running IIS and the SS CE Server agent on the same PC then we can use
the default settings as shown here:
Now
let's configure the SQL Server CE Server Agent permissions - we need to configure
directory authorisation & file permissions
File
Permissions
Even though IIS authenticates the client
you still need to configure the NTFS permissions on the 'SSCESA10.DLL'.
Using Windows Explorer navigate to the virtual directory you created in
step #4 (C:\Inetpub\wwwroot\northwind) - right click the file, choose Properties
and click the Security tab. You need the following user permissions:
Administrators
- Full Control
System - Full Control
Anonymous Authentication
(the IUSR_PCNAME) identified above - Read and Execute permissions
If
you are using Integrated Windows Authentication, grant the client's user or group
read and execute permissions. Note this is not necessary if you are running IIS
and SQL 2000 on the same PC.
Directory Authorisation
Using Windows Explorer navigate to the virtual directory
that contains the file we have just set permissions on above - 'C:\Inetpub\wwwroot\northwind'
- right click the directory, choose Properties and click the Security tab. You
need the following user permissions:
Administrators
- Full Control
System - Full Control
Anonymous Authentication
(the IUSR_PCNAME) - Modify
Again if you
are using Integrated Windows Authentication, 'Modify' for the appropriate client
- not necessary if you are running IIS and SQL 2000 on the same PC
That's
it then we are done with the desktop configuration.
Previous Page