Failed To Start SQL MAil Session

Aug 18, 1999

Hello!
I created SQLServer account which suppose to launch MSSQLServer and
SQL mail serveces.
But when I try to stop and then run SQL Server through Command promt
I see error message:
" Starting SQL Mail session....
Error: 17903, Severity:18, state:1
MAPI login failure
Error: 17951, Severity:18, state:1
Failed to start SQL MAil session"
Please save my life. If you have any idea what I have to do to fix up
problem let me know.

Thank you.
Alona

View 1 Replies


ADVERTISEMENT

Failed To Start SQL Mail Session In Enterprise Manager

Jun 5, 2001

I cannot understand why I cannot get my sql mail to work properly. It was working fine a couple of days ago. My mail profile is setup using Outlook. The only problem is that when I go to services and check the Mssqlserver & sqlserveragent, they are now logging in as the system account, but when I attempt to change them to the administrator account it says error 1057 occured: the account name is invalid or does not exist, yet it does. Anyone have any idea how to rectify this? this is what is on the error log:Error: 17919, Severity: 18, State: 1
2001-06-05 14:09:16.33 ods Invalid session..
2001-06-05 14:09:16.34 ods Error: 17951, Severity: 18, State: 1
2001-06-05 14:09:16.34 ods Failed to start SQL Mail session..

Thanks,
Jerry

View 1 Replies View Related

Sql Server Mail Session

Jan 18, 2002

when i start mail session
there is a message poping up as
"Error 17952:Faild to Start SQl Mail Session"

When i test From Sql Mail Configuration
i get a message "succesfully Started(and stopped)a MAPI session with this profile"

& still i cannot start the sql mail service"
i still get a error

what could case for this error

View 1 Replies View Related

Unable To Start Sql Debug Session

Feb 27, 2004

Hi,

I get this error message each time i try to run the vb application in visual studio .net environment.
--------------------------------------------------------------------------------
"Unable to start SQL debug session. Ensure sqldbreg2.exe and proxy/stub DLL sqldbg.dll are registered on this machine"
-------------------------------------------------------------------------------

I am running visual studio and sql server 2000 on the same machine. I have given permission to sqldebugger user to access the system32 folder and sql debugging folder. This error message is followed by

-------------------------------------------------------------------------------
Attaching the T Sql debugger to process[proj1.exe] on machine 'my machine name' failed Error code 0x80004004
------------------------------------------------------------------------------

I am running MS SQL Server 2000 on windows 2000 adv server.

what can be done to remove this error. Thaks in advance

Sivaraj.

View 1 Replies View Related

Test For SQL Mail Session Started

Feb 27, 2001

I call a stored proc from an ASP page that eventually makes a call to xp_sendmail to email a confirmation back to our visitor. It all works fine as long as the Exchange Server hasn't crashed and therefore, rendered the SQL Mail session dead. Unfortunately, when this happens (which has been all too often recently), the web visitor gets the following message:

Number: -2147217900

Description: [Microsoft][ODBC SQL Server Driver][SQL Server]SQL Mail session is not started.

SQLState: 37000

Native Error: 17966

Is there a way I can check for this in the stored proc that calls xp_sendmail so I could still return to the ASP page and prevent the web visitor from seeing this error.

I've searched high and low to no avail.

Thanks,
Laura Stamps

View 1 Replies View Related

Sql Mail Session Startup Account

Mar 31, 2003

Hi,

Is there any way to use different email accounts for sql mail dynamically on sql server 2000?

Here is the problem:

My sql server is configured to start mail session under account 'xxnotifyxx'.

There are many jobs scheduled to run queries and send out emails to different user groups within the company as well as outside the company from 'xxnotifyxx' as a sender.

However, one of the usergroup within the company is asking for sending out their emails ( from scheduled tasks that uses xp_sendmail ) using 'publishergroup' as a sender.

As far as I know, this is not possible (sql server 2000, exchange 2000 client win2000 ) until I change the mail session configuration to start under 'publishergroup' in stead of 'xxnotifyxx'. If I do this, 9 other groups have problems with this.

Is there a work around for this kind of situation?

Thanks,
Shaili

:rolleyes:

View 1 Replies View Related

Configuring SQLServerAgent 2000 Mail Session

Apr 3, 2007

How do I configure the SQLServerAgent 2000 mail session? Do I need MS Outlook installed on the server?

View 1 Replies View Related

SQL Server Agent &> General Tab &> Mail Session Is Greyed Out ??

Feb 22, 2004

Hi All,

Great forum y'all have going here.

Just wondering if anyone else has experienced this?

Enterprise Manager:
I have setup and 'sucessfully tested a MAPI session' with a mail profile via support services > sql mail. That works fine, however in sql server agent properties the mail session section on the first general tab appears to be greyed out.

scenario is:
Windows Server 2003 SBS edition
SQL Server 2000 SP3
Exchange Server 2003 is also running on the server, with Outlook 2003 client (so i suspect side chaining issue).

Any help appreciated! did not have any luck googling or using microsoft KB.

View 12 Replies View Related

Sql Mail Failed., Need Help To Set Up Sql Mail In Sql Server 2000

Sep 26, 2001

Hi, I have created a profile named sqlmail in exchange server. I tried to run the sql mail service from support service under sql mail to put the profile name, I got the following error: can any one assist me in setting up sql mail in an sql server 2000. .... thanks
Ali

Microsoft SQL - DMO(ODBC SQLState: 42000)
Error 18025:xp_test_mapi_profile: failed with mail error 0x80004005

View 1 Replies View Related

SQL Mail Won't Start Help !!

Jul 10, 2001

Hi !!
I am trying to configure SQL mail with POP3 (Lotus notes) mail client. I created the mail profile, I am sure that my login and service logon account is the same, i have mail client working on my work station (i.e i can send and recieve mails on my lotus notes ID). I am running NT 4.0 / SQl 7.0

When i do a test profile on SQL MAIL properties i get
"ERROR 22030,A MAPI ERROR(ERROR NUMBER 87)OCCURED, MapiLogonEx FAIILED DUE TOMAPI ERROR 87; INVALID PARAMETER"

When i try an start my SQL MAIL, i get,
" Error 17952: Failed to Start mail session: "

Where am i going wrong guys ?

any insight would be apprecieted !!

i am running sevice pack 3 on sql server 7.0 and 6a on NT 4.0

Thanks

Girish

View 1 Replies View Related

SQL Mail Fails To Start

Jun 25, 2001

Hi,
My SQL Mail fails to Start. I am using Outlook Express as my mail client. I am not sure why it does not work in one of the servers when it works fine in another SQL Server. Any ideas. Help Appreciated.

Thanks,
Cynthia

View 2 Replies View Related

SQLAgent Mail Won't Start

Aug 28, 2000

2000-08-28 15:03:15.06 ods Starting SQL Mail session...
2000-08-28 15:03:15.18 ods Error: 17903, Severity: 18, State: 1
2000-08-28 15:03:15.18 ods MAPI login failure..
2000-08-28 15:03:15.18 ods Error: 17951, Severity: 18, State: 1
2000-08-28 15:03:15.18 ods Failed to start SQL Mail session

You know where to find the MAPI settings in NT?

View 1 Replies View Related

Auto Start Mail Client

Nov 4, 1998

We currently have SQL Server 6.5 installed on 2 servers and did not
specify to automatically start the mail client. When I display the Server
Configuration/Options screen in Enterprise Manager, the Auto Start Mail
Client check box option is grayed out. How can I change these servers to
automatically start the mail client at startup?

Thanks in advance!

View 3 Replies View Related

The Sql Server Failed To Start

Mar 8, 2007



hi there

My object is a database on a single machine to start with . i am running xp home

i am a complete newbie to this, so please bear with me.

i have vb 2005 express edition running on my machine. i then downloaded sqlexpress_adv adition and tried to install.

It checks the prerequisites "the required components were installed successfully"

goes to sql server install wizard , checks the sytem configuration , 15 success , 1

failure.

message = iis feature requirement warning. it says install via control panel / add /remove etc . ???????? it is not in the list of programs.

can i still carry on with the installation?. ( i did)

It gets to feature selection.The database services is marked. (hit next)

Instance name comes up . Default is ticked named instance "sqlexpress". (hit next)

It then says existing compomponents have been found. Select upgarde options below. I ticked sql server database services 9.00.1399.06. (details gives allowed upgrade)

(hit next)

windows authentication mode checked (hit next)

validating settings

then msbox != "the sql server failed to start, see books on line and log etc"

i goto the log

2007-03-08 11:08:54.62 spid5s Starting up database 'master'.
2007-03-08 11:08:54.73 spid5s WARNING: did not see LOP_CKPT_END.
2007-03-08 11:08:54.73 spid5s Error: 3414, Severity: 21, State: 2.
2007-03-08 11:08:54.73 spid5s An error occurred during recovery, preventing the database 'master' (database ID 1) from restarting. Diagnose the recovery errors and fix them, or restore from a known good backup. If errors are not corrected or expected, contact Technical Support.
2007-03-08 11:08:54.73 spid5s Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it. For more information about how to rebuild the master database, see SQL Server Books Online.



any help would be appreciated.

thanks

argoosy12



View 1 Replies View Related

Failed To Start Package

Sep 22, 2006

Hi,

I am getting the following error message, when I was trying to execute an existing SSIS Package which was working properly before.

"Failed to Start Package

Cannot communicate with the debug host process. Failed to obtain child process active object. (Microsoft.DataTransformationServices.VsIntegration)"

So I tried creating a new package and execute it, still I am getting the same error message.

If anyone have come across this problem and rectified it, pls let me know.

Thanks in advance for your help.

Regards,
Prakash Srinivasan

View 6 Replies View Related

SSIS Failed To Start

Jan 23, 2006

We installed the SQL Server 2005 Developer edition on one of our test server after uninstalling the beta version.   Also, we had to rename an entry in the registry to get the install (all components)  to work.   When I tried to start Integration Services (all the other servers started OK), I get the following error in the Event log.

 

Microsoft SSIS Service failed to start.

Error: Method 'GetVersionInfo' in type.

 

Any ideas on how to get SSIS to start.

 

 

 

View 2 Replies View Related

SQLExecutive Service Failed To Start

Mar 24, 1999

I am getting the following errors in the NT Event Log on a system using
SQL 6.5 SP3 on an NT 4.0 SP3 machine (with selected hotfixes). Perhaps
someone here will have experienced this problem. Any suggestions are
appreciated.

Service Control Manager - Event ID 7009
Timeout (120000 milliseconds) waiting for service to connect.

Service Control Manager - Event ID 7000
The SQLExecutive service failed to start due to the following error:
The service did not respond to the start or control request in a timely fashion.

Thanks,

Matt Combs
Product Development Engineer
Eaton Corporation - TISD
Clemmons, NC

View 1 Replies View Related

The SQL Server Service Failed To Start.

Sep 18, 2007

Hello,

I had installed SQL express yesterday, and it did function, but due some other problems, i uninstalled it, and reinstalled SQL express 2005. Appearantly, there is some rest of the old installation, blocking me to start a new installation.

The link provided by the program (below) does not connect to any page.
I would appreciate some help, thanks in advance.

Regards,

Ruud

TITLE: Microsoft SQL Server 2005 Setup
------------------------------
The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&EvtSrc=setup.rll&EvtID=29503&EvtType=sqlsetuplib%5cservice.cpp%40Do_sqlShutDownRANUInstance%40sqls%3a%3aService%3a%3aStart%40x3
------------------------------
BUTTONS:
&Retry
Cancel
------------------------------

View 1 Replies View Related

== The SQL Server Service Failed To Start ==

May 1, 2006

I'm newbe with SQL Server , I'm looking for help with sql server express edition 2005. At the end of installation ocurrs an error:

The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually.
Error Number : 29503 . (Summary file)
Rest of components has status : Successfully installed

I've go installed .Net Framework 2.0, I'm using XP with SP2 , no anty-virus software during instalatin is activated, the XP firewall is off during instalation.All system check requirements are passed successufully
(running on Athlon64)

No additional software bound with SQL is installed.(in add/remove programs there is nothing additional connected with sql)

I've re-installed it few times with some other options (network , local) ,different installation path ,but allways the same result - fail. I've tried to find help in few similar posts but that didn't help.Mayby i've miss somethin'

Could someone help ?

View 16 Replies View Related

The SQL Server Service Failed To Start

Jun 30, 2006

I have mentioned this problem before but it has not been resolved. I am installing MS SQL Server Express Advanced i.e. using SQLEXPR_ADV.EXE.

During the initial checks, i get a warning about hardware requirements and I have read the posts about the install failing if the CPU does not support prefetching but I am running a P4 3.0GHz (twin core) CPU with 512MB RAM on Windows XP Pro SP2.

The installation fails at SQL Server Database Services during "Configuring Microsoft SQL Server":

"Starting SQL Service: MSSQL$SQLEXPRESS"

If I click the Retry button, the system goes away and then comes back with the same message. If I click cancel, various roll-back actions are performed and the install fails

Is this the default name for the SQL Server instance ? I thought it would be named after my machine name i.e. GLKD239680SQLExpress ?

Any ideas anyone ? I have not had much luck with installing this despite 2 PC rebuilds and scanning the forums for solutions.... I can post any log files if needed

Thanks



View 1 Replies View Related

Report Service Failed To Start

Jun 14, 2005

New install of the June SQL 05 Standard CTP bits, the Report Service fails to start with the following errors.

View 7 Replies View Related

SQL-MAIL : MAPI LOGIN FAILED

Nov 22, 1999

Hi friends,

I have Exchange & sql 7.0 on the same box. I have configured sqlserver
and sqlserveragent for the same nt login. Also a Mail profile is created and assigned to SQL-MAIL & SQL-AGENT.

I have a back-up job in SQLSERVER and the notification is set to exchange mail box. For the first time after restarting the exchange services, the notification works fine. But for the subsequent job executions, the notification failed and the message is "MAPI LOGIN FAILED".

Can any one help me..

Thanx in advance.

regards
MANI

View 1 Replies View Related

SQL Server Failed To Start After Changing The Machine Name

Jan 30, 2004

hi all,
i am using SQL Server 7.0 . After changing the machine name the sqlserver is not starting. if i changed the machine name to the old name the server starts as usual. is there a solution for this problem. where can i change the machine name in the sql server configuration. so as to start it correctly...
thanks...
jinujose

View 2 Replies View Related

Attempt To Start Report Service Failed...

Mar 6, 2008

Hi all,
I'm new to SSRS. I installed reporting services with my other services in SQL Server 2005. When I started Reporting Service Configuration tool,I see that my Reporting Server Status Stopped. When i am trying to start the service, i get the following error(exception)....also attached are the logfiles....

EXCEPTION DETAILS:
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)

LOGFILE1:
-----------------------
------------------------------
ReportingServicesService!library!8!3/6/2008-20:26:48:: e ERROR: Sql error:System.Data.SqlClient.SqlException: Could not find stored procedure 'GetDBVersion'.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectDBVersion()
ReportingServicesService!library!8!3/6/2008-20:26:48:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportServerDatabaseException: The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportServerDatabaseException: The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights.
ReportingServicesService!library!8!3/6/2008-20:26:48:: Exception caught while starting service. Error: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportServerDatabaseException: The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights.
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectDBVersion()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
ReportingServicesService!library!8!3/6/2008-20:26:48:: Attempting to start service again...

LOGFILE2:
------------
--------------------
ReportingServicesService!library!4!3/6/2008-20:26:47:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'MACHINE_NAMEASPNET' is not recognized., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'MACHINE_NAMEASPNET' is not recognized.
ReportingServicesService!servicecontroller!9!3/6/2008-20:26:47:: Total Physical memory: 1063641088
ReportingServicesService!servicecontroller!4!3/6/2008-20:26:47:: e ERROR: Exception caught starting RPC server: Microsoft.ReportingServices.Diagnostics.Utilities.UnknownUserNameException: The user or group name 'MACHINE_NAMEASPNET' is not recognized.
at Microsoft.ReportingServices.Library.Native.NameToSid(String name)
at Microsoft.ReportingServices.Library.ServiceAppDomainController.StartRPCServer(Boolean firstTime)

