SQLMail On A Cluster Starts But Then Stops

Nov 11, 1998

I am trying to move SQLMail from a standard SQL 6.5 server to a virtual clustered SQL Server. The exchange profile has been set up and the services are running on a domain login. Exchange is also running as a clustered service which is being used successfully from the standalone SQL Server with SQL Mail.

However, when the SQL Mail service is started on the Clustered SQL Server, the service starts for about 5 seconds and then stops. The logs report that SQL Mail started but no messages are recorded to state that why the service has stopped again.

Any clues anyone please?

View 1 Replies

SQL Server Service Starts Then Stops

Mar 30, 2008

I have just installed SQL Server 2005. The machine had an expired version of SQL Express on it which I removed. Now when i go to open the Management Studio it says it can't connect. When I check the service, it is set to automatic using the local account but is not running. When I start it, it throws an error stating that it started and then stopped. The first error record in the log file states:

Server TCP provider failed to listen on [ 'any' <ipv4> 1433]. Tcp port is already in use.

Could this be causing the problem? How do I check to see what is using 1433? In general, what the heck did I do wrong during the install? One article said something about the new installation thinking it was still the expired version. Could there be something left in the registry from the old version of Express causing this?

Thanks in advance for the help

View 20 Replies View Related

SQL Server Agent Starts And Then Stops

Jan 13, 2007

SQL Server 2005 installed on Windows Vista Ultimate

When I try to start the agent, it return with the message that the service started and then stopped. On investigation I found that the Windows Event Log service won't start, returning the error:

"error 4201: the instance name passed was not recognized as valid by a WMI
data provider"

(I have posted this on Windows Vista forums but had no response).

Thanks for your help

View 2 Replies View Related

Service Starts Then Stops-Reporting Services

May 3, 2007

Hello,

I tried deploying a Report Model Project and received an error:

"TITLE: Microsoft Semantic Model Designer
------------------------------

A connection could not be made to the report server http://localhost/ReportServer.

------------------------------
ADDITIONAL INFORMATION:

The request failed with HTTP status 405: Method not allowed. (Microsoft.ReportingServices.SemanticQueryDesign)

------------------------------

When I checked services I realised that Reporting Services wasn't started. I tried starting it and received a message:

"The Sql Server Reporting Services (MSSQLServer) started and then stopped. Some services stop automatically if they have no work to do.........."

I also tried to start the service from Configure Report Server and received an error:

"System.ServiceProcess.TimeoutException: Time out has expired and the operation has not been completed.
at System.ServiceProcess.ServiceController.WaitForStatus(ServiceControllerStatus desiredStatus, TimeSpan timeout)
at ReportServicesConfigUI.Panels.ServerInformationPanel.StartStopServiceTask(Boolean start)"

Any idea why this is happening? Should I install SP2?

View 3 Replies View Related

SQLMail Does Not Work On 7.0 Cluster

Jul 16, 2001

I recently set up a SQL 7.0 cluster (active/passive) on a pair of Win2K boxes. I noticed that the SQLServerAgent would refuse to send system alerts to my e-mail account, yet net sent messages worked fine. I know I've set everything up properly, so I paid the $245 to speak with Microsoft.

The answer was found; their response follows:
{redacted}
CAUSE:
============
On a cluster an undocumented stored procedure is called by the Operator to send email and this causes it to fail. SQL Mail is not supported on SQL 7.0 clusters and any features depending on it will also fail.

RESOLUTION:
============
SQL 2000 does support SQL Mail on clusters with MS Office 2000 and up.
In SQL 2000 Books Online do a search for the following topics and include the quotes:
�Using SQL Server Tools with Failover Clustering�

Also you can workaround the problem by using a job that uses xp_sendmail to send the alert instead.
{END}

Now is that lame or what? Of all the functions you would expect to work in a failover cluster, you would think that e-mailing the operator in the event of a failure would be high on the list. Apparently, not so. Their official answer was to upgrade to SQL2000. Anybody care to guess the price on doing a dual CPU dual box cluster upgrade?

Now my question is this: The tech person was right, xp_sendmail does work fine. What I have wanting to do, and have been unable to do, is to write a TRIGGER that would fire whenever an error is logged by the SQL server. I have looked around, but could find no documentation on what table it is that receives error logs.

Does anybody know which table receives error messages? I'm wanting to write a trigger that exec's xp_sendmail so I get error alerts.