Mobile Management For SQL Server(s!) - Siccolo

How to setup and install Siccolo Web Service: Engineered to help you extend your support from mobile devices for Microsoft SQL Servers.

You will need access to your web server (I use public domain to host Siccolo web service). You can also host it inside your LAN, but then you will need to setup and connect VPN on/from your mobile device. Create a new folder on the IIS machine (e.g. c:\inetpub\wwwwroot\SiccoloWebService) And also create a new folder "bin" under newly created folder for Siccolo web service files (e.g. c:\inetpub\wwwwroot\SiccoloWebService\bin) open IIS management console Create a new virtaul directory (or create a new web site) Optional - using SSL("HTTPS")
Under Directory Security uncheck "Enable Anonymous access" and check "Integrated Windows authentication" (if mobile device has .NET CF 2.0) or "Basic authentication" (if mobile device has .NET CF 1.0)
Copy provided .dll files into "bin" folder Copy provided .asmx files into "main" siccolo web service folder Copy provided .asax file into "main" siccolo web service folder Copy provided .config file into "main" siccolo web service folder
Two more steps: Run provided AddEventSource.exe to add SiccoloWebService as an event source Run provided siccolo_stored_procedures_for_master_database.sql on SQL Server(s) you're planning to manage
Server side requires IIS/.NET installed on web server (I use version 2.0) - get it at Microsoft: Microsoft .NET Framework Version 2.0 Redistributable

So, basically, for the server side you should have something like this: -- 1. Server - side: -- server side files: siccolo_folder_files.gif Siccolo server side setup:(IIS virtual directory points to a folder created in #1.1 above) siccolo_iis_files.gif more screenshots: siccolo_iis.gif siccolo_iis3.gif siccolo_iis4.gif test setup - open Siccolo server side web side from/on the same machine where IIS is: siccolo_web_side_browser.gif and to test it run : siccolo_test_services.gif now, if you need to also setup Siccolo web client: create a folder on IIS server (you can use same IIS machine as in Siccolo server-side setup above). For example, c:\inetpub\wwwroot\SiccoloWebClient in IIS, create a new virtual directory pointing to a folder created in #2.1 then, just open web browser, while on the same IIS machine, and point url to virtual directory created in #2.2

On the client side, under Siccolo programs folder, you my have the following config files Client side requires .NET CF 2.0 installed on mobile device - get it at Microsoft: .NET Compact Framework 2.0 Redistributable Example of client side installation:
servers.txt - list of recently used (connected) SQL Servers, For example:
siccolo.config - allows to add list of available Siccolo Web services, For example: