Colleagues,
please help with an issue I have when trying to install Acumatica local demo instance on my new laptop. Here is the error:
Best answer by vkumar
View originalIssues with local instance installation (Windows 11)
Userlevel 5
+1
Hi
Can you please make sure that you are given the correct SQL credentials (username and password)?
Userlevel 7
+16
HI
Along with what
Userlevel 7
+17
Hi,
and provide the correct MS SQL server credentials.
Userlevel 5
+1
I am a dummy when it comes to the hardware :( How do I find the server’s name? Looks like the SQL Server was not installed correctly? see below. Do you know if Windows 11 works with Server 2019?
Userlevel 7
+10
Hi
If you look in your Control Panel, Programs/Features, do you see Microsoft SQL Server installed on your Windows 11 machine? If so, look and see if you can open SQL Management Studio from your Start menu. If you are able to open SQL Management Studio, you should be able to connect to your local instance using the name of your computer which can be found in Control Panel, System
Userlevel 5
+1
MySQL is SQL Express so I entered it as recommended in the training. The installation went great, but the instance is not opening. See the attached PDF with the path.
Userlevel 5
+1
Error:
Userlevel 7
+17
Do you have installed Visual Studio in your computer? if yes, you can check the SQL Server details in the Web.Config and modify if they were wrong.
Hi. You cannot install Acumatica on Windows 11 due to issue with Windows 11 not recognising MS-SQL server. (Database Engine Services)
This was my finding when I tried to install Acumatica on Windows 11.
ERROR
Feature: Database Engine Services
Status: Failed
Reason for failure: An error occurred during the setup process of the feature.
Next Step: Use the following information to resolve the error, uninstall this feature, and then run the setup process again.
Component name: SQL Server Database Engine Services Instance Features
Component error code: 0x851A001A
Error description: Wait on the Database Engine recovery handle failed. Check the SQL Server error log for potential causes.
CAUSE
During service startup, SQL Server begins the database recovery process to ensure database consistency. Part of this database recovery process involves consistency checks on the underlying filesystem before attempting the activity of opening system and
user database files. On systems running Windows 11, some new storage devices and device drivers will expose a disk sector size greater than the supported 4 KB sector size.
When this occurs, SQL Server will be unable to start due to the unsupported file system as SQL Server currently supports sector storage sizes of 512 bytes and 4 KB.
SOLUTION FROM WINDOWS
https://learn.microsoft.com/en-us/troubleshoot/sql/admin/troubleshoot-os-4kb-disk-sector-size
I had to downgrade my laptop back to Windows 10 and Acumatica can be installed.
Userlevel 7
+10
Put just the computer machine name in the server name field...and then click the button for Reload the List
Userlevel 7
+10
Yeah, I guess the ball is in Microsoft’s court ?
Userlevel 1
I have Acumatica installed on Windows 11 and have did not run into issues when installing. I installed SQL from the below link with the most recent version of Acumatica 2022R2
https://www.microsoft.com/en-us/sql-server/developer-tools
I have Acumatica installed on Windows 11 and have did not run into issues when installing. I installed SQL from the below link with the most recent version of Acumatica 2022R2
https://www.microsoft.com/en-us/sql-server/developer-tools
Thanks. Will try this.
Hi
MS SQL installation may fail on windows 11 with specific SSD hardware. So, it may work on some based on the SSD used on specific system you are trying to install. There are several threads on web with regards to this issue. I have not been able to install on my laptop as well. Here is a link which would help.
Hope this helps,
Regards,
Userlevel 5
+1
Thank you, colleagues!
Update: I was not able to connect the database, it’s way way out my expertise.
Hovewer, the Report designer app got installed and works just fine. That’s really sad that we are not able to install a demo instance on a laptop with Windows 11; this may lead to issues with new user trainings.
Hope, this will get resolved soon.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.