|
|
|
Author |
Message |
Jdull
|
Posted: Thu Sep 28 09:50:01 CDT 2006 |
Top |
SQL Server >> SQL 2005 Mail
I have an issue with SQL mail on SQL 2005, if i set up the server to listen
on port 1433 all is fine, however, once i configure the server to listen on
another port mail does not get delivered. If I then reset the port number to
1433 and restart the SQL service all my mail attempts executed when the
server was set up on another port get delivered.It seems they queue until the
server is set up with 1433 and then get delivered.
Is this a bug or have i missed a config setting?
cheers
jon
SQL Server9
|
|
|
|
|
Tibor
|
Posted: Thu Sep 28 09:50:01 CDT 2006 |
Top |
SQL Server >> SQL 2005 Mail
My guess is that because of the port change, DatabaseMail90.exe cannot logon to SQL Server anymore.
You should be able to find some info at
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/bc124164-eb6e-4b7f-bf66-98a3113d02f7.htm which might
help with debugging. Perhaps it is as simple as adding a Client config alias with the machine name
specifying the new port...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
>I have an issue with SQL mail on SQL 2005, if i set up the server to listen
> on port 1433 all is fine, however, once i configure the server to listen on
> another port mail does not get delivered. If I then reset the port number to
> 1433 and restart the SQL service all my mail attempts executed when the
> server was set up on another port get delivered.It seems they queue until the
> server is set up with 1433 and then get delivered.
> Is this a bug or have i missed a config setting?
>
> cheers
>
> jon
|
|
|
|
|
JonBird
|
Posted: Thu Sep 28 10:33:02 CDT 2006 |
Top |
SQL Server >> SQL 2005 Mail
tibor,
Thanks - exactly the issue
jon
> My guess is that because of the port change, DatabaseMail90.exe cannot logon to SQL Server anymore.
> You should be able to find some info at
> ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/bc124164-eb6e-4b7f-bf66-98a3113d02f7.htm which might
> help with debugging. Perhaps it is as simple as adding a Client config alias with the machine name
> specifying the new port...
>
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
>
> >I have an issue with SQL mail on SQL 2005, if i set up the server to listen
> > on port 1433 all is fine, however, once i configure the server to listen on
> > another port mail does not get delivered. If I then reset the port number to
> > 1433 and restart the SQL service all my mail attempts executed when the
> > server was set up on another port get delivered.It seems they queue until the
> > server is set up with 1433 and then get delivered.
> > Is this a bug or have i missed a config setting?
> >
> > cheers
> >
> > jon
>
>
|
|
|
|
|
|
|