Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
tfountain
Constraint Violating Yak Guru
491 Posts |
 Posted - 2012-08-20 : 00:52:21
|
| Setup:SQL Server 2008 R2 Enterprise Edition x64 (10.50.1600)Windows Server 2008 R2 Enterprise x64When attempting to configure the filestream feature through the SQL Server Configuration Manager I receive the error "You do not have permissions to configure FILESTREAM feature. You need Windows Administrator rights to configure FILESTREAM feature."Now I've set this up on 8 other servers with the same version of SQL Server but the only difference is the one that fails is a failover cluster.Anyone ever experience this issue? I've googled this error message and have not found anything useful. My domain account is in the local adminstrators group as well as I had one of our networking guys that is a domain admin (and local admin) try this as well. No luck. |
|
|
tfountain
Constraint Violating Yak Guru
491 Posts |
Posted - 2012-08-22 : 23:27:52
|
| Any chance anyone has any thoughts on this error? |
 |
|
|
komkrit
Yak Posting Veteran
60 Posts |
Posted - 2012-08-23 : 03:23:45
|
| Probably these links help.http://msdn.microsoft.com/en-us/library/cc645886.aspxhttp://blogs.msdn.com/b/sqlserverstorageengine/archive/2008/06/09/enabling-filestream-post-sql2008-setup-a-known-issue-in-sql-config-manager.aspx- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -Komkrit YensirikulWelcome for all questions. Let us know if our solution solved your problem. |
|
|
|
tfountain
Constraint Violating Yak Guru
491 Posts |
Posted - 2012-08-23 : 11:19:19
|
| Thanks for the input. The first link are the instructions I followed initially and received the error. I've also ran the script the second link points to and receive a similar error "access is denied". Been on the phone with MS every day starting last Monday and no luck. It seems to be some sort of odd OS level permission issue. |
|
|
|
tfountain
Constraint Violating Yak Guru
491 Posts |
Posted - 2012-08-23 : 14:41:21
|
| Update: after applying CU14 for SQL Server 2008 R2 RTM the problem did not go away. Now MS has me installing SP1 (I'm going to push SP2 out instead most likely). That is happening tonight. |
|
|
|
tfountain
Constraint Violating Yak Guru
491 Posts |
Posted - 2012-09-01 : 01:26:49
|
| Still an ongoing issue with MS support. To date they've had me do the following:- upgrade to SQL Server 2008 R2 SP2 CU1- run the repair option- manually enter registry valuesStill no luck. |
|
|
|
komkrit
Yak Posting Veteran
60 Posts |
Posted - 2012-09-01 : 20:59:49
|
| Try logged in with Local Windows Account(not domain account)- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -Komkrit YensirikulWelcome for all questions. Let us know if our solution solved your problem. |
|
|
|
|
|
|
Unable to enable FILESTREAM feature of SQL Server