SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,210 questions
Whilst installing SQLServer, Comes up with error "Unable to install SQL Server (setup.exe)... Exit code (decimal): -2068119551... The target principal name is incorrect. Cannot generate SSPI context.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(233.6, 34%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ER%3C/text%3E%3C/svg%3E)
RBobz14
0
Reputation points
SQLServer_ERRORLOG_2024-07-06T21.00.28.txt
Log file. So is there any fix to this issue? I'm guessing it's something on my end.
{count} votes
-
Erland Sommarskog 105.8K Reputation points MVP2024-07-06T21:52:13.63+00:00 I think we also need to see the files summary.txt and detail.txt to understand the error.
I look in the log file you attached, and I find this:
2024-07-06 21:00:23.23 spid23s Error: 5177, Severity: 16, State: 1. 2024-07-06 21:00:23.23 spid23s An unexpected error occurred while checking the sector size for file 'C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS01\MSSQL\Template Data\tempdb.mdf'. Move the file to a local NTFS volume, where the sector size can be retrieved. Check the SQL Server error log for more information. 2024-07-06 21:00:23.23 spid23s GetActualSectorSize failed with error 4390 2024-07-06 21:00:23.24 spid23s Error: 5177, Severity: 16, State: 1. 2024-07-06 21:00:23.24 spid23s An unexpected error occurred while checking the sector size for file 'C:\Program Files\Microsoft SQL Server\MSSQL16.SQLEXPRESS01\MSSQL\Template Data\templog.ldf'. Move the file to a local NTFS volume, where the sector size can be retrieved. Check the SQL Server error log for more information. 2024-07-06 21:00:23.24 spid23s GetActualSectorSize failed with error 4390
NET HELPMSG 4390 tells me that The file or directory is not a reparse point. But what that implies, I don't know. I note that SQL Server has operated on other files in the Template Data folder earlier in the file without problems.
Am I right to understand that you are making this installation on a virtual machine?
Also, I note that the instance is called SQLEXPRESS01. Do you already have an instance SQLEXPRESS successfully running on this machine?
Sign in to comment