Cannot write property IsFileStream

Question

Everytime I try to create a new Database in SQL—haven't accomplished to create any, so far. Please, help me with a detailed solution for this.

TITLE: Microsoft SQL Server Management Studio

Cannot write property IsFileStream.This property is not available on SQL Server 7.0. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1600.1+((KJ_RTM).100402-1539+)&EvtID=IsFileStream&LinkId=20476

---

BUTTONS:

OK

Solution 1

Currently you are using preview version of SQL Server 2014 (Community Technology Preview 2) which could be unstable.

You should use latest stable (RTM) version from http://msdn.microsoft.com/en-us/library/dn434042.aspx

Solution 2

SQL Server Management is unable to set up the default property while creating a database using previous version of SQL Server Management Studio.

Solution 3

Select the master database and write a query to create database Example create database XYZ

Solution 4

There is another possibility which you can check as part of SQL Server instance properties. I'm facing this issue with SQL Server 2014 express edition also. It might be the case that the Filestream Access Level configuration (inside Advanced node) is currently disabled for your SQL Server instance. Try changing it to Full access enabled to resolve this issue. Have a look at the below snapshot -

View more solutions

Comments

[RBT]

Yes. This helped. I was accessing SQL Server 2014 express edition with SQL Server 2008 R2 management studio to create a new database.