Enabling Attachment File Streaming

about enabling attachment file streaming docid\ pygekqx1fjvvfkaem ku1task 1 enabling the filestream feature docid\ pygekqx1fjvvfkaem ku1task 2 setting up neurons for itsm docid\ pygekqx1fjvvfkaem ku1task 3 running the file stream attachment script docid\ pygekqx1fjvvfkaem ku1 about enabling attachment file streaming microsoft sql server 2022 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, supports the filestream attachment type when you perform the tasks below 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 application database the database administrator normally performs this task on the database server, go to the windows apps menu and click sql server configuration manager 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 click the filestream tab check enable filestream for transact sql access and enable filestream for file i/o access enter a windows share name for the files check allow remote clients access to filestream data click ok on the database server, go to the windows apps menu and click sql server management studio in microsoft sql server management studio, connect to the database server right click the server and choose properties from the pop up menu under select a page , click advanced double click the entry called filestream access level until it displays full access enabled click ok (optional) if you see a restart required message, restart the microsoft sql server microsoft sql server properties task 2 setting up neurons for itsm the 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 neurons for itsm docid\ rxdmdbks23uwnooqrk0oi on the database server, go to the windows apps menu and click system configuration wizard 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 docid\ awy90tvcfndnyaaaxvigq when you create a new configuration database, specify the directory path to the mdf and ldf database files creating a new configuration database on the application page, specify a application database user account that has a db owner role on microsoft sql server this is for the user name field see configuring the neurons for itsm application docid\ n cqlgdmlmhirxxtk awk when you create a new 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 on the microsoft sql server hosting the configuration database, run the filestreamattachment sql script on the microsoft sql server hosting the application database, run the filestreamattachment sql script when you create your application database, you can now specify the filestream attachment type