XMap 7 Fails to Install Microsoft SQL Server 2008 Express

Microsoft SQL Server 2008 is required by XMap® 7 desktop software to create databases for GIS layer storage. XMap 7 software installs Microsoft SQL Server 2008 Express R1 as a prerequisite. If this installation fails, you will not be able to create a database or import any GIS file types, such as ESRI shapefiles.

Note: XMap Software has been discontinued. Support is now provided through documentation in the Support Center. XMap data format has not.

If Microsoft SQL Server 2008 Express is not listed on your computer, or if you continually receive error messages when attempting to install it, try the following instructions:

Uninstall SQL Server 2008 Components

1. Select StartControl PanelPrograms and FeaturesUninstall a Program (Add/Remove Programs in Windows XP).
2. Select the XMap 7 instance of Microsoft SQL Server 2008 and click Uninstall/Change (Remove in XP).


3. Click Remove.


4. Select the XMAP7 instance and click Next to uninstall.

Installing Microsoft SQL Server 2008 Express R2

1. Download Microsoft SQL Server 2008 Express R2 from the following web page.  For XMap, you need the Database Only version. All other components are optional. Choose the one that matches your operating system (32- or 64-bit).
http://www.microsoft.com/download/details.aspx?id=30438

2. Launch the installation and wait for the package to extract.


3. Install the prerequisites if prompted.
4. The Installation Center will launch.  Select New installation or add feature to an existing installation.


5. Accept the license terms and click Next.


6. Install the setup support files.


7. Review the features you want to install and the directory where you want them installed to. XMap requires only the Database Engine Services and SQL Server Replication.


8. Change the instance name to XMAP7.


9. Set the Startup Type to Automatic for both the SQL Server Database Engine and the SQL Server Browser.
Note: Depending upon your user account privileges, you may not be able to install using the NT AUTHORITY\NETWORK account. If you receive an error message, try NT AUTHORITY\SYSTEM or NT AUTHORITY\LOCAL


10. Set the Authentication Mode to Mixed Mode, choose a password, and add the user who you want to be the SQL Server administrator.


11. Choose your error reporting settings.


12. The installation will begin. You will be notified if the installation completed successfully. Select close when you have finished reviewing the installation results.


Note: If the installation fails, browse to C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log and find theSummary.txt.  Please email this file to tech@delorme.com so we can troubleshoot the issue further.

After the Installation

First, install XMap, if necessary. It will skip over the SQL installation. Once XMap is installed, use the following instructions.

1. Open XMap.
2. Select the GIS tab.
3. Select Workspace.
4. Select DB Manager. The Database Manager will open.


5. If you do not see your server listed; on the toolbar, select Server, then New Connection. 


6. In the Server field, type (LOCAL)\XMAP7. Then, select Windows Authentication and select Connect. The server should now be listed in the DB Manager.


7. On the toolbar, select DatabaseNew. 


8. In the Database Name field, type in a name for your database.  Select the Schema drop-down list and choose XMAP7.  SelectOK.
 

9. Right-click on the database and select Activate.