> ## 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.

# SuperOffice CRM running on Microsoft SQL Server database

> Create a new Microsoft SQL Server database for SuperOffice onsite

To be able to install SuperOffice CRM software on MS SQL database, you need to manually create a blank database and an ODBC data source.

<Note>
  If you want to take advantage of the [MS SQL Server full-text search][1] you need to [set this up][2] before running **DBSetup** or **ServerSetup** to create the new SuperOffice CRM database.
</Note>

## Create a new Microsoft SQL Server database

Follow these steps to set up the target MS SQL database:

1. Create a new target database using the MS SQL Server Management studio.
   Fill in the **Database name**, leave the **Owner** field to default.
   ![Add new DB -screenshot][img1]

2. Add a new login in **Security - Login**. The login name may be called CRM8 but you are free to name the login whatever you like. Switch to **SQL Server authentication** and fill in password. You can set the **Default database** to the SuperOffice one.
   ![Add new login -screenshot][img2]

3. Switch to **User Mapping** page and give the user **db\_owner** permission on the new database.
   ![Add DB owner -screenshot][img3]

4. Go to the new database, expand **Security** and **Schemas**. Create a new schema, the name of the schema will be the table prefix.
   ![Create schema -screenshot][img4]

## Create a new 32-bit ODBC System Data Source

1. Go to Windows start menu - Windows Administrative tools and start **ODBC Data Sources (32-bit)**. It is important to select the 32-bit version and not the 64-bit of the ODBC manager.

   Select **System DSN** tab, click **Add** and from the list of available drivers select **SQL Server Native client**. Click **Finish** to start the Data source wizard.

   ![New ODBC -screenshot][img5]

2. Enter the ODBC source name and from the drop down list select the SQL server where SuperOffice database was created.

   ![Source name -screenshot][img6]

3. Switch to the **SQL Server authentication** option and enter the login name and password you created in the Step 2 of the database creation.

   ![Source login -screenshot][img7]

4. Tick the checkbox **Change the default database to** and from the drop down list select the SuperOffice database.

   ![Default DB -screenshot][img8]

5. On the next page leave the configuration options as they are and continue to the last screen. Click **Test Data Source** button to check if all entered values are OK and the data source is working. Click **OK** to finish the ODBC Data Source wizard.

   ![Finish -screenshot][img9]

Please refer to the manufacturer's web pages for more information.

***

[Previous][12] | [Next][11] | [Back to guide][13]

[1]: https://docs.microsoft.com/en-us/sql/relational-databases/search/full-text-search?view=sql-server-2017

[2]: ./sql-server-full-text-search

[11]: ../iis/index

[12]: ../server/prepare

[13]: ../guide

[img1]: /media/loc/en/onsite/01-new-db.jpg

[img2]: /media/loc/en/onsite/02-add-login.jpg

[img3]: /media/loc/en/onsite/03-db-owner.jpg

[img4]: /media/loc/en/onsite/04-add-schema.jpg

[img5]: /media/loc/en/onsite/06-odbc-new.jpg

[img6]: /media/loc/en/onsite/07-odbc-name.jpg

[img7]: /media/loc/en/onsite/08-odbc-login.jpg

[img8]: /media/loc/en/onsite/09-odbc-database.jpg

[img9]: /media/loc/en/onsite/11-odbc-finish.jpg


## Related topics

- [Databases supported by SuperOffice CRM](/en/onsite/compatibility/database.md)
- [System requirements for SuperOffice server hosting CRM server](/en/onsite/requirements/crm-server.md)
- [Move SuperOffice CRM Server](/en/onsite/upgrade/to-81/move-crm-server.md)
- [Tested Microsoft SQL Server](/en/onsite/compatibility/ms-sql-server.md)
- [Prepare the database](/en/onsite/install/database/index.md)
- [SQL Server schema for Database Mirroring](/en/online/mirroring/sql-server-schema.md)