SQL Server 2005:Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

[former_member183788]

Dear Experts,

        We are trying to restore the database in 2005, We detach the database and while trying to attach,its showing the error as below:

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

------------------------------

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&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.ExecuteSql.ExecuteWithResults(StringCollection query, Object con, StatementBuilder sb)

   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 'F:\NSMDATA1\NSMDATA1.mdf'. (.Net SqlClient Data Provider)

------------------------------

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&E...

------------------------------

Server Name: sapsoldms

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 Member · Accepted solution]

Hello Philip,

User doesn't have proper authorization to

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

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

Make shure if user has write right to F:\NSMDATA1 and to NSMDATA.mdf.

Also check http://www.guyellisrocks.com/2010/07/create-file-encountered-operating.html

BR,

K.

[former_member183788 · Accepted solution]

Kamil,

     The issue solved with the below link.

http://blog.sqlauthority.com/2008/11/04/sql-server-fix-error-4064-cannot-open-user-default-database-...