Ms Sql Server 2005 Service-specific Error Code-2146885628
Contents |
My language of choice is C# in Windows, ASP.NET Web Forms, and MVC. My latest dabblings have been with Android Applications, ASP.NET AJAX enabled websites, ASP.NET MVC, Silverlight, and HTML5. Categories .NET Framework (6) the sql server service terminated with service-specific error %%-2146885628. AJAX (6) ASP.NET (5) ASP.NET MVC (17) Collections (4) Comparisons (1) Crystal Reports (3)
Error 26014 Severity 16 State 1
Dependency Injection (1) Extension Methods (3) Hashing (1) HTML5 (3) IIS (2) jQuery (6) LINQ (7) Networking (2) Office Automation (1)
Tdssniclient Initialization Failed With Error 0x80092004
Security (3) Silverlight (4) Sorting (3) SQL (13) String Manipulation (11) Time and Date (2) Uncategorized (1) Unit Testing (1) Visual Studio (2) Windows 7 (7) Windows Forms (7) Tag Cloud .NET Framework 64-bit 404 550
Add Network Service To Local Administrators Group
ActiveX AJAX ASP.NET ASP.NET AJAX Toolkit ASP.NET MVC authentication Bananagrams Bandwidth C# Canvas Casting Client Side Validation Collections ComboBox Comparisons Crystal Reports DataGridView Date Dependency Injection dialog Extension Method FTP Game Hashing HTML5 IIS Iversion of Control JavaScript jQuery jQuery UI LINQ LINQ to XML List ListView Mail Merge MD5 Microsoft Word Mocking Moq MVC Networking Ninject Numbers Office Automation Parsing qTip Random Routing Security Server Side Validation Set Silverlight SMSS windows could not start the sql server on local computer error code 3417 Sorting Split SQL SSL SSMS String Strings Time Truncate Unit Testing Validation version Visual Studio Windows 7 Windows Forms Windows Gadget Windows Installer WordPress SQL: SSL and SQL Server 2008 - Service Doesn't Start - Error Code26014 September 8, 2010 -- Nick Olsen After requesting the SSL certificate and getting it in the correct format to import into the server's Personal Certificate Store using the steps found here, I was finally ready to select the certificate and encrypt the database traffic. As outlined here I selected the correct SSL certificate set the ForceEncryption flag to Yes. After doing such, I went to restart the SQL service as told and was presented with the following error: "Windows could not start the SQL Server (XXXXX) on Local Computer. For more information, review the System Event Log… and refer to service-specific error code 2146885628" Instead of the System Event Log I went straight to the SQL Error Log (using the default installation the error logs are found in C:\Program Files\Microsoft SQL Server\MSSQL10_50.InstanceName/MSSQL/Log) and found the following information: 2010-09-08 12:35:30.76 Server Unable to load user-specified certificate [Cert Hash(sha1) "XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX"]. The server will not accept a connection. You should verify that the certificate is correctly installed. See "Configuring Certificate for Use by SSL" in Books On
Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 2005 » SQL Server 2005 configuring certificate for use by ssl General Discussion » could not start the SQL Server(MSSQLSERVER)... 15 posts,Page 1 of unable to load user-specified certificate cert hash(sha1) 212»» could not start the SQL Server(MSSQLSERVER) Service on local computer. Rate Topic Display Mode Topic Options Author Message raymraym windows could not start the sql server (mssqlserver) service on local computer error 1069 Posted Monday, April 13, 2009 6:31 AM SSC Journeyman Group: General Forum Members Last Login: Sunday, April 26, 2009 7:37 AM Points: 87, Visits: 307 Hi,I installed sql server 2005 on my machine https://nickstips.wordpress.com/2010/09/08/sql-ssl-and-sql-server-2008-service-doesnt-start-error-code-2146885628/ i keep getting the following errors......when i start up the services I get the following services..Could not start the SQL Server(MSSQLSERVER) Service on local computer.Error 3: The system cannot find the path specifiedan error has occured while establishing a connection to the server. when connecting to sql server 2005, this failure may be faused by the fact that under the default seetings Sql server does not allow http://www.sqlservercentral.com/Forums/Topic695691-149-1.aspx remote connections.How can I fix it Post #695691 Mohit K. GuptaMohit K. Gupta Posted Monday, April 13, 2009 12:07 PM SSC Eights! Group: General Forum Members Last Login: Tuesday, March 29, 2016 10:39 AM Points: 942, Visits: 1,089 Check to confirm the SQL Install completed successfully and your setup path information for the master database is correct.You can you use "SQL Server Configuration Manager" to see the startup parameters for the SQLServer Service.Mohit. ---Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN.Microsoft FTE - SQL Server PFE * Some time its the search that counts, not the finding...* I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. How to ask for help .. Read Best Practices here. Post #696016 raymraym Posted Monday, April 13, 2009 3:28 PM SSC Journeyman Group: General Forum Members Last Login: Sunday, April 26, 2009 7:37 AM Points: 87, Visits: 307 These are the startup parameters in my Sql Server Configuration path-dC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf;-eC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG;-lC:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldfDump Directory - C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\I'm not sure if this is wha
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time https://www.experts-exchange.com/questions/24015458/Server-SQL-2005-does-NOT-Start.html Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > Server SQL 2005 does NOT Start Want to Advertise Here? Solved Server SQL 2005 does NOT Start sql server Posted on 2008-12-30 MS SQL Server 2005 1 Verified Solution 12 Comments 4,348 Views Last Modified: 2012-05-06 I have SQL 2005 with the following info: Microsoft SQL Server Management Studio 9.00.4028.00 Microsoft Analysis Services Client Tools 2005.090.4028.00 Microsoft Data Access Components (MDAC 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158) Microsoft MSXML 2.6 3.0 5.0 6.0 Microsoft Internet Explorer 7.0.5730.13 Microsoft .NET Framework the sql server 2.0.50727.42 Operating System 5.1.2600 1) While trying to connect to my SQL server by running the Sever Management Studio it is giving me: &.SQL Server does not allow remote connections &Named Pipes Provider, error: 40 - Could not connect; Microsoft SQL Server Error: 2 I tried all posibilities, runing Local connections only, and/or local and remote. I use this server only for my own use, not shared and not used by remote. 2) While trying to start the service SQL Server (MSSQLSERVER) I get: error -2146885628 3) At the Event Log I get the error: Event Type: Error Event Source: Service Control Manager Event Category: None Event ID: 7024 Date: 12/30/2008 Time: 3:48:58 PM User: N/A Computer: PCAVI Description: The SQL Server (MSSQLSERVER) service terminated with service-specific error 2148081668 (0x80092004). 4) See results of netstat -o at the code section This problem happened after installing MySQL which uses the port 3306 (and is working fine), now my MS SQL 2005 is not connecting and I can not Start th