Skip to Content
avatar image
Former Member

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

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&EvtID=5123&LinkId=20476

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

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)

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Nov 21, 2013 at 12:16 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded