Error 3417 Sql Server 2008 Express
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn service specific error code 3417 sql server 2008 more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags
Error 3417 Sql Server 2005
Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, sql server error 3417 (0xd59) helping each other. Join them; it only takes a minute: Sign up Windows could not start the SQL Server (MSSQLSERVER) on Local Computer… (error code 3417) up vote 4 down vote favorite 2 For some reasons I moved erro 3417 sql server 2008 this folder : (Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL) to another drive, then returned it to the same location, but sql server has stopped working, showing this error when trying to start it again: "Windows could not start the SQL Server (MSSQLSERVER) on Local Computer. For more information, review the System Event Log. If this is a non-Microsoft service, contact the service vendor, and refer to service-specific error code 3417." I tried many solutions discussed in different forums, but
Erro 3417 Sql Server 2008 R2
none of them work for me. The folder is not compressed or encrypted. My sql server version is 2012: Microsoft SQL Server Management Studio 11.0.3128.0 Microsoft Analysis Services Client Tools 11.0.3128.0 Microsoft Data Access Components (MDAC) 6.1.7601.17514 Microsoft MSXML 3.0 4.0 6.0 Microsoft Internet Explorer 9.0.8112.16421 Microsoft .NET Framework 4.0.30319.18047 Operating System 6.1.7601 Thanks for your kind help in advance. sql-server share|improve this question asked Jun 24 '13 at 10:15 Kardo 3242622 1 Check that the account running the sql server service has access rights to the folder. –jpw Jun 24 '13 at 10:39 @jpw, The is fixed :) Thanks a lot for your short and perfect answer :) –Kardo Jun 24 '13 at 10:52 I ran into this problem after changing IPAll to use a specific port. Couldn't bring the server back online until the setting was changed back to Dynamic Ports. –Tim Jun 13 '15 at 12:05 add a comment| 8 Answers 8 active oldest votes up vote 6 down vote Check if you did compress the driver or folder in where you put the .mdf file. If so, plesae goto the driver or folder, change the compress option by Properties -> Advanced and unticked the “Compress contents to save disk space” checkbox. After above things, you should be able to start the service again. share|improve this answer answered Sep
(Русский)ישראל (עברית)المملكة العربية السعودية (العربية)ไทย (ไทย)대한민국 (한국어)中华人民共和国 (中文)台灣 (中文)日本 (日本語) HomeLibraryLearnDownloadsTroubleshootingCommunityForums Ask a question Quick access Forums home Browse forums users FAQ Search related threads Remove From My Forums Answered by: Service terminated with error 3417 SQL Server > SQL Server Express Question 0 Sign in to vote Yesterday I had error code 3417 sql server service won't start a working SQL Server Express (SP2) running on my Vista box, but today (and service specific error code 3417 sql server 2008 r2 I'm pretty sure I haven't messed with the configuration of SQL Server or Vista itself) the service won't start. The event viewer shows
Error Code 3417 Sql Server 2005
the following error: The SQL Server (SQLEXPRESS) service terminated with service-specific error 3417 (0xD59). Any ideas? Wednesday, March 07, 2007 8:57 AM Reply | Quote Answers 6 Sign in to vote in my case , http://stackoverflow.com/questions/17273021/windows-could-not-start-the-sql-server-mssqlserver-on-local-computer-error MSSQLSERVICE stopped after I commpress all folders where SQL is installed, I uncommpressed the entire folder of SQL Server. It resolved the problem. Proposed as answer by DianaGh Wednesday, March 02, 2011 12:36 PM Marked as answer by Naomi NModerator Friday, December 30, 2011 6:43 PM Friday, June 22, 2007 12:59 AM Reply | Quote 3 Sign in to vote The SQL Server folder and the data file folders should https://social.msdn.microsoft.com/Forums/sqlserver/en-US/28fb9e8e-d469-42f3-9061-e534f168f73e/service-terminated-with-error-3417?forum=sqlexpress not be compressed as thi is not supported.Jens K. Suessmeyer.---http://www.sqlserver2005.de--- Proposed as answer by BFeely Thursday, June 04, 2009 5:15 PM Marked as answer by Jens K. Suessmeyer -Microsoft employee, Moderator Sunday, June 21, 2009 7:27 AM Friday, June 22, 2007 11:43 AM Reply | Quote Moderator 2 Sign in to vote Hi to all and thanx!It worked for me: the NETWORK SERVICE account, that was set to be the one to run SQL Server, had no access to the folder where master db residedThough I did not touch permissions at all, it ended up in this situation.Thanx again. Marked as answer by Naomi NModerator Thursday, December 29, 2011 5:00 AM Tuesday, October 23, 2007 1:17 AM Reply | Quote 1 Sign in to vote Thanks a lot atomy. I did compress files on my laptop, which stopped SQL Service from accessing Master database MDF file. I uncompressed the MDF files in SQL Server folder, which fixed the issue. Proposed as answer by BFeely Thursday, June 04, 2009 5:11 PM Marked as answer by Jens K. Suessmeyer -Microsoft employee, Moderator Sunday, June 21, 2009 7:27 AM Wednesday, June 03, 2009 4:22 PM Reply | Quote 0 Sign in to vote gkakas wrote: Hi to all and thanx!It worked for me: the NETWO
Du siehst YouTube auf Deutsch. Du kannst diese Einstellung unten ändern. Learn more You're viewing YouTube in German. You can https://www.youtube.com/watch?v=hhZSmsLtWsw change this preference below. Schließen Ja, ich möchte sie behalten Rückgängig machen Schließen Dieses Video ist nicht verfügbar. WiedergabelisteWarteschlangeWiedergabelisteWarteschlange Alle entfernenBeenden Wird geladen... http://ronsownblog.blogspot.com/2008/10/fix-sql-server-error-3417.html Wiedergabeliste Warteschlange __count__/__total__ Know How to Solve SQL Server Error 3417 Jason Clark AbonnierenAbonniertAbo beenden1010 Wird geladen... Wird geladen... Wird verarbeitet... Hinzufügen sql server Möchtest du dieses Video später noch einmal ansehen? Wenn du bei YouTube angemeldet bist, kannst du dieses Video zu einer Playlist hinzufügen. Anmelden Teilen Mehr Melden Möchtest du dieses Video melden? Melde dich an, um unangemessene Inhalte zu melden. Anmelden Statistik 3.829 Aufrufe 3 Dieses Video 3417 sql server gefällt dir? Melde dich bei YouTube an, damit dein Feedback gezählt wird. Anmelden 4 3 Dieses Video gefällt dir nicht? Melde dich bei YouTube an, damit dein Feedback gezählt wird. Anmelden 4 Wird geladen... Wird geladen... Wird geladen... Die Bewertungsfunktion ist nach Ausleihen des Videos verfügbar. Diese Funktion ist zurzeit nicht verfügbar. Bitte versuche es später erneut. Veröffentlicht am 13.12.2015Microsoft SQL Server Error 3417 shows SQL Server cannot start the master database. This video tutorial shows how to fix Error code 3417. For more information must visit: http://www.sqlrecoverysoftware.net/bl... Kategorie Wissenschaft & Technik Lizenz Standard-YouTube-Lizenz Mehr anzeigen Weniger anzeigen Wird geladen... Autoplay Wenn Autoplay aktiviert ist, wird die Wiedergabe automatisch mit einem der aktuellen Videovorschläge fortgesetzt. Nächstes Video cant start sql server service - Dauer: 2:38 Besi Zaim 10.539 Aufrufe 2:38 How to Enable Remo
tune: access is denied .. occurred while creating or opening file *.mdf or *.ldfSolution:Try starting the service after each methodMethod A) Goto %ProgramFiles%\Microsoft SQL Server\MSSQL.2\MSSQL\Datayou see some (or all) of the files being blue (bluish, whatever)Goto folder properties->Attributes->Advanced->Compress or Encrypt Attributes:Uncheck the 'compress' option.Uncheck the 'encrypt' option as well.Method B) Goto %ProgramFiles%\Microsoft SQL Server\MSSQL.2\MSSQL\DataGoto folder properties->Attributes->ReadonlyUncheck the 'read-only' optionMethod C) Goto %ProgramFiles%\Microsoft SQL Server\90\Tools\BinnOpen theRun 'sqldiag.exe'* At this stage if MSSQL is still upset with you, re-installation is a Microsoft magic trick that's worth a try.* One may also consider checking the credentials / group policies (although it us assumed these things were checked prior to visiting this place)* Word of advice - you are facing this situation because SQL Server (on your system) is a disabled / manual process which is not used to frequently, it would be better to run some sort of maintenance on it now and then. Posted by Ronojoy at 11:53 AM Labels: Database, Microsoft SQL Server 4 comments: aparna john said... Hi, To keep everything organized, you will be able to use HTML editors that are not part of the code changes the colour and Web Design Cochin content, and make sure that the code is complete and correct.Thanks..... September 23, 2013 at 2:56 AM enrique mallon said... You can more abruptly fix this SQL Server database Error 3417 without inducing any type of distortion. Must visit:- http://www.sqlrecoverysoftware.net/blog/sql-error-3417.html June 26, 2014 at 2:00 AM Chris Martin said... I too have same issue but and was very frustrating but thanks to solution My friends suggested me. March 17, 2016 at 2:50 AM Kaye R. Jenkins said... Use SQL Database Repair utility repairs all your SQL server database tables, views, triggers, stored procedures, user defined