[dba-SQLServer] Unable to open billing database

Well... I have to say "I don't think so".  The problem is that this is 
Vista, and I do not yet understand Vista.

Let's take some examples:

I tried to unzip a file directly into a directory in the C: drive of 
this machine.  The unzip failed saying that it was read-only.  I copied 
the zip to my documents directory and could unzip it there.  I had to 
ask permission to copy the unzipped contents back to that directory.

OTOH, I have an Access database FE in the same directory that I am 
trying to run this SQL Server DB from.  I can open that MDB and modify 
it, so that mdb file is not read-only and I have permission to do that.

The folder itself is marked read-only from the properties window.  When 
I tell it to set it to not read-only it goes off without complaint to 
start marking all the files and folders underneath that directory as not 
read-only, but the folder itself is still read-only when it is done.

So I don't have a clue what Vista / SQL Server is doing in this case. 
What I do know is that if I move the files off to a thumb drive they 
will attach just fine so it is SOMETHING about the C: drive in particular.

Asger Blond wrote:
> John,
> Does the service account for your SQL Server have read/write permission on
> the folder hosting your database?
> 
> Asger
> 
> -----Oprindelig meddelelse-----
> Fra: dba-sqlserver-bounces at databaseadvisors.com
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] På vegne af jwcolby
> Sendt: 14. april 2008 15:36
> Til: Dba-Sqlserver
> Emne: [dba-SQLServer] Unable to open billing database
> 
> I have rather an emergency here.  I am trying to get at my billing 
> database which runs through an Access FE attached to tables in a SQL 
> Server database.  This was all working for many years on my old XP 
> machine.  The database was created in SQL Server Express AFAICR.
> 
> When my laptop died I received a new one from Dell, and I installed 
> Vista on it.  I also installed Visual Studio 2008 in preparation for 
> going there.  It apparently installed PARTS of SQL Server 2005 and SQL 
> Server Express.
> 
> Management studio was NOT installed, so first I tried to install SQL 
> Server 2005 but it told me that I could not install the user interface 
> because what I already had installed was newer than what I was trying to 
> install, however AFAICT Management Studio was NOT installed.  Needless 
> to say not having management studio is causing me problems doing 
> anything with SQL Server.
> 
> I subsequently downloaded and installed Management studio express which 
> DID install.  However (and here comes the problem) when I try to attach 
> the billing database I get a message saying:
> 
> 
> An exception occurred while executing a Transact-SQL statement or batch. 
> (Microsoft.SqlServer.Express.ConnectionInfo)
> 
> ------------------------------
> 
> Unable to open the physical file "C:\Colby 
> Consulting\C2DbBilling\C2DbBilling.mdf". Operating system error 5: 
> "5(Access is denied.)". (Microsoft SQL Server, Error: 5120)
> 
> Unfortunately so much has changed that I have no clue where to start 
> troubleshooting this problem.  I googled the error but ended up with a 
> bunch of "SQL Server can't start" stuff, but SQL Server is running as is 
> Management Studio Express.
> 
> Any ideas where to start figuring this thing out.  My billing database 
> is locked up in SQL Server at the moment and I can't get at it.
> 
> 8-(
> 
> John W. Colby
> www.ColbyConsulting.com
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
> 

-- 
John W. Colby
www.ColbyConsulting.com