Меню

Microsoft sql server ошибка 5133

  • Remove From My Forums

  • Question

  • was working before, cannot figure out what happened.

    1. reboot pc

    2. open MSSMS 2012

    3. right click on «Databases», create new database

    4. got error 5133

    my c:, f: folders are read-write

Answers

    • Proposed as answer by

      Thursday, July 11, 2013 2:32 AM

    • Marked as answer by
      Fanny Liu
      Tuesday, July 16, 2013 2:42 AM

  • Hi,

    The directory mentioned to create the database files is incorrect. It should be something like C:Program FilesMicrosoft SQL ServerMSSQL11.SQLEXPRESSMSSQLDATAdb5.mdf

    Thanks & 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 Liu
      Thursday, July 11, 2013 2:32 AM
    • Marked as answer by
      Fanny Liu
      Tuesday, July 16, 2013 2:42 AM

Источник
  • Remove From My Forums

  • Вопрос

  • Hi,

    I am unable to attach example database mdf file. It gives me error 5133 though I can create new database without any problem. The error says » Directory lookup for the file «c:program FilesMicrosoft SQL ServerMSSQL11.MSSSQLSERVERMSSQLDATAAdventureWorks2012_Log.ldf»
    failed with the operating system error 3 (the system cannot find the path specified). (Microsoft SQL Server, Error:5133)

    Thanks!

    Syed 

Ответы

    • Предложено в качестве ответа

      8 января 2016 г. 8:57

    • Помечено в качестве ответа
      Lydia ZhangMicrosoft contingent staff
      15 января 2016 г. 9:28
Источник

Today I was having following error and found the work around

Create database failed with error 5133 on Microsoft SQL server 2012 With following ERROR

Microsoft SQL Server, Error: 5133

Msg 5170, Level 16, State 1, Line 1
Cannot create file ‘E:SQL2012MYDATABASENAME.mdf’ because it already exists. Change the file path or the file name, and retry the operation.
Msg 1802, Level 16, State 4, Line 1
CREATE DATABASE failed. Some file names listed could not be created. Check related errors.
Msg 5011, Level 14, State 5, Line 1
User does not have permission to alter database ‘MYDATABASENAME’, the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 1
User does not have permission to alter database ‘MYDATABASENAME’, the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 1
User does not have permission to alter database ‘MYDATABASENAME’, the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 1
User does not have permission to alter database ‘MYDATABASENAME’, the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 1
User does not have permission to alter database ‘MYDATABASENAME’, the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 1
User does not have permission to alter database ‘MYDATABASENAME’, the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 1
User does not have permission to alter database ‘MYDATABASENAME’, the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 1
User does not have permission to alter database ‘MYDATABASENAME’, the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 1
User does not have permission to alter database ‘MYDATABASENAME’, the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 1
User does not have permission to alter database ‘MYDATABASENAME’, the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 1
User does not have permission to alter database ‘MYDATABASENAME’, the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 1
User does not have permission to alter database ‘MYDATABASENAME’, the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 1
User does not have permission to alter database ‘MYDATABASENAME’, the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 1
User does not have permission to alter database ‘MYDATABASENAME’, the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 1
User does not have permission to alter database ‘MYDATABASENAME’, the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 1
User does not have permission to alter database ‘MYDATABASENAME’, the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 1
User does not have permission to alter database ‘MYDATABASENAME’, the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 1
User does not have permission to alter database ‘MYDATABASENAME’, the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 1
User does not have permission to alter database ‘MYDATABASENAME’, the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 1
User does not have permission to alter database ‘MYDATABASENAME’, the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 1
User does not have permission to alter database ‘MYDATABASENAME’, the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 1
User does not have permission to alter database ‘MYDATABASENAME’, the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 1
User does not have permission to alter database ‘MYDATABASENAME’, the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 1
User does not have permission to alter database ‘MYDATABASENAME’, the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 1
User does not have permission to alter database ‘MYDATABASENAME’, the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 5011, Level 14, State 5, Line 1
User does not have permission to alter database ‘MYDATABASENAME’, the database does not exist, or the database is not in a state that allows access checks.
Msg 5069, Level 16, State 1, Line 1
ALTER DATABASE statement failed.
Msg 911, Level 16, State 1, Line 1
Database ‘MYDATABASENAME’ does not exist. Make sure that the name is entered correctly.

OR

