question

SharmindhLakshmanan-6152 avatar image
0 Votes"
SharmindhLakshmanan-6152 asked saldana-msft edited

MEM Configmgr 2002

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 this90342-1619087455371.jpg


sql-server-generalmem-cm-general
1619087455371.jpg (2.6 MiB)
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Any advise on this

The first adivse is already in the error message: "Click the View Log button for more information."

0 Votes 0 ·
HanyunZhu-MSFT avatar image
0 Votes"
HanyunZhu-MSFT answered

@SharmindhLakshmanan-6152

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.
90731-1.png
Confirm that the account has permission to Create any database in the propertities of the SQL Server.
90732-21.png 90733-22.png
2) Local Users and Groups
Check if the current account is an administrator of the local machine.
90734-3.png

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.



1.png (162.3 KiB)
21.png (136.3 KiB)
22.png (116.7 KiB)
3.png (79.7 KiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SharmindhLakshmanan-6152 avatar image
0 Votes"
SharmindhLakshmanan-6152 answered

@HanyunZhu-MSFT

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. 90992-log.jpg



log.jpg (2.9 MiB)
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

HanyunZhu-MSFT avatar image
0 Votes"
HanyunZhu-MSFT answered

@SharmindhLakshmanan-6152

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.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ColinFord-6663 avatar image
0 Votes"
ColinFord-6663 answered

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.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

SharmindhLakshmanan-6667 avatar image
1 Vote"
SharmindhLakshmanan-6667 answered HanyunZhu-MSFT commented

@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

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

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

0 Votes 0 ·