Solved

Cant reattach a database to original server

Posted on 2013-02-07
1
278 Views
Last Modified: 2013-02-07
I detached a database from the sql server and am getting the following error when I point to the file to reattach it:

Failed to retrieve data for this request.  An exception occurred while executing a Transact-SQL statement or batch (Microsoft.qlServer.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 'D:\SQL\NIAHISTORIAN_plantdatabase.mdf.'  (Microsoft SQL Server error 5123)

Can anyone help?
0
Comment
Question by:cjacl
1 Comment
 

Accepted Solution

by:
cjacl earned 0 total points
ID: 38865501
I found my own answer.  I changed the security on both the .mdf and .ldf to allow 'everyone' full permission.  Was able to reattach the database successfully.
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
MS SQL Delete Query 9 37
replicated - directional or bidirectional? 3 36
SSRS 2013 - Overlapping reports 2 32
database level memory cache..? 8 33
     When we have to pass multiple rows of data to SQL Server, the developers either have to send one row at a time or come up with other workarounds to meet requirements like using XML to pass data, which is complex and tedious to use. There is a …
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question