August 29, 2009 at 11:03 pm
Hello,
I am facing this STRANGE problem with sql server 2008. When I try to create a new database with filestream group my system hangs. When I restart pc by direct power off and then on, I cannot see the new database but at the given location I could see that database files and filestream group has been created.
Solutions Tried.
Uninstall, download new version then reinstall but to no use.
Set maximum permissions to current user (according to my knowledge).
Using Mix mode authentication.
PC configuraion:
XP Home Edition SP2,
Intel Dual Core 2.0 GHZ Processor
4GB Ram,
SQL Server express SP1 installed on NTFS Partition
Plenty of Disk Space
Comodo Firewall pro, Avast Antivirus ( Already tried to stop firewall and antivirus still no use)
Any help would be appreciated.
August 30, 2009 at 1:09 pm
Interesting....
Have you enabled the FILESTREAM feature at the instance level i.e. did enable the FILESTREAM feature when you first installed SQL Server Express 2008?
Take a look at the following thread.
August 30, 2009 at 3:18 pm
Thanks for reply...
Actually i enabled FileStream during SqlServer installation.
Still same problem:(
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply