Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Unable to create a database using SQL Server Management Studio or from external program Expand / Collapse
Author
Message
Posted Tuesday, March 10, 2009 5:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 11, 2009 12:57 AM
Points: 2, Visits: 8
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.
Post #672300
Posted Tuesday, March 10, 2009 6:55 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 12:01 PM
Points: 12,899, Visits: 32,113
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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #672367
Posted Tuesday, March 10, 2009 8:28 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 11, 2009 12:57 AM
Points: 2, Visits: 8
Thanks, Yes, so it also is - DDL-trigger in Server Objects. It was installed with other application and can't be deleted.
Post closed.
Post #672466
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse