|
Download and Install SQL Server Express Edition with FileStream
Step 1: Download SQL Server Express Edition
1.Open your web browser and go to the official Microsoft SQL Server Express download page:
https://www.microsoft.com/en-us/sql-server/sql-server-downloads
2.Scroll down to the SQL Server Express section.
3.Click Download now to get the installer (latest version).
Step 2: Run the Installer
1.Locate the downloaded installer file and double-click to run it.
2.Choose the Custom installation option to allow advanced configurations.
3.Select a location for the extracted installation files and click Install.
Step 3: Install SQL Server Express
1.After extraction, the SQL Server Installation Center will open.
2.Click New SQL Server stand-alone installation or add features to an existing installation.
3.Accept the license terms and click Next.
4.Select SQL Server Express Edition and click Next.
5.Under Instance Configuration, leave the default instance name (SQLEXPRESS) or specify a custom name.
6.Click Next to continue.
Step 4: Configure SQL Server with FileStream
1.In the Feature Selection window, check the following options:
oDatabase Engine Services
oFILESTREAM (under Database Engine Services)
2.Click Next.
3.In the Server Configuration window, set the SQL Server Database Engine to run under the NT AUTHORITY\NETWORK SERVICE account.
4.Under Database Engine Configuration, select Mixed Mode (SQL Server authentication and Windows authentication) and set a strong password for the sa account.
5.Under the FILESTREAM tab, enable FILESTREAM for Transact-SQL access and FILESTREAM for I/O access.
6.Click Next, then Install to begin the installation.
Step 5: Verify FILESTREAM Configuration
1.Open SQL Server Management Studio (SSMS).
2.Connect to the SQL Server instance.
3.Run the following query to confirm FILESTREAM is enabled:
EXEC sp_configure 'filestream access level';
4.If the value is 0, enable FILESTREAM by running:
EXEC sp_configure 'filestream access level', 2;
RECONFIGURE;
5.Restart the SQL Server service for changes to take effect.
Step 6: Confirm Installation
1.Open SQL Server Configuration Manager.
2.Under SQL Server Services, ensure SQL Server (SQLEXPRESS) is running.
3.Under SQL Server Network Configuration, enable Named Pipes and TCP/IP if required.
4.Open SSMS, connect to the database, and verify the installation is complete.
SQL Server Express Edition with FILESTREAM is now installed and ready for use!
|
