SQL 2005 sp_attach_db fails with OS Error 5 Access is denied
- From: todderickson@xxxxxxxxx
- Date: 9 Oct 2006 12:46:19 -0700
I have a problem that seems to be similar to the issue fixed in MSKB
article 922804 (http://support.microsoft.com/kb/922804)
We are an ISV and our application uses a separate reports database fro
each user. When a user logs in, if they do not have a reports DB, we
create it. When they log out we detach their reports DB. When they
log back in we reattach their reports DB.
Normally this works fine. We have never had a problem with it,
although most of our customers are still running on SQL Server 2000.
We have one large customer who is running two instances of SQL Server
2005 on the same machine. These instances are identical as far as I
can tell. One of these instances is used for a Training environment
for our application. The other is used as a testing environment for
our application.
Until last Friday, both instances of SQL Server 2005 were working
flawlessly. Friday afternoon one of the instances began giving us the
following error when trying to attach an existing reports database:
Unable to open the physical file
"E:\MSSQL\Data\Agvance\Agvrep\rephss2.mdf". Operating System error 5:
"(Access is denied")
The other instance of SQL Server 2005 continues to work with no
problem.
MSKB article 922804 addresses network shares, however both of our
databases (and both of the SQL Server instances are on the same
"physical drive" (E:\).
This customer is running in a SAN environment. I don't know if this
has any impact.
Does anyone have any ideas?
Thanks,
Todd Erickson
.
- Follow-Ups:
- Prev by Date: Re: Date convert
- Next by Date: Re: Building queries as strings
- Previous by thread: Handling encryption at the application level
- Next by thread: Re: SQL 2005 sp_attach_db fails with OS Error 5 Access is denied
- Index(es):
Relevant Pages
|
