Monday, March 04, 2013 4:41 AM
I'm trying to share a Windows 7 workstation which has the MAP toolkit v8 installed with another user.
I've successfully installed and used the MAP toolkit as "DOMAIN\userA".
However, when user "DOMAIN\userB" logs onto the workstation and launches the tool, elevated, they get this error:
I'm not expecting "userB" to have access to the localDB databases created by "userA", since they will make their own databases to use.
Monday, March 04, 2013 7:51 AM
Following the advice in the error message I asked "userB" to run the installer and perform the repair as suggested.
This appeared to work and allowed both userA and userB to launch the application.
I'm expecting the same problem to re-occur when userC wants to use the application, I guess each different user will be required to perform a repair install before they can launch the application.
Tuesday, March 05, 2013 1:44 AM
Your suspicion would be correct. By default, the MAP Toolkit will install SQL Server 2012 Express LocalDB during setup. As LocalDB is specific to the user account that installed it, You will only be able to run it from the initial account that did the installation. The repair process is actually placing LocalDB on the second user accuont and creating a new instance for MAP to reference.
You may use an existing (or new) installation of SQL Server 2008, SQL Server 2008 R2, or SQL Server 2012 if you create an instance named "MAPS" before running the MAP Toolkit installer. The MAP Toolkit requires the collation order of the database engine to be set to "SQL_Latin1_General_CP1_CI_AS". Doing this will allow multiple user accounts to use MAP and share databases.
Tuesday, March 05, 2013 8:22 AM
Thanks Michael, I used your advice and solved the problem as follows:
1. exported all the databases we wanted to keep. (this creates SQL backup .bak files)
2. uninstalled the MAP tool from the PC.
3. uninstalled SQL 2012 localDB.
4. installed SQL 2012 with SP1 express with tools, then CU2, being careful to name the instance "MAPS" as per your tip.
5. installed the MAP tool, which curiously didn't ask which database we wanted to use and used the MAPS instance from the previous step.
6. launched MAP and imported the databases we wanted to use. (this performed a SQL restore of the .bak files).
7. used SQL studio full edition (feature of SP1 express) and tweaked each database by setting auto-close to false, which makes the MAP tool start and operate faster.