What is MS SQL Error 15105 ?
MS SQL error 15105 is an error message which occur when a user try to create database file backup to a network shared disk or when hosting database file on a network share is not supported, and as a result such error message event take place.
Generally, this error message is Displayed like the following :
Operating system error 5: “5(failed to retrieve text for this error. Reason: 15105)”.(Microsoft.SQLServer.Smo)
or it may also be displayed like following:
Cannot open backup device “\\xxxxxxxx\xxxx.bak”. Operating System Error 5 (failed to retrieve text for this error. Reason: 15105). (Microsoft.SQLServer.Smo)
or it may also appear like “Operating System Error 5 (Access Denied)” and this message is addressed to local disk on the network.
How is MS SQL error 15105 caused ?
MS SQL error 15105 is caused due to following stuffs.
- Trying to attach an .mdf file, that has not been detached properly.
- There might not be enough free space on the destination where the user wants to keep his database backup file.
- There might not be the permission to access the location of the backup file that is assigned in in the SQL Server service account.
- It may also be possibility that the location of the folder in the error message is not the same instance where the user want to restore the backup. In this case it’s unlikely that the service has access to the folder.
- If the user has copied the backup file from another computer, then the destination computer
- may block the file due to security reason.
- Corruption of Windows Operating System
- Attack of Viruses
- Incomplete software installation
- Excessive startup entries and registry errors.
How can MS SQL error 15105 be manually rectified ?
Before executing manual process, users are recommended to free the drive volume for the expansion of SQL backup files and run defragmentation processes.
MS SQL error 15105 can be manually rectified by following processes:
- Go to Network share location, where the actual folder is shared.
- Right click on that and click on “Sharing and Security” option on the drop-down box.
- In the opened box go to “Sharing” tab and then click Permissions settings.
- Give full access privilege to the account which is taking backup. If it is running under SQL server service account context then give full privileges to the domain account.
- Add necessary accounts and privileges and then click on Apply and OK.
- Now go to “Security” tab, add all accounts to whom you have given access permissions in Step 4 above and give them Full control or write privileges as considered necessary.
- Click Apply and then OK.
- Now try to take backup, there are chances to get successful results.
Note :- Since the above written manual processes are long and time consuming process, these may even can damage the user’s files, especially if any inexperienced user commits any mistake in executing theses processes. So users are preferred to use Stellar Phoenix SQL Database Repair software to automatically repair MS SQL error 15105.