Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  SQL Server Administration (2008)  Databasemail configuration / connection problem

Author  Topic  Leecau Starting Member 5 Posts Posted - 2010-05-05 : 07:35:16 I am trying to setup Databasemail on SQL Server 2008 and not having much luck (it is working and calls databasemail90.exe) so 90% there I have configured everything as required except keep getting this error: ) Exception Information =================== Exception Type: Microsoft.SqlServer.Management.SqlIMail.Server.Common.BaseException Message: There was an error on the connection. Reason: 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), connection parameters: Server Name: SQLUAT1\SQLUAT1, Database Name: msdb Data: System.Collections.ListDictionaryInternal TargetSite: Void OpenConnection(Microsoft.SqlServer.Management.Common.SqlConnectionInfo) HelpLink: NULL Source: DatabaseMailEngine Now - it seems to be the Servername\Instancename is the issue (SQLUAT1\SQLUAT1) we previously use to connect to sqlsever (in management studio) using Servername/Instancename - but that has stopped working - and we now can only use instancename ie SQLUAT1 - that will work fine. I do no know why this has changed or how to change it back. It seems DBMail is using the Server/Instance but I need it to not do that but can't work out how to configure it either. I have multiple SQL Servers (sqluat1 / Sqluat2 / sqluat3) etc that have DBmail setup on them and all have this problem. Is there a way to configure this connection to work in dbmail? Or change the config so it uses server/instance again? Thanks