error: Setup cannot create the database on the SQL Server
Tried multiple reinstallations of both SQL 2017 and CM, getting the same error.
Any advise on this
error: Setup cannot create the database on the SQL Server
Tried multiple reinstallations of both SQL 2017 and CM, getting the same error.
Any advise on this
Any advise on this
The first adivse is already in the error message: "Click the View Log button for more information."
Thanks for posting in Microsoft Q&A forum.
Could you please share your ConfigMgrSetup.log with the sensitive information masked, in which may provide specific reasons for the error.
Accroding to the existing information, this problem may caused by that the current login machine account does not have sufficient permissions.
It is recommended to check the permissions of the machine account from two places first:
1) Microsoft SQL Server Management Studio
Check whether the account is the System administrator, through the path: Security > Server Roles > sysadmin.

Confirm that the account has permission to Create any database in the propertities of the SQL Server.

2) Local Users and Groups
Check if the current account is an administrator of the local machine.

Hope the above information is helpful to you.
If the response is helpful, please click "Accept Answer"and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Thank you so much for your quick and detailed reply.
Checked all the setting you mentioned, tried reinstalling CM again after confirming the settings.
I am still facing the same error code. 
Thanks for your updated information.
First you can check whether there is any database that remains due to previous installation in SQL Server Management Studio.
1) Connect to an instance of SQL Server Database Engine in object explorer.
2) Expand Databases.
3) If there is any remaining database, right-click it and choose Delete.
Then you can try to install ConfigMgr again.
If the installation still fails, it is suggested to delete the SQL instance and install new.
To uninstall the instance of SQL Server, you can refer to this article: https://docs.microsoft.com/en-us/sql/sql-server/install/uninstall-an-existing-instance-of-sql-server-setup?view=sql-server-ver15&tabs=Windows10 to confirm that the instance is completely deleted.
If the above two methods fail, it is better to upload the latest complete ConfigMgrSetup.log (with the sensitive information masked).
If the response is helpful, please click "Accept Answer"and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Connect to the SQL instance using SQL Server Management Studio and check if there is a database called CM_***. If so, this was left over from the previous install. Remove it from SQL manually (provided you don't need it) and retry the MEMCM installation.
@ColinFord-6663 @HanyunZhu-MSFT
Thank you for your support and suggestions.
The problem has been resolved after several attempts.
Due to a corrupted iso file, a new copy of MECM2103 was downloaded.
It functions flawlessly.
Thanks
Hi,
We are glad that the problem was solved. And thank you for the feedback and sharing, it may help others who have the similar issue with you.
If you have any questions in future, we welcome you to post in Microsoft Q&A forum again.
Have a nice day!
Best Regards,
Alan
18 people are following this question.