The IIS Version I'm using is 5.1

View 5 Replies View Related

SQL Server Service Failed To Start During Setup!

Aug 30, 2006

I had a strange experience with MS SQL Server 2005 Express Edition installation, I am running a P4 3G Processor, 1 GB of RAM, Windows XP SP2, 300 GB HDD (SATA if it matters at all :) ) And using Visual Studio Pro 2005.

I have managed to install the SQL Express with no hassle at all, then had to format my HDD, and start from scratch, to make a new home for my VS 2005 Pro (The 300 GB HDD) And managed to install the SQL Express as part of the VS 2005 without any problems, after using it for 3 months now, I've started a new project in VS 2005, and tried to add a new SQL DB, but it had failed for several times.

I€™ve decided that the files got corrupted for some reason and tried to reinstall the MS SQL 2005 using the original SQL Express installation file I've used before, but without joy.

I thought that it is conflicting with some new MS Update patch and downloaded the latest SQL Express advanced installation, but that did not fix the problem either.

The message I'm getting every time I attempt the installation is" SQL Server service failed to start" with all the bla bla about the online books and whatever useless stuff to learn how to start the service manually.

I have uninstalled the whole thing, including VS 2005, .NET Framework, and any registry trace of the SQL Server installation, but again all in vain.

Finally, some smart wizard suggested in one of the threads that if your computer is not part of a domain, you should run the SQL service as a local service, using the advanced option during the first step of the setup.

And guess what! It worked!!!!
My Question is why did it work during the first two installations, without me fiddling with the advanced installation feature?
My computer was and still is, not part of any domain, my hardware did not change at all, and I had the installation failing with or without any software installed!

View 1 Replies View Related

Xp_sendmail: Failed With Mail Error 0x80040403

Jul 10, 2007

I'm trying to send an email using master..xp_sendmail with parms andthe default Outlook profile. I can successfully test the profile on myown computer and on the server.I'm running using Windows authentication and have given myself fulladmin rights in MSSQL.Which account is mssql trying to send the email from? Is it theservers or my local clients?The mailbox does not appear to be full and it's possible to send &receive emails on the server and on my own machine.What could be a possible cause or the next thing I can check?Thanks!

View 1 Replies View Related

Xp_sendmail Failed With Mail Error 0x80004005

Jul 20, 2005

Hello!My environment is: Win 2000 Server, MS SQL-Server 2000 (SP2)and MS ExchangeServer 5.5the two following TransactSQL-codepieces show differentresults:1. with attachmentmaster..xp_sendmail@recipients = 'j.hetzel@rac.de',@subject = 'test',@message = 'test',-- ******************************@attachments = 'c: est.txt',-- ******************************@no_output = 'False'-->18025 level 16 state 1 line 0xp_sendmail failed with mail error 0x800040052. without attachmentmaster..xp_sendmail@recipients = 'j.hetzel@rac.de',@subject = 'test',@message = 'test',-- ******************************-- @attachments = 'c: est.txt',-- ******************************@no_output = 'False'-->Mail sent.why am I not able to send emails with attachments?Who can help me???Thanks in advanceJürgen

View 2 Replies View Related

Send Mail Task Failed In SSIS

Dec 10, 2007

Hi

I am trying send email using my pop3 account in SSIS. No field found give password. Please help to how to configure my pop3 to send mails in SSIS.

Thanks and Regards

Balasubramani

View 1 Replies View Related

Xp_sendmail: Failed With Mail Error 0x80004005

Feb 28, 2008



I'm a user of SQL 2000//2005, and I'm trying to send files using SQL Mail.



I'm am successful when I send a file of approx 13MB in size but, when I try to send a 24MB file, I receive the above subject error.



Is anyone aware of a file size limitation on attachments?

View 13 Replies View Related

Xp_sendmail: Failed With Mail Error 0x80004005

Mar 6, 2008



