Ms Sql Server Error 5123
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Error: 5123 CREATE FILE encountered operating system error 5A(Access denied.) SQL Server > Getting started with SQL Server Question 1 Sign in to vote HI , This is a problem I encountered when I had to detach a database file (type .mdf): 1) I went to the MS SQL Management Server Studi and detached my database file successfully from a connection called Workhorse. 2) I needed to place the .mdf database file into a zip file in order to put it on a remote server. I did this using Shared Portal. This was also successful 3) However when I tried reattaching the database file, I got this error: CREATE FILE encountered operating system error 5A(Access denied.) while attempting to open or create the physical file "C\Program Files\MSSQL Server\MSSQL\Data\
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Can't attach any database to SQL Server 2012 up vote 3 down vote favorite 2 Ok this is what I get: Failed to retrieve data for this request. (Microsoft.SqlServer.Management.Sdk.Sfc) https://social.msdn.microsoft.com/Forums/sqlserver/en-US/03e12388-01f2-4ae7-aab9-14e27a9ef0b3/error-5123-create-file-encountered-operating-system-error-5aaccess-denied?forum=sqlgetstarted Additional information: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) CREATE FILE encountered operating system error 5(error not found) while attempting to open or create the physical fife 'C: \Program Fifes (x86) \Microsoft SQL Server \MSSQL.1 \MSSQL \Data \MyCompany.mdf. (MIcrosoft SQL Server, Error: 5123) I have already reinstalled SQL Server 2012, and it still doesn't work. Before this problem I tried to attach the AdventureWorks database and insert some command (I have deleted it) and http://stackoverflow.com/questions/17553403/cant-attach-any-database-to-sql-server-2012 since then I keep having this problem. I am new to SQL Server. Thanks sql sql-server-2012 share|improve this question edited Jul 9 '13 at 18:17 marc_s 454k938701033 asked Jul 9 '13 at 16:23 Lazar Lukic 18115 2 There seem to be some typographical errors in your error-text. The path is missing a number I think. MSSQL11? Please confirm SQLServer version. Also you have "fifes" not "files". –Tim Jul 9 '13 at 16:29 MSSQL.1 that's what it says...And yes fife is a typo. –Lazar Lukic Jul 9 '13 at 16:37 If you open the database in SSMS and look at its properties, what does it say there for the path? –Tim Jul 9 '13 at 16:39 This: C:\Program Files (x86)\Microsoft SQL Server\MSSQL.1\MSSQL\Data –Lazar Lukic Jul 9 '13 at 16:45 add a comment| 3 Answers 3 active oldest votes up vote 10 down vote accepted This is a permission issue. The account under which the SQL Server process is running has no write permission to the programs folder. Either you add those permissions to the account running the SQL Server service or you attach your database at a location where the SQL Server service account has read/write rights. See this DBA Stackexchange question for the same issue. share|improve this answer edited Jul 9 '13 at 16:42 answered Jul 9 '13 at 16:35 MicSim 16.8k1158101 add a comment|
Επιλέξτε τη γλώσσα σας. Κλείσιμο Μάθετε περισσότερα View this message in English Το YouTube https://www.youtube.com/watch?v=JBxtkgU5qDg εμφανίζεται στα Ελληνικά. Μπορείτε να αλλάξετε http://dba.stackexchange.com/questions/22250/sql-server-create-file-encountered-operating-system-error-5-access-is-denied αυτή την προτίμηση παρακάτω. Learn more You're viewing YouTube in Greek. You can change this preference below. Κλείσιμο Ναι, θέλω να τη κρατήσω ms sql Αναίρεση Κλείσιμο Αυτό το βίντεο δεν είναι διαθέσιμο. Ουρά παρακολούθησηςΟυράΟυρά παρακολούθησηςΟυρά Κατάργηση όλωνΑποσύνδεση Φόρτωση... Ουρά παρακολούθησης Ουρά __count__/__total__ Fix error : Failed to retrieve data for this request. ms sql server (Không attach được sql_mdf) lequangvudl ΕγγραφήΕγγραφήκατεΚατάργηση εγγραφής4545 Φόρτωση... Φόρτωση... Σε λειτουργία... Προσθήκη σε... Θέλετε να το δείτε ξανά αργότερα; Συνδεθείτε για να προσθέσετε το βίντεο σε playlist. Σύνδεση Κοινή χρήση Περισσότερα Αναφορά Θέλετε να αναφέρετε το βίντεο; Συνδεθείτε για να αναφέρετε ακατάλληλο περιεχόμενο. Σύνδεση Στατιστικά στοιχεία 8.796 προβολές 13 Σας αρέσει αυτό το βίντεο; Συνδεθείτε για να μετρήσει η άποψή σας. Σύνδεση 14 2 Δεν σας αρέσει αυτό το βίντεο; Συνδεθείτε για να μετρήσει η άποψή σας. Σύνδεση 3 Φόρτωση... Φόρτωση... Φόρτωση... Η δυνα
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top SQL Server CREATE FILE encountered operating system error 5 (Access is denied.) up vote 7 down vote favorite 2 I'm trying to execute the following script in SQL Server Management Studio but I'm getting the error: Msg 5123, Level 16, State 1, Line 2 CREATE FILE encountered operating system error 5 (Access is denied.) while attempting to open or create the physical file 'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\test1.mdf'. Msg 1802, Level 16, State 4, Line 2 CREATE DATABASE failed. Some file names listed could not be created. Check related errors. Script : USE [master] GO /****** Object: Database [bioenergiasIpad] Script Date: 08/07/2012 17:01:19 ******/ CREATE DATABASE [test1] ON PRIMARY ( NAME = N'test1', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\test1.mdf', SIZE = 70656KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB) LOG ON ( NAME = N'test1_log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL10.SQLEXPRESS\MSSQL\DATA\test1_log.ldf', SIZE = 164672KB , MAXSIZE = 2048GB , FILEGROWTH = 10%) GO Already have all role permissions for my user, any ideas on what's wrong ? Thanks ! sql-server query sql-server-2012 share|improve this question asked Aug 9 '12 at 20:19 thiagocfb 38113 migrated from stackoverflow.com Aug 9 '12 at 22:08 This question came from our site for professional and enthusiast progra