 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
SQL Server Forum / Programming / Connectivity / August 2010Error attaching database
Hello, A database, that attaches to a SQL Server at work (local on a stand alone PC) refuses to be attached to an SQL Server at home (local on a stan alone PC). Both are SQL Server 2008 with Service Pack 1. The message I receive at home is: TITLE: Microsoft SQL Server Management Studio ------------------------------ Attach database failed for Server 'INTELCORE2QUAD'. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.2531.0 +((Katmai_PCU_Main).090329-1045+)&EvtSrc=Microsoft.SqlServer.Management.Smo.Exce ptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId= 20476 ------------------------------ ADDITIONAL INFORMATION: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) ------------------------------ Unable to open the physical file "D:\Michels gegevens\Gegevens\Michels gegevens.mdf". Operating system error 5: "5(failed to retrieve text for this error. Reason: 15105)". (Microsoft SQL Server, Error: 5120) For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.2531& EvtSrc=MSSQLServer&EvtID=5120&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ Can anyone please help me to resolve this problem? Many thanks and greetings from Brugge (Bruges - Belgium), Michel Hello Michel, Is your Operating System Windows Vista? Is UAC enabled? Can you try to open SSMS as Administrator? (Right click on the SSMS icon and click Run as Administrator). P.S. When I was in Belgium (I passed to Belgium from The Netherlands), I first visited Antwerp and then I was thinking if it would be a good or bad idea to visit Bruges as well but it was far away from Antwerp and Brussels so I omitted it from the plan and headed to Brussels. Did I miss too much? I hope not =( Note: Resent because I don't see my reply on the list.  SignatureEkrem Önsoy > Hello, > [quoted text clipped - 40 lines] > > Michel Hello, > Hello Michel, > [quoted text clipped - 3 lines] > and > click Run as Administrator). At home, it is Vista indeed. I use SQL Server Management Studio to attach the database. When Running as Administrator, I was able to attach the database! Thank you very much! Is there a way to start a program always as administrator without having to right-click the icon and explicitly click 'Run as Administrator'? > When I was in Belgium (I passed to Belgium from The Netherlands), I first > visited Antwerp and then I was thinking if it would be a good or bad idea [quoted text clipped - 3 lines] > hope > not =( I like my city very much. Perhaps I'm prejudiced, but I think it's very beautiful. > Note: > Resent because I don't see my reply on the list. This, I do not understand. Thank you very much indeed for your help. Greetings from Brugge (Bruges - Belgium), Michel You may want to disable UAC (User Access Control) feature of Windows Vista, so you'll not have to run as an administrator explicitly. SignatureEkrem Önsoy > Hello, > [quoted text clipped - 34 lines] > > Michel I had the same issue with Windows 7. Run SQL Server Management Studio as an administrator, and the database attached just fine. Thanks for the insight. Aaron Thank you ! this post really helped me a lot. Also, before, I add to set the security of the folder containing the mdf file in order to grand access to users related to SQLSERVER (right click properties / securities). About how to make a program always start as administrator: right-click/property/compatibility/privilege level... and it is done ! I am using windows 7. Thanks again ! > Hello Michel, > [quoted text clipped - 57 lines] > > > > Michel |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2010 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.