After consulting with the Exchange Administrator, I was advise that there is a limit on file attachments. This explains why I get this message with large (>20MB) attachments.

With this additional information I need to compress my file using a compression tool like winzip or pkzip. My company uses the windows version of pkzip. However, I have downloaded an evaluation version of the PKzip command line version.

Can someone provide guidance how I can execute this utility within my sql procedure?

View 4 Replies View Related

SQL 2012 :: Server Profiler - Failed To Start A New Trace

Aug 3, 2014

I am attempting to create a new trace but I get the following error message: "failed to start a new trace".

I have been doing some digging and as I understand it, I had to find the directory Profiler uses for temporary files. So, I typed the following in the command window "SET TMP" and I received the following reply:

C:UsersRossAppDataLocalTemp

Now, according to the forum: [URL] ...

I am supposed to check that the system folder pointed to by the TMP environment variable exists and is not crammed with files.

Well, when I went to the directory C:UsersRossAppDataLocalTemp, it is indeed full of both files and directories. The size is 16.3 MB and has 133 files and 63 folders.

When I had a look at the Environment Variables window and chose TMP the value is "%USERPROFILE%AppDataLocalTemp" which according to my limited understanding is the equivalent to C:UsersRossAppDataLocalTemp.

So, what I am wondering is am I supposed to totally clear out this directory? I am not too keen on doing this because I don't want to stuff my PC up.

View 3 Replies View Related

SP2 Failed Only On The Database Engine; The MSSQLSERVER Service Cannot Start

Mar 18, 2007

  I tried to apply the SP2 on a newly installed SQL Server 2005 Developer edition. The installation failed and the MSSQLSERVER service does not start. I work on 32 bits Windows Server 2003 Standard Edition SP1 with all the patches up to date. I downloaded SQL Server 2005 SP2 on March 15, 2007.

Here are the error messages from 2 of the log files:

Summary.txt:

Product                   : Database Services (MSSQLSERVER)
Product Version (Previous): 1399
Product Version (Final)   :
Status                    : Failure
Log File                  : C:Program FilesMicrosoft SQL Server90Setup BootstrapLOGHotfixSQL9_Hotfix_KB921896_sqlrun_sql.msp.log
Error Number              : 29534
Error Description         : MSP Error: 29534  Service 'MSSQLSERVER' could not be started. Verify that you have sufficient privileges to start system services. The error code is (-2146885628) Cannot find object or property.

SQL9_Hotfix_KB921896_sqlrun_sql.msp.log:

Doing Action: ComponentUpgradeInstall
PerfTime Start: ComponentUpgradeInstall : Sun Mar 18 17:37:33 2007
<Func Name='ComponentUpgradeInstall'>
<Func Name='ComponentUpgrade'>
Failed to add file 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG' to datastore in AddFileToFailureHandling
Service MSSQLSERVER with parameters '-r' is being started at Sun Mar 18 17:37:33 2007
Failed to start service MSSQLSERVER. Error code 2148081668
Service failed unexpectedly (2148081668)
        Error Code: -2146885628
Windows Error Text: Cannot find object or property.
  Source File Name: sqlsetuplibservice.cpp
Compiler Timestamp: Wed Jun 14 16:29:04 2006
     Function Name: sqls::Service::Start
Source Line Number: 301

And below you can see the content of the SQL error log:

2007-03-18 19:46:11.51 Server      Microsoft SQL Server 2005 - 9.00.3042.00 (Intel X86)
 Feb  9 2007 22:47:07
 Copyright (c) 1988-2005 Microsoft Corporation
 Developer Edition on Windows NT 5.2 (Build 3790: Service Pack 1)

2007-03-18 19:46:11.51 Server      (c) 2005 Microsoft Corporation.
2007-03-18 19:46:11.51 Server      All rights reserved.
2007-03-18 19:46:11.53 Server      Server process ID is 796.
2007-03-18 19:46:11.53 Server      Authentication mode is WINDOWS-ONLY.
2007-03-18 19:46:11.53 Server      Logging SQL Server messages in file 'C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG'.
2007-03-18 19:46:11.53 Server      This instance of SQL Server last reported using a process ID of 712 at 3/18/2007 5:39:48 PM (local) 3/18/2007 3:39:48 PM (UTC). This is an informational message only; no user action is required.
2007-03-18 19:46:11.53 Server      Registry startup parameters:
2007-03-18 19:46:11.53 Server        -d C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmaster.mdf
2007-03-18 19:46:11.53 Server        -e C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLLOGERRORLOG
2007-03-18 19:46:11.53 Server        -l C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLDATAmastlog.ldf
2007-03-18 19:46:11.56 Server      SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2007-03-18 19:46:11.56 Server      Detected 2 CPUs. This is an informational message; no user action is required.
2007-03-18 19:46:11.87 Server      Using dynamic lock allocation.  Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node.  This is an informational message only.  No user action is required.
2007-03-18 19:46:11.98 Server      Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2007-03-18 19:46:14.06 Server      Attempting to recover in-doubt distributed transactions involving Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2007-03-18 19:46:14.06 Server      Database mirroring has been enabled on this instance of SQL Server.
2007-03-18 19:46:14.07 spid5s      Starting up database 'master'.
2007-03-18 19:46:14.15 spid5s      1 transactions rolled forward in database 'master' (1). This is an informational message only. No user action is required.
2007-03-18 19:46:14.17 spid5s      0 transactions rolled back in database 'master' (1). This is an informational message only. No user action is required.
2007-03-18 19:46:14.17 spid5s      Recovery is writing a checkpoint in database 'master' (1). This is an informational message only. No user action is required.
2007-03-18 19:46:14.37 spid5s      SQL Trace ID 1 was started by login "sa".
2007-03-18 19:46:14.42 spid5s      Starting up database 'mssqlsystemresource'.
2007-03-18 19:46:14.50 spid5s      The resource database build version is 9.00.3042. This is an informational message only. No user action is required.
2007-03-18 19:46:14.89 spid5s      Server name is 'YODA'. This is an informational message only. No user action is required.
2007-03-18 19:46:14.89 spid9s      Starting up database 'model'.
2007-03-18 19:46:15.06 spid9s      Clearing tempdb database.
2007-03-18 19:46:15.67 spid9s      Starting up database 'tempdb'.
2007-03-18 19:46:15.79 spid12s     The Service Broker protocol transport is disabled or not configured.
2007-03-18 19:46:15.79 spid12s     The Database Mirroring protocol transport is disabled or not configured.
2007-03-18 19:46:15.82 spid12s     Service Broker manager has started.
2007-03-18 19:46:21.62 Server      The server could not load the certificate it needs to initiate an SSL connection. It returned the following error: 0x8009030d. Check certificates to make sure they are valid.
2007-03-18 19:46:21.62 Server      Error: 17190, Severity: 16, State: 1.
2007-03-18 19:46:21.62 Server      FallBack certificate initialization failed with error code: 1.
2007-03-18 19:46:21.62 Server      Unable to initialize SSL encryption because a valid certificate could not be found, and it is not possible to create a self-signed certificate.
2007-03-18 19:46:21.64 Server      Error: 17182, Severity: 16, State: 1.
2007-03-18 19:46:21.64 Server      TDSSNIClient initialization failed with error 0x80092004, status code 0x80.
2007-03-18 19:46:21.64 Server      Error: 17182, Severity: 16, State: 1.
2007-03-18 19:46:21.64 Server      TDSSNIClient initialization failed with error 0x80092004, status code 0x1.
2007-03-18 19:46:21.64 Server      Error: 17826, Severity: 18, State: 3.
2007-03-18 19:46:21.64 Server      Could not start the network library because of an internal error in the network library. To determine the cause, review the errors immediately preceding this one in the error log.
2007-03-18 19:46:21.64 Server      Error: 17120, Severity: 16, State: 1.
2007-03-18 19:46:21.64 Server      SQL Server could not spawn FRunCM thread. Check the SQL Server error log and the Windows event logs for information about possible related problems.


Any advice???

 


 

 

 

View 14 Replies View Related

Reprt Service Failed To Start SQL 2005 Express

Apr 1, 2008

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)

i get the above error when attepting to install reporting services

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved