SharePoint, Office 365, Azure, and Front end JS geek. – Chicago IL
SharePoint, Office 365, Azure, and Front end JS geek. – Chicago IL

Unable to assign this e-mail address to the list, because the address is in use – FIXED

I came across this WSS error message today while working on incoming email updates and was stuck.   The browser clearly showed the list has no inbound email enabled and offered no alternatives on how to enable.   My enable failed, the address is taken, and I have no way to remove.

SQL Studio to the rescue!

addr in use

OK.  First of all I know, I know I know.   TSQL against the databases even in read only mode is frowned upon.   What I am doing here is far beyond supported, not safe, and I am a crazy man.  Again, I know this.   I had no other options and needed a solution.

The config database holds a central table the incoming email references to get the site, web, and list GUID for where to place the message.    I found my old email alias in here despite the fact the web GUI showed it was disabled.  

Disappointed

  I wrote a select statement and copied the output to notepad in case I needed to INSERT this row back.   I then changed “SELECT *” to “DELETE” and killed the one row.   Flipping back to IE and clicking OK, it worked perfectly!   Never had any issues since and this was weeks ago.   Like they say on TV … “don’t try this at home”

  • Hey Jeff,

    Thanks for the post that pointed me to the table that stores this information.

    I found, however, that this can be fixed by the Change Log timer job. It’s scheduled to run daily out of the box. If you can make it run sooner by changing its schedule, then you can make sure that these aliases become available once they’ve been disabled in their old location.

    Cheers

  • Hey Jeff,

    Thanks for the post that pointed me to the table that stores this information.

    I found, however, that this can be fixed by the Change Log timer job. It’s scheduled to run daily out of the box. If you can make it run sooner by changing its schedule, then you can make sure that these aliases become available once they’ve been disabled in their old location.

    Cheers

    • Adam Kopejtko

      in 2013 can be run manually in CA

  • siCCo

    Hi Jeff. Thanks a lot for this post mate – worked like a charm!

    • Glad you found it helpful. Thanks for the comment!

© Copyright 2016
@ SPJeff

Return to Top ▲Return to Top ▲