Create File encountered operating system error 5(Access is denied.) while attempting to open or create the physical file
Hi all, Most of time while trying to attach a database in SQL Server We face a issue. ERROR Message - TITLE: Microsoft SQL Server Management Studio ------------------------------ Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc) ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ CREATE FILE encountered operating system error 5(Access is denied.) while attempting to open or create the physical file 'D:Databasefilepath.mdf'. (Microsoft SQL Server, Error: 5123) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.4000&EvtSrc=MSSQLServer&EvtID=5123&LinkId=20476 ------------------------------ Resolution - While starting SQL Server Managment Studio, dont just double click the icon, Right Click it and select Run As Administrator. Thanks & Regards, Saurav Dhyani