TITLE: Microsoft SQL Server Management Studio
——————————
Create failed for Database ‘MYMYDATABASENAME_0’.  (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.3000.0+((SQL11_PCU_Main).121019-1325+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Create+Database&LinkId=20476
——————————
ADDITIONAL INFORMATION:
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)
——————————
Directory lookup for the file “D:SQL2012TranlogsMYMYDATABASENAME_0_log.ldf” failed with the operating system error 2(The system cannot find the file specified.).
CREATE DATABASE failed. Some file names listed could not be created. Check related errors. (Microsoft SQL Server, Error: 5133)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&ProdVer=11.00.3128&EvtSrc=MSSQLServer&EvtID=5133&LinkId=20476
——————————
BUTTONS:
OK
——————————
Work Around :

==
USE master
GO
— Drop the database if it already exists
IF  EXISTS (
    SELECT name
        FROM sys.databases
        WHERE name = N’MYDatabase_Name’
)
DROP DATABASE MYDatabase_Name
GO
CREATE DATABASE MYDatabase_Name
GO

Once you run this create database you will see the filepath of the database  with error . Go to the Folder of the file Path and assaign full control permissions . Once you assaign the permission run the create database  and you should not see any error now.

Referance

http://technet.microsoft.com/en-us/library/bb727008.aspx

Источник
  • Remove From My Forums

  • Question

  • was working before, cannot figure out what happened.

    1. reboot pc

    2. open MSSMS 2012

    3. right click on «Databases», create new database

    4. got error 5133

    my c:, f: folders are read-write

Answers

    • Proposed as answer by

      Thursday, July 11, 2013 2:32 AM

    • Marked as answer by
      Fanny Liu
      Tuesday, July 16, 2013 2:42 AM

  • Hi,

    The directory mentioned to create the database files is incorrect. It should be something like C:Program FilesMicrosoft SQL ServerMSSQL11.SQLEXPRESSMSSQLDATAdb5.mdf

    Thanks & 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 Liu
      Thursday, July 11, 2013 2:32 AM
    • Marked as answer by
      Fanny Liu
      Tuesday, July 16, 2013 2:42 AM

Источник
  • Remove From My Forums

  • Question

  • was working before, cannot figure out what happened.

    1. reboot pc

    2. open MSSMS 2012

    3. right click on «Databases», create new database

    4. got error 5133

    my c:, f: folders are read-write

Answers

    • Proposed as answer by

      Thursday, July 11, 2013 2:32 AM

    • Marked as answer by
      Fanny Liu
      Tuesday, July 16, 2013 2:42 AM

  • Hi,

    The directory mentioned to create the database files is incorrect. It should be something like C:Program FilesMicrosoft SQL ServerMSSQL11.SQLEXPRESSMSSQLDATAdb5.mdf

    Thanks & 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 Liu
      Thursday, July 11, 2013 2:32 AM
    • Marked as answer by
      Fanny Liu
      Tuesday, July 16, 2013 2:42 AM

Источник

Error: 5133 SQL Server while attaching the Database

Hi all,

One of my friend reported an error while trying to attached a database received from client to SQL SERVER 2008 R2.

The database received have only two files one is .mdf & second one is .ndf.

while attaching database to the server he was getting below error —

TITLE: Microsoft SQL Server Management Studio
——————————
Attach database failed for Server ‘XXX-XX—XX’.  (Microsoft.SqlServer.Smo)


For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.50.2500.0+((KJ_PCU_Main).110617-0038+)&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 «G:SQLLOGNAV_D_CQPA_370B_Log.ldf» failed with the operating system error 3(The system cannot find the path specified.). (Microsoft SQL Server, Error: 5133)
——————————

Resolution —


1) Check for the file path during attach.
In my case as i don’t have the Log File (.ldf)  it was taking a random path which does not exist in the system.

2) Delete the selected file (in my case the log file) and click attach.

The system creates the missing file automatically.

Thanks & Regards,
Saurav Dhyani
http://saurav-nav.blogspot.com/

Popular posts from this blog

Hi All, In this article we will discuss the new introduced member of Dynamics Family. Yes you heard it correctly, one more new member with Name «Microsoft Dynamics 365» . #ProjectMadeira   #Dynamics365

Hi all, We have seen how to save a report into PDF and how to send mail to a customer. Let’s link these two post in one i.e. Mailing statement to a customer into PDF Format. This article is part of the Series. Please Refer  Table of Content here . If you have the old objects set let me brief you what I will be changing — 

Hi all, Please do these activities when you have time, its a long activity and i would suggest do all activities in one go. So be clam and lets start. For NAV 2013 R2 Refer Here. For NAV 2016 Steps have been Reduced Please Refer Here. I have installed NAV 2013 and its work great with my windows credentials. I was checking the service console (Microsoft Dynamics NAV Administration) in NAV 2013 and found out that Credentials Type have multiple Options.

Источник

0 0 голоса
Рейтинг статьи
Подписаться
Уведомить о
guest

0 комментариев
Старые
Новые Популярные
Межтекстовые Отзывы
Посмотреть все комментарии

А вот еще интересные материалы:

  • Яшка сломя голову остановился исправьте ошибки
  • Ятрогенная патология врачебные ошибки
  • Ясность цели позволяет целеустремленно добиваться намеченного исправьте ошибки
  • Ясность цели позволяет целеустремленно добиваться намеченного где ошибка
  • Microsoft sql server ошибка 5120

    • ➤