Microsoft Sql Server 2008 Error 5133
Contents |
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From directory lookup for the file failed with the operating system error 2 My Forums Answered by: MS SQL 2012: create database directory lookup for the file failed with the operating system error 5 failed with error 5133 SQL Server > Getting started with SQL Server Question 0 Sign
Directory Lookup For The File Failed With The Operating System Error 3
in to vote was working before, cannot figure out what happened. 1. reboot pc 2. open MSSMS 2012 3. right click on "Databases",
Error 5133 Sql Server 2014
create new database 4. got error 5133 my c:, f: folders are read-write Wednesday, July 10, 2013 3:16 AM Reply | Quote Answers 0 Sign in to vote Have you gone through this link ? http://blog.sqlauthority.com/2010/10/05/sql-server-error-fix-msg-5133-level-16-state-1-line-2-directory-lookup-for-the-file-failed-with-the-operating-system-error-2the-system-cannot-find-the-file-specified/Regards, RSingh Proposed as answer by Fanny LiuMicrosoft contingent staff, Moderator Thursday, directory lookup for the file .mdf failed with the operating system error 3 July 11, 2013 2:32 AM Marked as answer by Fanny LiuMicrosoft contingent staff, Moderator Tuesday, July 16, 2013 2:42 AM Wednesday, July 10, 2013 3:21 AM Reply | Quote Moderator 0 Sign in to vote Hi, The directory mentioned to create the database files is incorrect. It should be something like C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA\db5.mdfThanks & Regards RAJUKIRAN L Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers. Proposed as answer by Fanny LiuMicrosoft contingent staff, Moderator Thursday, July 11, 2013 2:32 AM Marked as answer by Fanny LiuMicrosoft contingent staff, Moderator Tuesday, July 16, 2013 2:42 AM Wednesday, July 10, 2013 5:10 AM Reply | Quote Answerer All replies 0 Sign in to vote Have you gone through this link ? http://blog.sqlauthority.com/2010/10/05/sql-server-error-fix-msg-5133-level-16-state-1-line-2-directory-lookup-for-the-file-failed-with-the-operating-system-error-2the-system-cannot-find-the-file-specified/Regards, RSingh Proposed as answer by Fanny
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
Operating System Error 5 5(access Is Denied.) . (microsoft Sql Server Error 5120)
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 https://social.msdn.microsoft.com/Forums/sqlserver/en-US/382eb701-f5a9-40c3-aa0e-52c83729caa1/ms-sql-2012-create-database-failed-with-error-5133?forum=sqlgetstarted can answer The best answers are voted up and rise to the top Create database fails with Microsoft SQL Server Error 5133, Operating syste, error 5 (Access is denied) [closed] up vote 2 down vote favorite I just installed SQL server 2012 on Windows 2012 today. After the install, I changed the database settings to create database files in f:\mssql instead of the default. i verified the confired and running values. http://dba.stackexchange.com/questions/57974/create-database-fails-with-microsoft-sql-server-error-5133-operating-syste-err Create database fails to create the .mdf and .log files with the following error - Directory lookup for the file "f:\msql\data\test.mdf' failed with os error 5. (Access is denied). This error occurs when I run sql server service as domain account. The domain account is an administrator and has full control on volume F. If I run the sql server service as local system, I am able to create the database with mdf files on f:\ drive. My sysadmin confirms and I have verified that the domain account has full control on f: I look forward to your suggestions. sql-server-2012 database-administration configuration share|improve this question asked Jan 31 '14 at 15:35 TDPSQL_Newbie 78211 closed as off-topic by Max Vernon, Paul White♦, RLF, Mark Storey-Smith, Shawn Melton Jan 2 '15 at 23:47 This question appears to be off-topic. The users who voted to close gave this specific reason:"Too localized - this could be because your code has a typo, basic error, or is not relevant to most of our audience. Consider revising your question so that it appeals to a broader audience. As it stands, the question is unlikely to help other users (regarding typo questions, see this meta question for background)." – Max Vernon, Paul White, RLF, Mark Storey-Smith, Shawn Mel
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=177782 » SQL Server 2005 » SQL Server Express » Error: 5133 when i attach database! Error: 5133 when i operating system attach database! Rate Topic Display Mode Topic Options Author Message ngochoang297ngochoang297 Posted Monday, January 13, 2014 7:41 PM Forum Newbie Group: General Forum Members Last Login: Friday, April 24, 2015 1:24 AM Points: 6, Visits: 13 TITLE: Microsoft SQL Server operating system error Management Studio Express------------------------------Attach database failed for Server 'NGOCHOANG-VAIO\BMSSERVER'. (Microsoft.SqlServer.Express.Smo)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476------------------------------ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)------------------------------Directory lookup for the file "D:\BMSMoi2013\DATA2013\BMS_2013.mdf" failed with the operating system error 3(The system cannot find the path specified.). (Microsoft SQL Server, Error: 5133)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3042&EvtSrc=MSSQLServer&EvtID=5133&LinkId=20476------------------------------BUTTONS:OK------------------------------Screen :Pls help me!Email : ngochoang297@gmail.comSkype : Robertsnguyen [Smile] Post #1530518 Montana LifeMontana Life Posted Monday, January 13, 2014 8:14 PM SSC-Addicted Group: General Forum Members Last Login: Monday, March 7, 2016 9:11 AM Points: 416, Visits: 338 Your screenshot is a bit blurry. Are you sure the current file path selected for the MDF is valid and the file is in that directory?Mike MikeHow to Post Performance ProblemsHow to
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums General SQL Server Forums New to SQL Server Administration error Message when attaching a Database Reply to Topic Printer Friendly Author Topic JohnFen Starting Member Ireland 3 Posts Posted-08/13/2012: 07:03:52 I have only started using SQL recently and am getting the following message when i try to attach a database:TITLE: Microsoft SQL Server Management Studio------------------------------Attach database failed for Server 'johnfennell-pc\sqlexpress'. (Microsoft.SqlServer.Smo)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1750.9+((dac_inplace_upgrade).101209-1051+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476------------------------------ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)------------------------------Directory lookup for the file "C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\sheffcol2.mdf" failed with the operating system error 3(failed to retrieve text for this error. Reason: 15105). (Microsoft SQL Server, Error: 5133)For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.1617&EvtSrc=MSSQLServer&EvtID=5133&LinkId=20476I have attached other databases without any issues, anybody got any ideas on what to do? JohnFen Starting Member Ireland 3 Posts Posted-08/13/2012: 07:10:53 I must add, that I am logged into SQL Management studio as Administrator nigelrivett Flowing Fount of Yak Knowledge United Kingdom 3383 Posts Posted-08/13/2012: 07:11:43 DoesC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\sheffcol2.mdfexist?Is it being used by another database?==========================================Cu