This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(121.6, 62%, 21%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERD%3C/text%3E%3C/svg%3E)
Hello,
after installation of SQLServer 2022 there is a Error:
2023-05-16 17:24:57.35 spid35s Starting up database 'model_replicatedmaster'.
2023-05-16 17:24:57.35 spid39s Starting up database 'model'.
2023-05-16 17:24:57.36 spid39s Error: 17204, Severity: 16, State: 1.
2023-05-16 17:24:57.36 spid39s FCB::Open failed: Could not open file D:\dbs\sh\5uj5\1008_054209\cmd\11\obj\x64retail\sql\mkmastr\databases\mkmastr.nativeproj\model.mdf for file number 1. OS error: 3(Das System kann den angegebenen Pfad nicht finden.).
2023-05-16 17:24:57.36 spid39s Error: 5120, Severity: 16, State: 101.
2023-05-16 17:24:57.36 spid39s Unable to open the physical file "D:\dbs\sh\5uj5\1008_054209\cmd\11\obj\x64retail\sql\mkmastr\databases\mkmastr.nativeproj\model.mdf". Operating system error 3: "3(Das System kann den angegebenen Pfad nicht finden.)".
2023-05-16 17:24:57.36 spid39s Error: 17207, Severity: 16, State: 1.
2023-05-16 17:24:57.36 spid39s FileMgr::StartLogFiles: Operating system error 2(Das System kann die angegebene Datei nicht finden.) occurred while creating or opening file 'D:\dbs\sh\5uj5\1008_054209\cmd\11\obj\x64retail\sql\mkmastr\databases\mkmastr.nativeproj\modellog.ldf'. Diagnose and correct the operating system error, and retry the operation.
2023-05-16 17:24:57.36 spid39s File activation failure. The physical file name "D:\dbs\sh\5uj5\1008_054209\cmd\11\obj\x64retail\sql\mkmastr\databases\mkmastr.nativeproj\modellog.ldf" may be incorrect.
2023-05-16 17:24:57.36 spid39s Error: 945, Severity: 14, State: 2.
2023-05-16 17:24:57.36 spid39s Database 'model' cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details.
The problem is "D:\dbs\sh\5uj5\1008_054209\cmd\11\obj\x64retail\sql\mkmastr\databases\mkmastr.nativeproj\model.mdf" because nowhere during installtion I wrote "D:" and of course the model.mdf is stored at "C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\DATA"
How can I fix this problem?!?
Thx, Ralf
![](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(128, 52%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EKM%3C/text%3E%3C/svg%3E)
Hi Ralf,
The Open-Specifications tags handle requests related to Open Specifications documentation issues.
The Open Specifications can be found at: http://msdn.microsoft.com/en-us/library/cc203350.aspx.
Your question does not appear to be related to the Open Specifications documentation set.
I have removed the tag and added the "SQL Server" tag in hopes that it will get you to people who can help.
-Kristian S
Support Escalation Engineer
Microsoft Open Specifications
Thank you very much for the answer. But I seem to be "too stupid" - when I open the link here in Germany, I only get to the "https://learn.microsoft.com/de-de/". All attempts to find the page via other ways fail for me.
I Attach the whole error-log.
Eh, Kristian's post was only to point out that you had added an inappropriate tag to your post and that he had removed. He also tried to give you a pointer what Open Specifications is about. But there is no relation to your actual problem.
Hello to all.
Solved!!! The only reason ist "Samsung HD".
a) deinstall SQL-Server
b) Adding registry-key
REG ADD "HKLM\SYSTEM\CurrentControlSet\Services\stornvme\Parameters\Device" /v "ForcedPhysicalSectorSizeInBytes" /t REG_MULTI_SZ /d "* 4095" /f
c) starting machine again
d) installing SQL-Server
= no errors, works
Thanks to all!
Happy to hear that the problem is solved!
The issue with the Samsung disks is well-known, but it usually testifies itself with a different error. As for the last failed attempt, you did come one step further, as it now died on msdb being unavailable. But that is of little interest now.
Apart from model not being accessible, is the SQL Server instance running? If you run SELECT * FROM sys.master_files, what do you see?
It is possible that you can get this to work by running:
ALTER DATABASE model MODIFY FILE = (NAME = 'modeldev', FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\DATA\model.mdf')
ALTER DATABASE model MODIFY FILE = (NAME = 'modellog', FILENAME = 'C:\Program Files\Microsoft SQL Server\MSSQL16.MSSQLSERVER\MSSQL\DATA\modellog.mdf')
and then restart SQL Server. You need to verify that the files actually exists in those locations.
Sorry but SQL-Server ist not running. The problem occurs while starting the service.
I attach the error-log.
OK. The next attempt is to start SQL Server with the -f option for minimal configuration. In this mode, SQL Server only starts up master and tempdb. Now, since tempdb is created for model, this may not work but let's try it.
In SQL Server Configuration Manager, find the service, and double-click it. Select the tab Startup Parameters. Enter -f and press Add. Attempt to start the service. If the server starts, connect with SQLCMD and run the commands above.
I attach the error-log.
You said this in a couple of posts, but in fact you did not. Note that you need to rename it to ERRORLOG.txt for the forum software to accept it.
Hi - I tried it with -f - same procedure
An now I attach the new errolg log - with .txt - sorry didn'n know that
Thx
OK, we will have to try some more advanced stuff - or just scratch the installation and start over.
If you already have a D drive, create the exact path in the error message, and copy the files for model to this folder. Try now to start SQL Server and run the commands above. If SQL Server does not start, check the errorlog. If you get errors about Access is Denied, make sure that the service account for SQL Server has permission all the way down the path.
If you don't have a D drive, I guess you have a USB disk around, insert it and make sure that it gets the drive letter D.
By the way, you still did not manage to attach the file. Maybe you check after the posting and edit your post if needed.
Morning Erland,
I did so - and SQL-Server-Service ist starting :) - see attached log.
After that. I renamed the D:-Path - starting again - the same failure.
At C:... - the databases are changed (correct changed her date), except the two ones which are at D:\
So thanks for this step. And now it would be nice, when SQL-Server takes model.mdf and MSDBData.mdf from the correct place at C:...ERRORLOG 20230519-0934.txtERRORLOG 20230519-0944.txt
![](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(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
For "Error: 17204", you can refer to this thread.
https://stackoverflow.com/questions/28443791/sql-server-moved-files-cant-start-cant-configure
Best regards,
Percy Tang
see the attached error-file - this solution do not fit, because the service is not able to start...