Re-attaching databases after upgrading to SQL Server Enterprise Edition

Since Upgrading from SQL Standard Edition to SQL Server EE we have been unable to re-attach the database files that we detached before the upgrade, to SQL Server Management studio. We get an error message that reads:

TITLE: Microsoft SQL Server Management Studio

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

CREATE FILE encountered operating system error 5(error not found) while attempting to open or create the physical file

Any help with this matter would be truly appreciated. Thank you.

You need to reset the NTFS permisions on the physical files. SQL 2005 locks out the physical files NTFS permissions when the databases are detached.

re-attach database to another server

I have detached a database, say AB, from one SQL server 2000. Then attach it
in another server 2000 by using enterprise manager. But it is reattached as
read-only. So I can not make any change. There is no such a peoblem for sql
server 2005.
How to solve this problem?
Thank you for any help
David
Solved it by reading the previous posts.
Thanks
This is a good web site.
David
"david" wrote:

> I have detached a database, say AB, from one SQL server 2000. Then attach it
> in another server 2000 by using enterprise manager. But it is reattached as
> read-only. So I can not make any change. There is no such a peoblem for sql
> server 2005.
> How to solve this problem?
> Thank you for any help
> David

re-attach database to another server

I have detached a database, say AB, from one SQL server 2000. Then attach it
in another server 2000 by using enterprise manager. But it is reattached as
read-only. So I can not make any change. There is no such a peoblem for sql
server 2005.
How to solve this problem?
Thank you for any help
DavidSolved it by reading the previous posts.
Thanks
This is a good web site.
David
"david" wrote:

> I have detached a database, say AB, from one SQL server 2000. Then attach
it
> in another server 2000 by using enterprise manager. But it is reattached a
s
> read-only. So I can not make any change. There is no such a peoblem for sq
l
> server 2005.
> How to solve this problem?
> Thank you for any help
> David

re-attach database to another server

I have detached a database, say AB, from one SQL server 2000. Then attach it
in another server 2000 by using enterprise manager. But it is reattached as
read-only. So I can not make any change. There is no such a peoblem for sql
server 2005.
How to solve this problem?
Thank you for any help
DavidSolved it by reading the previous posts.
Thanks
This is a good web site.
David
"david" wrote:
> I have detached a database, say AB, from one SQL server 2000. Then attach it
> in another server 2000 by using enterprise manager. But it is reattached as
> read-only. So I can not make any change. There is no such a peoblem for sql
> server 2005.
> How to solve this problem?
> Thank you for any help
> David