Service specific error code 3417

Sometimes, when trying to start SQL Server service manually, SQL Server error 3417 may occur. The complete error message reads as:

“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.”

Before discussing the reasons behind the SQL service error 3417 and workarounds to fix it, let’s first look at a few user instances reporting the error.

Occurrences of SQL Error 3417

Instance 1: In this instance, a user reported that when moving the folder: (Program FilesMicrosoft SQL ServerMSSQL11.MSSQLSERVERMSSQL) to another drive, the SQL server stopped working. On trying to start the server again, it displayed an error message: “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.”

Instance 2: When trying to connect to SQL Server to run a web project, a user received an error message: “A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 40 – Error Locating Server/Instance Specified)”

The user found that SQL Server Express stopped working in SQL Server Configuration Manager. On attempting to run SQL Server Express, the service did not respond. And when the user tried opening services.msc to start a SQL Server (SQLEXPRESS instance), it returned the “Windows could not start the SQL Server (SQLEXPRESS) on local computer” error message with error code 3417.

What Causes SQL Server Error 3417?

You may encounter this error when the SQL Server doesn’t start due to any of these reasons:

• “Master database or tempdb cannot be brought online.” This event may occur when the db is damaged due to hardware or software failure.
• The folder containing the MDF and NDF files is compressed.
• Folder permission issue where the db file resides.

Tip: SQL Server error 3417 can render the SQL database inaccessible. While there are manual workarounds, troubleshooting using these workarounds can take significant time and increase db downtime. Use a SQL repair tool to restore the db in a few simple clicks.    

How to Fix SQL Server Error 3417?

Try the following workarounds in the sequence given below to resolve MS SQL error 3417:

Workaround 1: Decompress SQL Database MDF File

When you cannot open the master database, check if the master database file (.mdf) is compressed. If the file is compressed, you will need to decompress it. To do so, follow these steps:

Step 1: Browse and locate the Microsoft SQL Server data folder containing db (MDF and NDF) files.

Note: You can locate the SQL server data folder by browsing the location: “C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData”.

Step 2: Right-click on the SQL Server data folder. The Microsoft SQL Server Properties window gets displayed. Click Advanced.

Step 3: In the Advanced Attributes dialog box that appears, uncheck the Compress contents to save disk space checkbox, and then click OK.

Step 4: The Microsoft SQL Server Properties dialog box opens again. Click on the Apply button, and then hit OK. When the Confirm Attribute Changes box pops-up, click OK.

Step 5: Click Continue to proceed.

Step 6: Wait for the attribute changes to complete. Once the changes have been applied, click OK.

After performing these steps, try starting the SQL Server service again. If the error persists, proceed with the next workaround.

Workaround 2: Check for Folder Permissions

Note: This SQL error 3417 fix applies to users who receive the error while moving a folder to another drive.

Make sure that the account that runs the SQL Server service has access rights (network permissions) to the folder containing the SQL db files. If not, follow these steps to grant the right to the folder:

Step 1: Go to the SQL files folder and right-click on it, and then choose Properties.

Step 2: From the Properties box, click the Security tab.

Step 3: In the dialog box that pops-up, choose the Network Service account under the Group or user names: section.

Step 4: Select the Full control checkbox under the Permissions for Authenticated Users section, and hit the OK button.

Now check if running the SQL Server instance starts without the error.

Workaround 3: Rebuild Master Database

We can restore master db from the most recent full database backup, but only if the SQL Server instance is running. Since we cannot start the server instance, rebuilding the master db might help fix the 3417 error.

Refer to this link for more information on rebuilding the master database.

Workaround 4: Repair MDF File

If rebuilding the master db doesn’t help resolve the error, the chances are that the master db file is severely corrupt. In that case, you can try to repair the corrupted MDF file. For more information on repairing the db file, read this: Repairing Corrupt MDF File of SQL Server Database.

Conclusion

You may encounter SQL Server error 3417 when trying to start the SQL Server service. The error may occur when you cannot bring online the master or tempdb, the folder containing the database (.mdf or .ndf) files is compressed, or you don’t have access rights on the folder. You can try to resolve the issue by following the manual workarounds discussed in this post. However, troubleshooting SQL error 3417 manually can be time-consuming and increases database downtime. A better approach is to use a specialized SQL database repair tool such as Stellar Repair for MS SQL to repair the MDF file and fix the error.

Не удалось запустить службу SQL Server на Локальный компьютер. Подробности содержатся в журнале системных событий. Если эта служба разработана не в Майкрософт, обратитесь к разработчику службы, и сообщите специфический для этой службы код ошибки…:

Код ошибки 13

Решение:

При появлении данной ошибки необходимо зайти в Пуск → Microsoft SQL Server → Средства настройки → Диспетчер конфигурации SQL Server / SQL ServerConfiguration Manager → Конфигурация сети SQL Server → Протоколы для SQLEXPRESS и проверить, включены ли протоколы (все протоколы должны быть включены).

Код ошибки 1814

Вариант ошибки на английском:
Windows could not start the SQL Server 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 — 1814.

Причина: Ошибка возникает, когда по какой-то причине путь к файлам базы по умолчанию не соответствует действительному.

Решение:
Возможно в папке C:Program FilesMicrosoft SQL ServerMSSQL10_50.SQLEXPRESSMSSQLDATA нет необходимых файлов. Необходимо добавить с заменой файлы из папки C:Program FilesMicrosoft SQL ServerMSSQL10_50.SQLEXPRESSMSSQLTemplateData.

Код ошибки 3417

Решение:

Перед заменой файлов рекомендуется сохранить копию папки Data в отдельной директории.

Cкопировать данные из C:Program FilesMicrosoft SQL ServerMSSQLXXXMSSQLTemplate Data в C:Program FilesMicrosoft SQL ServerMSSQLXXXMSSQLDATA

Для 64-разрядных систем — C:Program Files (x86)Microsoft SQL ServerMSSQLXXXMSSQLTemplate Data в C:Program Files (x86)Microsoft SQL ServerMSSQLXXXMSSQLDATA

Если замена файлов не помогла, необходимо дать права на папку Microsoft SQL Server.

Код ошибки 17058

Решение:

Необходимо дать полные права на папки C:Program FilesMicrosoft SQL Server и C:Program Files (x86)Microsoft SQL Server. Если данное решение не поможет — в свойствах службы на вкладке Вход в систему поставьте флаг С системной учетной записью.

Код ошибки 17113

Решение:

Перед заменой файлов рекомендуется сохранить копию папки Data в отдельной директории.

Cкопировать данные из C:Program FilesMicrosoft SQL ServerMSSQLXXXMSSQLTemplate Data в C:Program FilesMicrosoft SQL ServerMSSQLXXXMSSQLDATA

Error 3417 is an SQL server error that appears in Windows when data files become inaccessible.

Fortunately, there are several solutions for troubleshooting this SQL error.

Here, at Bobcares our Support Engineers are handling this SQL error frequently as a part of our Server Management Services.

In this article, we’re going to show you what the “SQL server 3417 error”  looks like and how our Support Engineers help to fix it.

Let’s get to work!

Why SQL server 3417 error?

Before we look into the error details, let’s understand what MDF and NDF are?

MDF and NDF files are primary and secondary data files of a SQL server database.

Due to many reasons, these data files get infected and make them inaccessible.

Today, let’s discuss the reasons and how our Support Engineers fix it for our customers.

What are the reasons?

There are many reasons for SQL Server Error 3417 to occur. This include:

Hardware failure, Virus intrusion, changes or modification in windows settings, Improper shutdown, etc.

Let’s see how we handle such scenarios.

How we sort out SQL Server 3417 error?

Recently, one of our customers having a dedicated server approached us with SQL error 3417 as shown:

We did some basic checks like virus attack, hardware failure, etc. But that was not the reason.

Finally, we found that due to an unexpected database server shutdown, the customer was unable to start the SQL server again.

Our Support Engineers checked in detail and found that the MDF file got compressed and need to decompress it.

To decompress we followed the steps:

• We navigated to the MSSQL data folder. The default location of the MDF files was present in C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData.

Note: The location of the data folder will differ based on the Windows architecture and location of installation.

• We verified the MDF files. Selected the compressed MDF file, right-click on the file, and clicked on properties.
• Next, we clicked on the advanced button and unchecked “Compress contents to save disk space” and click ok.
• Then, uncheck the compress option.

This fixed the error.

It also ensures the prevention of occurring the error in the future.

We also handled the scenarios:

1. No network permission for the Network Service account.

Network Service account and the windows user needs to have full permission for the data folder. For granting full permission, we followed the steps:

•  In the Data folder >> clicked on Security/Permission settings.
•  Then added the Network Service account.

This fixed the SQL Server error of our customer.

2. Hardware failure

One of our customers encountered SQL error 3417 due to hardware failure.

In this case, our Support Engineers restored the database from the backup.

We always make sure to restore it from the recent copy of the SQL database.

3.SQL corruption

We handled a scenario, in which the above two fixes did not work as it was due to SQL corruption. So, here we used the SQL Database Recovery tool for recovering the database to fix the error.

Our Support Engineers do all the possible checks to find a perfect fit for our customers.

[Need more assistance to solve SQL Server 3417 error? We’re available 24/7 to help you.]

Conclusion

In short, SQL server 3417 error occurs due to many reasons including, hardware failure, unexpected database server shutdown, etc. Today, we discussed in detail how our Support Engineers fix it for our customers.

var google_conversion_label = «owonCMyG5nEQ0aD71QM»;

Read time 5 minutes

SQL Server errors are quite talked about among the experts. And the users have many queries about them on a regular basis. Sometimes internal factors are responsible for the SQL Server errors but sometimes they get generated due to users’ activities. For example, it can cause an error after shifting SQL Server folder like (Program FilesMicrosoft SQL ServerMSSQL11.MSSQLSERVERMSSQL) from its original location to another location and then moving it back to the original location.

These issues ultimately affect the SQL Server database files (MDF and NDF) and deny users the access to them.

Users often lodge their queries regarding the SQL Server Error with code number “3417”. The error happens when the user is trying to connect to the SQL Server. The error message displays like this.

'Windows could not start the SQL Server (MSSQLSERVER) service on local computer error 3417. For more information review the System Event Log.'

As the error message itself mentions, you should check the system event log to know the reason behind this error. Move to Event Viewer via SQL Server Management Studio by following the path:

Management >> Extended Events >> SQL Server Logs >> View >> SQL Server Log

Next, choose your Error log and check its details.

We are listing out the possible causes for the occurrence of this SQL Server Error 3417.

This error can occur when there is –

• Intentional or unintentional modification in the Windows Settings (SQL Server folder shifting)
• Compression of the folder in which SQL database files are residing
• Inconsistent Network account for Data folder
• Corruption in SQL Database files owing to hardware failure, virus intrusions, sudden supply down, etc.

These causes behind this error should not be ignored.

Some Simple Ways to Fix SQL Server Error 3417

We suggest you to try these free manual solutions in order to get relief from the annoying SQL Server Error 3417 which hinders in the access to the SQL Server data.

Decompress SQL Folders

If SQL Server folders is compressed, then it could be the cause behind this SQL Server Error 3417. To check it, follow the steps:

1. First, move to the SQL Server Data folder location –

   C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData – for 32-bit Windows
   C:Program Files(x86)Microsoft SQL ServerMSSQL.1MSSQLData – for 64-bit Windows

2. Right-click on the folder containing the SQL database files (MDF and NDF) and click on the Properties option.
3. In the opened Properties dialogue box, click on the Advanced button.
4. Next, clear the checkbox Compress contents to save disk space. Then, click OK.
5. Close the Properties dialogue box and try restarting or launching the SQL Server by connecting it from the Server Manager.

   Note: This method of decompressing the SQL Server folder is only applicable if you have compressed that folder or drive earlier at any point of time.

Assigning Network Service Permission to SQL Data Folder

This is another manual way using which you can fix SQL Server Error 3417. Use the following steps to grant network permissions to the folder containing the SQL Server files.

1. Navigate to the SQL files folder using the location – C:Program FilesMicrosoft SQL ServerMSSQL.1MSSQLData. Right click on the folder and click Properties option.
2. In the Properties dialogue box, move to the Security tab.
3. Select the Network Service account and assign Full control Permission under Permissions for Authenticated Users section and click on OK.
4. Now, check after running the SQL Server instance if it starts without the error.

Repair Corrupt SQL Database Files

In some cases, the reason for this error would be the corrupted SQL Server database files.

Then the first step should be restoring SQL data from the most recent backup file using Microsoft SQL Server Management Studio. But, sometimes the SQL backup may not available or restoring SQL database from the backup may fail. In that case, the most feasible way is to repair the corrupt SQL database files. Though we have manual solutions including SQL Server commands like DBCC CHECKDB to repair corrupt SQL database files, they may not ensure the complete repair of database files. So, users may remain unsure about fixing this SQL Server Error 3417.

What Is the Best Fix For You?

In this article, we intend you to provide all the methods to fix SQL Server Error 3417. And after explaining the primary solutions for you, we conclude it with a professional solution which could be quite helpful for you. We are talking about the most efficiently programmed SQL Database Recovery.

The tool as its name suggests recovers highly corrupted SQL Database files. It recovers all SQL database objects precisely and displays it before saving to two destinations which are Live SQL Server or the Batch File. The tool supports all SQL Server versions and can be tested with the free demo version on its software website. This powerful solution is capable to fix all SQL Server errors and issues in the SQL Server database files.

Wrapping Up

This blog explains the most viable manual solutions available for fixing the SQL Server error 3417. It also explains the limitations of manual repair method of SQL database files and recommends the most popular SQL Database Recovery tool.