Unable to create a database using SQL Server Management Studio or from external program

• ags67

  Valued Member

  Points: 50

  More actions

  March 10, 2009 at 5:29 am

  #135285

  Hello!

  On MS Windows Server 2003 R2 SP2 + all security updates was installed MS SQL Server 2005 Express. Later I try to update SQL Express to MS SQL Server 2005 Standart, but updating ends with error and I install new instance of SQL Server, and disable autorun of SQL Server 2005 Express.

  Now, when I try to create a database using SQL Server Management Studio or from external program, I see in logs next error:

  2009-03-06 17:16:52.69 Error: 50000, Severity: 16, State: 1.

  2009-03-06 17:16:52.69 CREATION OF A USER DEFINED DATABASE IS PROHIBITED - DBNAME = [DBName]

  2009-03-10 14:27:25.96 spid57 Starting up database 'test'.

  2009-03-10 14:27:26.23 spid57 Error: 50000, Severity: 16, State: 1.

  2009-03-10 14:27:26.23 spid57 CREATION OF A USER DEFINED DATABASE IS PROHIBITED - DBNAME = [test]

  Help me, please to resolve this error.

  Thanks.

• Lowell

  SSC Guru

  Points: 323527

  More actions

  March 10, 2009 at 6:55 am

  #956737

  looks like someone has specifically prevented new databases from being created...most like a DDL triger at the server level. that is not an MS error message...someone returned that message as a custom error message.

  otherwise, with normal permissions, you'd get this error:

  [CREATE DATABASE permission denied in database 'master']

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

• ags67

  Valued Member

  Points: 50

  More actions

  March 10, 2009 at 8:28 am

  #956819

  Thanks, Yes, so it also is - DDL-trigger in Server Objects. It was installed with other application and can't be deleted.

  Post closed.