Error???
-
Hi, I'm getting the following errors while creating Filestream features in Sql server??? How to solve this error,Please help me??? ERROR:- Msg 1969, Level 16, State 1, Line 1 Default FILESTREAM filegroup is not available in database 'HumanResource'. Thanks...
-
Hi, I'm getting the following errors while creating Filestream features in Sql server??? How to solve this error,Please help me??? ERROR:- Msg 1969, Level 16, State 1, Line 1 Default FILESTREAM filegroup is not available in database 'HumanResource'. Thanks...
That is because you have to create that group, it is not provided in your database by default. You must enable it,
Getting Started with FILESTREAM Storage[^]:
FILESTREAM is not automatically enabled when you install or upgrade SQL Server. You must enable FILESTREAM by using SQL Server Configuration Manager and SQL Server Management Studio
So do that, then you will be able to overcome this error. A documentation is given here too, FILESTREAM (SQL Server)[^]. Default FileStream filegroup is not available in database 'DatabaseName'[^]
The shit I complain about It's like there ain't a cloud in the sky and it's raining out - Eminem ~! Firewall !~
-
Hi, I'm getting the following errors while creating Filestream features in Sql server??? How to solve this error,Please help me??? ERROR:- Msg 1969, Level 16, State 1, Line 1 Default FILESTREAM filegroup is not available in database 'HumanResource'. Thanks...
Take a look at this link hope this will help you out: Msg 1969 Level 16 State 1 | SQL Server Portal[^]
-- Regards, Daniel Jones