I am preparing to install SQL2012 for our new SIMS server and will be migration the database from old server to new server. During installing of SQL 2012 on the Database Engineconfiguration window
Under File stream :
Please let me know if I have to enable this option or not. Just trying to work out to minimise unnecessaryservices. If I enable File stream do I need to enable all the 3 which is below.
1) Enable File streamfor Transact-SQL access
2) Enable File streamfor File I/O access
3) Allow remote clients access to file stream Data
Last edited by genesis; 17th July 2014 at 10:00 AM.
I believe it's required if you use FMS and are going to store scanned documents.
I've not heard it mentioned before and it's not specifically mentioned in the SQL install instructions in the other thread which are from SupportNet KB404497.
It's not something that is installed by default, but seems to be activated by the migration utility.
Still be interested to hear from anyone that has done the migrations if they have any experience of doing this and needing to apply the patch as per this from the migration document:
Additional Action for FMS Users with Scanned Documents By default, SQL Server 2012 is installed with FILESTREAM turned off. Where
scanned documents are stored in FMS, FILESTREAM must be enabled on the
server and the database.
If you are carrying out a migration of the FMS database on a self-installed
copy of SQL 2012 Server, you must first create a new Instance of SQL. On
this new Instance, you must activate FILESTREAM. You must then apply
Patch 16361 (which activates FILESTREAM in FMS and enables scanned
documents to be used) to a blank FMS database. Once this process has
been carried out, you can carry out the migration of the FMS database. The
FILESTREAM patch can be obtained from your SIMS Support Unit.
IMPORTANT NOTE: It is not possible to move the FMS database in SQL
2008 to SQL 2012 before running the patch because FILESTREAM is not
yet activated and the process would fail.
If you are installing SQL 2012 using the SIMS SQL 2012 Migration Utility,
FILESTREAM is activated automatically and you do not need to apply the
There are currently 1 users browsing this thread. (0 members and 1 guests)