---
title: Enabling Attachment File Streaming
slug: neurons-for-itsm/on-premises-help/enu/2022/enabling-attachment-file-streaming
createdAt: 2026-07-29T18:57:04.399Z
---

•[About Enabling Attachment File Streaming](https://docs.ivanti.com/neurons-for-itsm/on-premises-help/enu/2022/enabling-attachment-file-streaming#About)

•[Task 1: Enabling the FILESTREAM Feature](https://docs.ivanti.com/neurons-for-itsm/on-premises-help/enu/2022/enabling-attachment-file-streaming#Task_1._Enabling_the_FILESTREAM_Feature)

•[Task 2: Setting up Service and Asset Manager](https://docs.ivanti.com/neurons-for-itsm/on-premises-help/enu/2022/enabling-attachment-file-streaming#Task_2._Setting_up_HEAT_Service_Management_Using_the_System_Configuration_Wizard)

•[Task 3: Running the File Stream Attachment Script](https://docs.ivanti.com/neurons-for-itsm/on-premises-help/enu/2022/enabling-attachment-file-streaming#Task_3._Running_the_FileStreamAttachment.sql_Script)

### About Enabling Attachment File Streaming

Microsoft SQL Server 2008 and later versions come with enhanced support for unstructured data in the form of the FILESTREAM data type, which stores unstructured data files in the NTFS file system while storing the metadata about the unstructured data files in the Microsoft SQL Server database. For more information, see [https://technet.microsoft.com/en-us/library/bb933993(v=sql.105).aspx](https://technet.microsoft.com/en-us/library/bb933993\(v=sql.105\).aspx).

Beginning with Release 2016.1.1, Service and Asset Manager supports the FILESTREAM attachment type when you perform the tasks below.

:::hint{type="info"}
This procedure is only required for deployments that store FILESTREAM attachments.
:::

### Task 1: Enabling the FILESTREAM Feature

You must enable the FILESTREAM feature on the Microsoft SQL Server instances where you plan to install the configuration database and the Service and Asset Manager application database. The database administrator normally performs this task.

1.On the database server, go to the Windows apps menu and click **SQL Server Configuration Manager**.

2\. Navigate to the **SQL Server Services** node and double-click the Microsoft SQL Server instance to modify. For example, select **SQL Server (MSSQLSERVER)**.

*Microsoft SQL Server Properties Dialog Box*

::Image[]{src="https://api.archbee.com/api/optimize/parib0MC3hVoUNdfQdnac/vRuYTdHK0ozAKp2wxKz-8_sqlserverpropertiesdb.png" position="flex-start" size="43" width="426" height="327" initialPath="Install_Deploy_Images/SQL_Server_Properties_DB.png" githubPath="ISM_Install_and_Deploy_Guide/Content/Install_Deploy_guide/Install_Deploy_Images/SQL_Server_Properties_DB.png" showCaption="false"}

3.Click the **FILESTREAM** tab.

4.Check **Enable FILESTREAM for Transact-SQL access** and **Enable FILESTREAM for file I/O access**.

5.Enter a Windows share name for the files.

6.Check **Allow remote clients access to FILESTREAM data**.

7.Click **OK**.

8.On the database server, go to the Windows apps menu and click **SQL Server Management Studio**.

9.In Microsoft SQL Server Management Studio, connect to the database server.

10.Right-click the server and choose **Properties** from the pop-up menu.

11.Under **Select a page**, click **Advanced**.

12.Double-click the entry called **FILESTREAM Access Level** until it displays **Full access enabled**.

13.Click **OK**.

14.(Optional) If you see a restart required message, restart the Microsoft SQL Server.

*Microsoft SQL Server Properties*

::Image[]{src="https://api.archbee.com/api/optimize/parib0MC3hVoUNdfQdnac/r27xrfziuoUxlS7_A5ls4_serverpropertiesfilestreamaccess.png" position="flex-start" size="70" width="704" height="632" initialPath="Install_Deploy_Images/Server_Properties_Filestream_Access.png" githubPath="ISM_Install_and_Deploy_Guide/Content/Install_Deploy_guide/Install_Deploy_Images/Server_Properties_Filestream_Access.png" showCaption="false"}

### Task 2: Setting up Service and Asset Manager

The Service and Asset Manager application database and the configuration database are Microsoft SQL databases. On Microsoft SQL databases, user accounts with the db\_owner fixed database role can perform all configuration and maintenance activities on the database.

These steps are in addition to those described under [Configuring Service and Asset Manager ](https://docs.ivanti.com/neurons-for-itsm/on-premises-help/enu/2022/configuring-service-and-asset-manager).

1.On the database server, go to the Windows apps menu and click **System Configuration Wizard**.

2.On the **Configuration Application** page, specify a configuration database user account that has a db\_owner role on Microsoft SQL Server. This is for the **User Name** field. See [Configuring the Configuration Database](https://docs.ivanti.com/neurons-for-itsm/on-premises-help/enu/2022/configuring-the-configuration-database).

3.When you create a new configuration database, specify the directory path to the MDF and LDF database files.

*Creating a New Configuration Database*

::Image[]{src="https://api.archbee.com/api/optimize/parib0MC3hVoUNdfQdnac/YDJayeasETiPA-ik7LtTS_newdatabase.PNG" position="flex-start" size="76" width="759" height="537" initialPath="Install_Deploy_Images/NewDatabase.PNG" githubPath="ISM_Install_and_Deploy_Guide/Content/Install_Deploy_guide/Install_Deploy_Images/NewDatabase.PNG" showCaption="false"}

4.On the Service and Asset Manage&#x72;**&#x20;Application** page, specify a Service and Asset Manager application database user account that has a db\_owner role on Microsoft SQL Server. This is for the **User Name** field. See [Configuring the Service and Asset Manager Application](https://docs.ivanti.com/neurons-for-itsm/on-premises-help/enu/2022/configuring-the-service-and-asset-manager-application).

5.When you create a new Service and Asset Manager application database, specify an additional path to the server.

### Task 3: Running the File Stream Attachment Script

The FileStreamAttachment.sql script is included on the Software product CD. The script creates an attachment filestream database file group and a filestream.

Before you run the script, open it in Microsoft SQL Server Management Studio and read the script notes carefully, so that you understand what the script does.

1.On the Microsoft SQL Server hosting the configuration database, run the FileStreamAttachment.sql script.

2.On the Microsoft SQL Server hosting the Service and Asset Manager application database, run the FileStreamAttachment.sql script.

When you create your Service and Asset Manager application database, you can now specify the FILESTREAM attachment type. See [Configuring the Service and Asset Manager Application](https://docs.ivanti.com/neurons-for-itsm/on-premises-help/enu/2022/configuring-the-service-and-asset-manager-application#h4_If_the_HEAT_Application_Database_Does_Not_Exist).
