Search

Monday, July 24, 2017

An instance with the same name is already installed on this computer. To proceed with SQL Server setup, provide a unique instance name.

You may get below error while installing SQL Server.

An instance with the same name is already installed on this computer. To proceed with SQL Server setup, provide a unique instance name.

The main reason of above error is:

The named Instance, you are trying to install is already present.
The existing instance of SQL Server 2008 is a unique named instance. However, you try to install SQL Server 2005 as the default instance.
The existing instance of SQL Server 2008 is a named instance, and you use the same name when you try to install SQL Server 2005 as a named instance.

Follow below steps to solve the error (Suppose you want to create instance name SQLExpress:
Click Start menu, select Run and type regedit
Navigate to
HKEY_LOCAL_MACHINE\System\CurrentControlSet\Services\
      Find “MSSQL$SQLExpress” , and delete
Go to HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server
     Remove "SQLExpress" from the REG_MULTI_SZ value named InstalledInstance
     Delete the subhive named MSSQL.1
     Delete the subhive named SQLExpress
Go to HKEY_LOCAL_MACHINE\Software\Microsoft\Microsoft SQL Server\Instance Names\SQL
    Delete the value named  "SQLExpress"
Go to SQL Server installation drive Delete the folder %ProgramFiles%\Microsoft SQL Server\MSSQL.1
Restart the PC.

Use either Windows installer cleanup utility to manually remove all traces of MSSQL in your PC.

Re-run SQL installation

Alternatively, you can try installing SQL Server with different instance name.

Monday, April 17, 2017

A non recoverable I/O error occurred on file while taking backup.

You may get this error while taking backup of databse. 
The reason for this error is insufficient disk space.
The solution is either free up some space or change the backup folder.

Friday, December 2, 2016

The media family on device '' is incorrectly formed. SQL Server cannot process this media family. RESTORE FILELIST is terminating abnormally.

Error:

The media family on device ‘<FILENAME.BAK>’ is incorrectly formed. SQL Server cannot process this media family. RESTORE FILELIST is terminating abnormally.

Solution:

Ensure that backup file is good and copied properly.
You can not restore higher version databse Backup in lower version SQL Server.

Friday, October 21, 2016

Error occurred during installation: Error 1618 installing Microsoft SQL Server setup Support files.

You may get below error during SQL server installation:

Error occurred during installation: Error 1618 installing Microsoft SQL Server setup Support files.

Follow below steps to solve the error:

  1. Restart The system and try installing.
  2. Start - Run - Type: gpedit.msc - OK - Navigate to

Computer Configuration\Windows Settings\Security Settings\Local Policies\User Rights Assignment\Debug programs
Add administrator user.

Monday, May 30, 2016

Login failed for user ‘domain\username’. Reason: Server is in single user mode. Only one administrator can connect at this time.

You may get below error some time after improper shutdown of system.

Login failed for user ‘domain\username’. Reason: Server is in single user mode. Only one administrator can connect at this time.

Restart SQL server and Browser and problem will be solved.