After renaming SQL Server 2016 cluster there's still a trace of old name from Database Mail
I followed the Microsoft Docs and changed the name of a new SQL Server cluster I built from SQLCLUSTER to SQLFC01. I ensured everything was updated in AD and @@SYSTEMNAME returns the correct 'SQLFC01'. I'm running SQL Server 2016 Standard on SP2 and CU2.
The problem
When sending myself a test email via Database Mail, the name of the email shows as: "SQLCLUSTER SQL Server Admin" instead of "SQLFC01 SQL Server Admin"
I'm guessing there are remnants of the name somewhere on the server... though I've spent hours searching online and the registry but can't find anything. I'm using the same SMTP server on a handful of other servers and the email name on those show correctly as whatever their machine name is. I tried restarting services and rebooting the entire cluster - no luck.
Any ideas what I could do to fix this?
I expect this is simply the Display Name or the Description for the database mail account.
In SSMS
- Expand the Management folder
- Right click on Database Mail
- Select Configure Database Mail
- Click Next
- Select Manage Database Mail accounts and profiles and then select Next
- Select View, change, or delete and existing account and then select Next
I expect you will see SQLCLUSTER SQL Server Admin in the Display Name of the SMTP or in the Description of the Account Name. Change it to what ever you want.
- Query to find position in a string before keyword and extract data before that position
- Correlate these tables dynamically (or automated)
- Manage the order of updates when using a filtered unique index?
- How to use an UPDATE Query with an INNER JOIN to update fields within a table
- Can we use SQL Server STRING_AGG() in queries using GROUP BY ROLLUP ()
- What are row, page and table locks? And when they are acquired?
- Aggregate into custom groups
- Work with multiple where statements with different conditions
- Excel VBA connection to SQL Server with Microsoft Entra MFA authentication
- How can I find sql server port number from windows registry?
- SSIS OLE DB Destination Editor - Create New Table not an option?
- How to Apply Gridify Filtering on an ICollection<T> in EF Core?
- SQL Server Cursor vs WHILE loop
- How do I control parameter sniffing and/or query hints in entity framework?
- Select with like is not returning the correct results
- I am trying to get the start date ONLY from the column below using a SUBSTRING. Can someone tell me what I'm doing wrong?
- using Object_id() function with #tables
- Conditionally filter results of query based on a single flag
- Fill down from a specific row based on criteria
- Spark sending LIMIT to SQL Server on display function
- database restore failing with move
- Join column from a table in SQL Server without write permissions to a data.frame in R using dbplyr
- different deleting OUTPUT behaviour based on source table
- How to simulate a deadlock in SQL Server in a single process?
- Is "SET NOCOUNT OFF" necessary in a stored procedure?
- EF Core takes a lot of time, sometimes, to perform SELECT query
- Dynamic T-SQL - Alter column definition to max length of field
- SQL Server: Update table based on JSON
- Best index(es) to use for an OR Statement in SQL Server
- In a select with a group by, get the last value of a column not in the group by