Thursday, December 25, 2008

Sql Server 2008 Error Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

Very strange. I was trying to attach a database using my 'sa' account which was detached before with some other account. I got this error.

-----------------------------------------------------------------------------------------
TITLE: Microsoft SQL Server Management Studio
------------------------------

Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc)

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(failed to retrieve text for this error. Reason: 15105) while attempting to open or create the physical file  (Microsoft SQL Server, Error: 5123)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.1600&EvtSrc=MSSQLServer&EvtID=5123&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Finally, I opened another instance of SQL Management studio and used my regular windows authenticated account to attach and it worked magically.

I understood the reason after it. Basically the 'sa' account is the Sql server account which need not have access to my File system. So it is obvious !

No comments: