unable attached database Sql Server 2005

[former_member633852]

Hi experts,

We are getting these errors whenwe try to attache SAP database on SQL Server 2005 w

How can we prevent these errors,

Regards,

===================================

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

-

---

For help, click: http://go.microsoft.com/fwlink?ProdName=MicrosoftSQLServer&LinkId=20476

-

---

Program Location:

at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request)

at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabaseData.PrimaryFile.GetOriginalDatabaseName(String primaryFilePath)

at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabaseData.PrimaryFile.PopulatePrimaryFileData(String primaryFilePath)

at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabaseData.PrimaryFile..ctor(SqlManagementUserControl parent, CDataContainer dc, String fullPath, String databaseOwner, ServerConnection connectionInfo)

at Microsoft.SqlServer.Management.SqlManagerUI.AttachDatabase.IsSelectedFileValid(BrowseFolder dlg)

===================================

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

-

---

Program Location:

at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteReader(String sqlCommand)

at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataReader(String query)

at Microsoft.SqlServer.Management.Smo.DataProvider.SetConnectionAndQuery(ExecuteSql execSql, String query)

at Microsoft.SqlServer.Management.Smo.ExecuteSql.GetDataProvider(StringCollection query, Object con, StatementBuilder sb, RetriveMode rm)

at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillData(ResultType resultType, StringCollection sql, Object connectionInfo, StatementBuilder sb)

at Microsoft.SqlServer.Management.Smo.SqlObjectBase.FillDataWithUseFailure(SqlEnumResult sqlresult, ResultType resultType)

at Microsoft.SqlServer.Management.Smo.SqlObjectBase.BuildResult(EnumResult result)

at Microsoft.SqlServer.Management.Smo.PrimaryFile.GetData(EnumResult erParent)

at Microsoft.SqlServer.Management.Smo.Environment.GetData()

at Microsoft.SqlServer.Management.Smo.Environment.GetData(Request req, Object ci)

at Microsoft.SqlServer.Management.Smo.Enumerator.GetData(Object connectionInfo, Request request)

at Microsoft.SqlServer.Management.Smo.Enumerator.Process(Object connectionInfo, Request request)

===================================

CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'E:\ZETDATA1\ZETDATA1.mdf'. (.Net SqlClient Data Provider)

-

---

For help, click: http://go.microsoft.com/fwlink?ProdName=MicrosoftSQLServer&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=5123&LinkId=20476

-

---

Server Name: .

Error Number: 5123

Severity: 16

State: 20

Line Number: 1

-

---

Program Location:

at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()

at System.Data.SqlClient.SqlDataReader.get_MetaData()

at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)

at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

at System.Data.SqlClient.SqlCommand.ExecuteReader()

at Microsoft.SqlServer.Management.Common.ServerConnection.ExecuteReader(String sqlCommand)

[former_member633852]

I've add administrator user from tab security for all datafiles