MAP documentations says that one can use existing SQL server for MAP database as long as non-default instance named MAPS is created. Also documentation mentions that instance is blocked from remote usage.
So if i have SQL server with MAPS instance with right collation order:
1. Do i have to do any tweaks (open firewall ports etc.) to be able to use external database? I mean when documentation says MAPS is blocked from remote usage does that mean that firewall blocks network traffic?
2. Can MAP be installed to separate workstation when database is located on external SQL server? When i install MAP, it by default install local database. (I remember that earlier versions there was an opportunity to download and install SQL Express and use that but thats gone. ) It doesnt mention anything about MAPS instance on Installation Requirements page. When installed MAP it doesnt show Change button under Data source so i could change to external SQL server?
When SQL server is installed on same workstation than MAP, i can switch to use MAPS instance instead of local database. What i am missing here?