debugsqlMinor
How to resolve "the specified account already exists" error during SQL Server 2008 R2 installation
Viewed 0 times
theerror2008existsduringsqlaccountinstallationalreadyresolve
Problem
I recently had a problem while installing Visual Studio 2012 and SQL Server 2008 R2 on a new development machine. My installation sequence was Visual Studio 2012 then install SQL Server 2008 R2.
An error occurred during the middle of SQL Server installation:
The specified account already exists.
I have spent my day trying to fix this problem.
An error occurred during the middle of SQL Server installation:
The specified account already exists.
I have spent my day trying to fix this problem.
Solution
First, search the installation log. In my instance it was under the following path:
In that log I found the following entries:
I then located the file
I then uninstalled the SQL Server Native Client and ran the installation for SQL Server again, success.
C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\*.*In that log I found the following entries:
2015-08-07 11:16:50 Slp: Sco: Attempting to open registry subkey
2015-08-07 11:16:50 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\VisualStudio\9.0
2015-08-07 11:16:50 Slp: Sco: Attempting to get registry value InstallDir
2015-08-07 11:16:50 Slp: Target package: "D:\shared\~~~~~\sqlncli.msi"
2015-08-07 11:16:51 Slp: MSI Error: 1316 The specified account already exists.I then located the file
sqlncli.msi and opened a command prompt to execute this command:msiexec /i "d:\[Your sqlncli.msi path]I then uninstalled the SQL Server Native Client and ran the installation for SQL Server again, success.
Code Snippets
C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\*.*2015-08-07 11:16:50 Slp: Sco: Attempting to open registry subkey
2015-08-07 11:16:50 Slp: Sco: Attempting to open registry subkey SOFTWARE\Microsoft\VisualStudio\9.0
2015-08-07 11:16:50 Slp: Sco: Attempting to get registry value InstallDir
2015-08-07 11:16:50 Slp: Target package: "D:\shared\~~~~~\sqlncli.msi"
2015-08-07 11:16:51 Slp: MSI Error: 1316 The specified account already exists.msiexec /i "d:\[Your sqlncli.msi path]Context
StackExchange Database Administrators Q#109306, answer score: 7
Revisions (0)
No revisions yet.