Can't Install AW OLTP 2008R2 Data Base

Question

I see this has been a problem and I've tried all the solutions but no luck. I am on WinXP, SQL Server 2008R2. My SQL privilges are all associated with my Windows Domain login account which has admin privileges. All the other sample data bases install fine but with the 2008 OLTP one the error I get is

Error: Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\Documents2008R2". Operating system error 259: "259(No more data is available.)".
Installation Terminated

I tried precreating the folder but then it says (Folder) already exists - terminating". Changing the SQL Server service account to Local System didn't help either

The book I am studying uses this data base a lot so I am held up until I figure out how to fix this

Thanks

Wayne H

Answer 1

Have you tried navigating to the C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA folder and explicity granting your user account read, write, execute permissions?

If so, try running the MSI "As Administrator"

---

Peter Carter-Greenan http://sqlserverdownanddirty.blogspot.com/

Answer 2

I tried running the EXE as admin, but it doesn't recognize any installed SQL instances. :-(

Answer 3

Ok, have you tried the other suggestion (granting yourself explicit permissions to the folder)

If so, then log into SQL Instance, set-up login for windows Administrator Account and then grant a min of DBCREATOR role. Then try running as Admin again.

---

Peter Carter-Greenan http://sqlserverdownanddirty.blogspot.com/

Answer 4

Hi Peter - thanks for the suggestions

I did grant those permissions at the DATA folder level for both my domain account and the admin account. I added the admin account in SQL Server and granted the DBCREATOR role. Re-ran the EXE file as ADMIN, this time it did give me the DEFAULT instance. Result?

Error: Unable to open the physical file "C:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\Documents2008R2". Operating system error 259: "259(No more data is available.)".

Driving me crazy!

Wayne

PS I'm running Win XP not Win 7 if that could be related

Answer 5

Well this continues to get more ridiculous. The problem is related to a clause in the Create Database command to set up Filestreaming. I found a hotfix

 

KB Article Number(s): 978835

 

that was supposed to address the problem, but it didn't - same error. OK, I give up - I'll download the data based without Filestream that was uploaded here in January. Followed the instructions and got

 

Msg 1813, Level 16, State 2, Line 1
Could not open new database 'AdventureWorks2008R2'. CREATE DATABASE is aborted.
Msg 948, Level 20, State 1, Line 1
The database 'AdventureWorks2008R2' cannot be opened because it is version 661. This server supports version 662 and earlier. A downgrade path is not supported

 

This shouldn't be this hard