cannot create new database - profile name is not valid

• sqlfriend

  SSC Guru

  Points: 52794

  More actions

  March 17, 2016 at 1:34 pm

  #309132

  I just found out in one of my SQL servers, when I create any new database, it will show an error:

  Create failed for database

  Profile name is not valid.

  What could be wrong, I did not change any thing related with database mail, all of a sudden, I cannot create database any more.

  I have sysadmin rights

  Any ideas?

  Thanks

• Lowell

  SSC Guru

  Points: 323522

  More actions

  March 17, 2016 at 1:37 pm

  #1865981

  i think there is a server wide trigger that is sending an email if a database is created....and the end user creating the database does not have access to the mail profile, or the profile is misspelled.

  check with select * from sys.server_triggers

  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!

• sqlfriend

  SSC Guru

  Points: 52794

  More actions

  March 17, 2016 at 1:43 pm

  #1865985

  Thank you, you are awesome.

  Now I remember I created that procedure in one of the new server, forgot I have to change the profile name.

  Without you know that, I will take forever to find the reason

  Thanks much!

• krypto69

  SSChampion

  Points: 13604

  More actions

  September 15, 2022 at 2:46 pm

  #4088127

  Hey Lowell - I completely forgot about my logon trigger - it was giving me fits for hours! THANKS!