SQL SERVER – Error : Fix : Msg 5133, Level 16, State 1, Line 2 Directory lookup for the file failed with the operating system error 2(The system cannot find the file specified.)

I recently got email from friend who had suffered from following error.

Msg 5133, Level 16, State 1, Line 2
Directory lookup for the file “filepath” failed with the operating system error 2(The system cannot find the file specified.).
Msg 1802, Level 16, State 1, Line 2
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
Msg 5133, Level 16, State 1, Line 2
Directory lookup for the file “filepath” failed with the operating system error 2(The system cannot find the file specified.).
Msg 1802, Level 16, State 1, Line 2
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.

As per him he had gone crazy to find solution. He had been trying to create database  and he had all the admin privileges. After getting remote desktop, I realize that he was everything correct but the filepath he was trying to create. Once he corrected the filepath everything was smooth from there.

If you have the same error I suggest you carefully check your filepath. There must be some typo or error in filepath. If that is not the case and with admin rights you are still facing issue, post a comment here.

Reference: Pinal Dave (https://blog.sqlauthority.com)

Previous Post
SQL SERVER – Find Total Number of Transactions on Interval
Next Post
SQL SERVER – Quickest Way to Identify Blocking Query and Resolution – Dirty Solution

Related Posts

37 Comments. Leave new

  • worked when I set full permissions on Authenticated users.

    Reply
  • Great help Pinal.
    I just check the mdf and ldf file name and it works fine.

    Reply
  • i dont even know the words you guys are using. is there an easy way to have me fix this issue caused by damn windows uodate, i should hav known not make any changes, even an update as we are getting ready for a transition and i really dont have time or resources for this kind of calamity. geez. sorry to be asking for help, sorta a noob….

    Reply

Leave a Reply

Menu