+ Post New Thread
Results 1 to 2 of 2
MIS Systems Thread, Do i needs to enable file stream during SQL 2012 installation for SIMS server in Technical; Hi I am preparing to install SQL2012 for our new SIMS server and will be migration the database from old ...
  1. #1

    Join Date
    Sep 2012
    Location
    UK
    Posts
    36
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Do i needs to enable file stream during SQL 2012 installation for SIMS server

    Hi

    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

    Please suggest

    Thanks


    Last edited by genesis; 17th July 2014 at 10:00 AM.

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,681
    Thank Post
    692
    Thanked 1,407 Times in 1,166 Posts
    Rep Power
    354
    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
    patch.

SHARE:
+ Post New Thread

Similar Threads

  1. What do i need to do this? - Joomla
    By randle in forum EduGeek Joomla 1.0 Package
    Replies: 10
    Last Post: 4th July 2008, 11:52 AM
  2. Which file do I need to edit to change front page graphics?
    By reggiep in forum EduGeek Joomla 1.0 Package
    Replies: 2
    Last Post: 22nd April 2008, 02:18 PM
  3. What Do I need to get into school ICT...
    By ChrisMcf in forum General Chat
    Replies: 36
    Last Post: 4th January 2008, 04:06 PM
  4. Do I Need To Log On ?.
    By tickmike in forum Hardware
    Replies: 11
    Last Post: 18th August 2006, 08:08 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •