web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Supply chain | Supply Chain Management, Commerce / Store commerce offline...
Supply chain | Supply Chain Management, Commerce
Answered

Store commerce offline installation SQL connection error

(0) ShareShare
ReportReport
Posted on by MYGz 2,473
I'm trying to install Store commerce app 10.0.46 in offline mode but unable to pass
 
Step 10/26 : Executing step Microsoft.Dynamics.Commerce.Installers.Framework.Database.CheckSqlServerPrerequisiteStep: Check SQL Server prerequisites
 
All these pre-requisites are completed:
.net runtime 6
.net sdk 8
registry entries for TLS1.2 and disable 1.0
.net frameworks 2.x.x., 4.x.x.x in Microsoft node & WOW6432Node
SQL mixed mode authentication
SQL Server 2022 Standard
 
I'm able to connect to SQL through SSMS with same user.
 
Command used to install:
.\StoreCommerce.Installer install --installoffline --sqlservername ComputerName\MSSQLSERVER --trustsqlservercertificate
 
FULL ERROR:
21:51:16 [Information] ExecutingStep [10/26] Executing step Microsoft.Dynamics.Commerce.Installers.Framework.Database.CheckSqlServerPrerequisiteStep: Check S
QL Server prerequisites
21:51:30 [Error] DbAvailabilityCheckFailedWithWin32Error An attempt to check DB availability by leveraging the connection string 'Data Source=F15\MSSQLSERVER
;Initial Catalog=master;Integrated Security=True;Persist Security Info=False;Pooling=True;Encrypt=True;TrustServerCertificate=True' failed with Win32 error a
s follows. Errorcode: -2147467259. NativeErrorCode: 87.
The 'F15\MSSQLSERVER' SQL Server instance was not found, please provide a correct SQL Server instance name via the --SqlServerName parameter.
System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The ser
ver was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: S
QL Network Interfaces, error: 25 - Connection string is not valid) ---> System.ComponentModel.Win32Exception (0x80004005): The parameter is incorrect
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential
, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, Session
Data reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderMa
nager)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbC
onnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbCo
nnectionPoolKey poolKey, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnect
ion)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolea
n onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionPool.WaitForPendingOpen()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Microsoft.Dynamics.Commerce.Installers.Framework.Database.SqlServerService.<CheckDbAvailability>d__8.MoveNext()
ClientConnectionId:00000000-0000-0000-0000-000000000000
Error Number:87,State:0,Class:20
21:51:30 [Error] FailureException A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not fou
nd or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Inte
rfaces, error: 25 - Connection string is not valid)
System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The ser
ver was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: S
QL Network Interfaces, error: 25 - Connection string is not valid) ---> System.ComponentModel.Win32Exception (0x80004005): The parameter is incorrect
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential
, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, Session
Data reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling, SqlAuthenticationProviderManager sqlAuthProviderMa
nager)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbC
onnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbCo
nnectionPoolKey poolKey, DbConnectionOptions userOptions)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnect
ion)
   at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolea
n onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
   at System.Data.ProviderBase.DbConnectionPool.WaitForPendingOpen()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Microsoft.Dynamics.Commerce.Installers.Framework.Database.SqlServerService.<CheckDbAvailability>d__8.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Microsoft.Dynamics.Commerce.Installers.Framework.Database.SqlServerService.<LocateServerInstance>d__7.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Microsoft.Dynamics.Commerce.Installers.Framework.Database.CheckSqlServerPrerequisiteStep.<Run>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at Microsoft.Dynamics.Commerce.Installers.Framework.InstallerFramework.<Run>d__12.MoveNext()
ClientConnectionId:00000000-0000-0000-0000-000000000000
Error Number:87,State:0,Class:20
21:51:30 [Information] LogsSavedToDirectory Logs were saved to 'C:\ProgramData\Microsoft Dynamics 365\10.0\logs\Store Commerce_20260424185109'
21:51:30 [Information] NeedHelpMessage If you need help, contact your system administrator and provide this operation ID: 2d98d336bd64f41d674172159d5da656
 
 
 
Categories:
Dynamics 365 Commerce
I have the same question (0)
  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 305,849 Super User 2026 Season 1 on at
    Hi MYGz,

    When you read the error log, then most likely this is not about the user account, but the connection string. It mentions that the SQL Server instance can't be found. You can try to replace the computer name with a dot (.). Is the SQL Server instance name the default name or was another name chosen?
     
  • MYGz Profile Picture
    MYGz 2,473 on at
     
    I already tried ".\MSSQLSERVER", It's throwing same error. SQL Server name is default.
  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 305,849 Super User 2026 Season 1 on at
    Is the SQL server on the same machine as where you install Store Commerce? If so, you can try to remove the sqlserver parameter. It will then take the default instance settings.  
  • Verified answer
    CU27041317-0 Profile Picture
    CU27041317-0 7 on at
    You can try the following:
     
    1. Open SSMS and check if you are able to connect to the sql server installed in your local machine. If you are not able to connect through SSMS as well then enable the MSSQL service from services.msc
    2. Probably the server name you passed in the installation parameter is wrong, to get the exact name, login to SSMS and right click on server name and copy the servername details and use it in your installation command.
  • MYGz Profile Picture
    MYGz 2,473 on at
    @André Arnaud de Calavon Yeah, Already tried removing the flag, below is the error, it's bit different:
     
    19:41:08 [Information] ExecutingStep [9/26] Executing step Microsoft.Dynamics.Commerce.Installers.StoreCommerce.ValidatePrerequisitesStep
19:41:10 [Information] ExecutingStep [10/26] Executing step Microsoft.Dynamics.Commerce.Installers.Framework.Database.CheckSqlServerPrerequisiteStep: Check S
QL Server prerequisites
19:41:10 [Information] ConnectionEstablished Successfully established connection with SQL Server by leveraging the connection string 'Data Source=(local);Ini
tial Catalog=master;Integrated Security=True;Persist Security Info=False;Pooling=True;Encrypt=True;TrustServerCertificate=True'.
19:41:10 [Information] SqlServerVersionValidated Successfully validated that SQL Server's version 16.0.1000.6 is a supported one.
19:41:10 [Warning] FullTextSearchNotEnabled FULL TEXT SEARCH is not enabled on the DB server 'Data Source=(local);Initial Catalog=master;Integrated Security=
True;Persist Security Info=False;Pooling=True;Encrypt=True;TrustServerCertificate=True'.
19:41:10 [Error] ExpectedFailureException Microsoft.Dynamics.Commerce.Installers.Framework.InstallerException: SQL Server name was not provided to the instal
ler neither installer could locate a supported instance of default SQL Server.
   at Microsoft.Dynamics.Commerce.Installers.Framework.Database.SqlServerService.<LocateServerInstance>d__7.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Microsoft.Dynamics.Commerce.Installers.Framework.Database.CheckSqlServerPrerequisiteStep.<Run>d__6.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at Microsoft.Dynamics.Commerce.Installers.Framework.InstallerFramework.<Run>d__12.MoveNext()
19:41:10 [Information] LogsSavedToDirectory Logs were saved to 'C:\ProgramData\Microsoft Dynamics 365\10.0\logs\Store Commerce_20260427164100'
19:41:10 [Information] NeedHelpMessage If you need help, contact your system administrator and provide this operation ID: f98ee7ec70814b955cbbba92efb1ae4c
     
     
    @CU27041317-0 Yeah I'm able to access with SSMS with both options specified in the database :Default as well as MSSQLSERVER
     
  • Verified answer
    MYGz Profile Picture
    MYGz 2,473 on at

    Did a few things don't know which one worked:

     

    Command:

    .\StoreCommerce.Installer.exe install --installoffline --sqlservername ComputerName --trustsqlservercertificate

     

    Reinstalled SQL with Full Text search, increased access in security on SQL instance and Master db. Explicitly added user on master db.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch!
Ask A Community Pro
Introducing our New Video Series: Community Spotlight

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > Supply chain | Supply Chain Management, Commerce

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 149 Super User 2026 Season 1

#2
Abhilash Warrier Profile Picture

Abhilash Warrier 102 Super User 2026 Season 1

#3
Subra Profile Picture

Subra 92

Last 30 days Overall leaderboard

Featured topics

Quality order uses default receipt location instead of actual physical receipt location

Product updates

Dynamics 365 release plans