> ## Documentation Index
> Fetch the complete documentation index at: https://docs.superoffice.com/llms.txt
> Use this file to discover all available pages before exploring further.

# MS SQL Express as Travel database

> MSDE / SQL express as travel database

## Prerequisites

Client computers must install MS SQL Express depending on what kind of [central database][1]. Run it, reboot, and observe the small SQL Server icon with a small green triangle in the taskbar.

## Automatic setup

As long as the Central database has set up MS SQL Express as the Local datatype, everything is automatically set up for the user who has been [assigned travel rights in SOAdmin][2]. The central *SuperOffice.ini* file has the information so SOLoader.exe sets up the local datasource and adds the **ProtoServerPath** and **ProtoClientPath** to the local *SuperOffice.ini*.

As long as the user has been assigned travel rights in SuperOffice Admin and an [update prototype][1] has been generated, the user may now perform a local update by clicking the Travel icon in the navigator: ![travel icon -screenshot][img1].

As long as you are logging in to the local database on Travel, the icon will look like this: ![travel open -screenshot][img2]

[1]: ../update-prototype

[img1]: /media/loc/en/onsite/travelicon.jpg

[img2]: /media/loc/en/onsite/travelopen.jpg

## Manual setup

Default paths set up automatically are:

```text theme={null}
local_archivepath=C:\Documents and Settings\USER\Local Settings\Application Data\SuperOffice\SO_LOCAL
Local_Datapath=ODBC:SuperOfficeLocal
```

If you want to change the location of the local document archive, you need to edit the users' *SuperOffice.ini* file. You may change the name of the datasource as long as you also change the `Local_Datapath=ODBC:XXX` where XXX needs to be the new name of the local datasource.

MS SQL Express requires `ProtoClientPath` (and `ProtoServerPath`) set. If the client is not going to make a prototype, you only need to add `ProtoClientPath=` under the **SuperOffice** section in *SuperOffice.ini*.

[1]: ../index

[2]: ../activate


## Related topics

- [Travel](/en/onsite/travel/index.md)
- [Create prototype for MS SQL Express](/en/onsite/travel/sql-express/create-prototype.md)
- [Activate travel](/en/onsite/travel/activate.md)
- [Client requirements for SuperOffice Web and Win](/en/onsite/requirements/web-client.md)
- [Compatibility reports](/en/onsite/compatibility/index.md)
- [SuperOffice.ini](/en/onsite/install/win-client/superoffice-ini.md)