Existing users mail alrets not working in TFS

Question

Hi,

We have existing users in tfs  , we had already setup email notification alerts  in different projects.

Suddenly it stopped work it, but once we re-setup its' again working.

Could you please suggest any one the reason why it's happening and provide us solution for this

Regards

Sreedhar

Answer 1

Hi Sreedhar,

Thanks for your post.

Please try to clean the Cache and restart TFS Server manually:

1.        Clean the Cache folder on client computer. The folder path is: C:\Users\username(Team Explorer user name)\AppData\Local\Microsoft\Team Foundation\3.0\Cache(os: Windows Server 2008 R2)
2. Clean the Cache folder on Server machine. The folder path is: C:\Users\username(Web access user name)\AppData\Local\Microsoft\Team Foundation\3.0\Cache(os: Windows Server 2008 R2)
3. After cleaned, on Server machine, click Start and select Run… to open the dialog box, then input iisreset.exe and click OK, wait it run completely.

Then check the Event Viewer log, if there’s error relate to this issue, please share the detailed error log here.  

---

John Qiao [MSFT]
MSDN Community Support | Feedback to us

Answer 2

Hi John Qiao ,

I have checked logs, We are getting event id:5586. Which is talking about source Windows SharePoint Service 3.

Error Description:

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)  

Thanks

Sreedhar

Answer 3

Hi Sreedhar, 

Thanks for your reply.

You said this error talking about source Windows SharePoint 3, according the error message, there’s an error occurred while establishing a connection to SQL Server(maybe Window SharePoint 3 connect to SQL Server).

After you recreated the alerts, all the alerts work fine now? If yes, may that connection error affect the SQL Server at that time.  

---

John Qiao [MSFT]
MSDN Community Support | Feedback to us

Answer 4

Hi John Qiao,

Thanks for your response.

Your correct , as we know the error  establishing a connection to SQL Server (May be windows share point 3 connect to SQL Server).

I have recreated the alerts for existing users now it's working fine,  but still  we have problem few existing users they have not receiving alerts now( means who have not setuped newly those existing users , they already have alerts but  still enable to get alerts but we  have setup alerts newly for same users it's  working fine.

What is the permanent solution for this.

one Year back my Colleague has set upped alerts those users getting problem now means old users.I want to check all the users who having alert notification in my tfs server how do we that?

Regards

Sreedhar

Answer 5

Hi Sreedhar, 

Thanks for your reply.

To check all the users’ alerts in TFS Server, please refer to the replies in your another post: http://social.msdn.microsoft.com/Forums/en-US/tfsadmin/thread/707a6a01-756b-436b-a12b-957f1664bf85/#707a6a01-756b-436b-a12b-957f1664bf85.   

---

John Qiao [MSFT]
MSDN Community Support | Feedback to us

Answer 6

Hi John Qiao,

As you given the table tbl_EventSubscription is empty  means we have queried the table there is no data in to that particular table.

select * from tbl_EventSubscription

user saying that  still they have not reeving email alerts, if we setup newly it's working as expected.

Existing Subscribers not getting  email notifications.

Please suggest us how to resolve this permanently.

Regards

Sreedhar

Answer 7

Hi Sreedhar, 

Thanks for your reply.

After you created the newly alerts for your users, there’s still no data in tbl_EventSubscription table? 

Or the newly created alerts working as expected, and the newly alerts stored in the tbl_EventSubscription table correctly, only old alerts data not stored in tbl_EventSubscription table?             

---

John Qiao [MSFT]
MSDN Community Support | Feedback to us