Cannot connect SQL after update to 21H2

Question

So previously i was using SQL express 2014 and my app was working just fine. After update it does not work, i tried completely uninstalling, reinstalling the software and also removing and reinstalling all instances of SQL, i also tried using SQL expres 2019 and nothing. At the end of my setup of when i launch my software this is the message it. Can anyone help please.

---

Problem with Microsoft SQL Server installation for inFlow

---

----------------------- INSTALLER.LOG -----------------------

---

System information:

---

Windows version: ,

Service Pack:

Windows version: 6.2

Windows server name:

System type: 64

OS Language: 1033

---

---

Installation settings:

---

inFlow version: 2.3.2.1

Install option: 1

Selected language: English

---

Installation starts... (current time: Time=21:32:47)

Checking for Windows Installer ...

Windows Installer Version found: 5.0.19041.1766, required version at least 3.1

Finished checking Windows Installer.

Checking your Microsoft .NET Framework version ...

.NET Framework Version found: 2.0.50727, equal or newer to required version: 2.0.

Database Server Version found: 9.00.4035.00, required version at least 9.0

Finish checking database server. Result: 0

Reporting Engine not found.

Finished checking Reporting Engine.

Start extracting files for the basic components...

(current time: Time=21:32:47)

Finish extracting files, current time: Time=21:33:11

Finished installing Reporting Engine. Return code: 0

SQLPassword=fs2DRQhyy7

Updating the application configuration file ...

Finished updating the application configuration file.

Creating ODBC connection for DESKTOP-ERKC6NA\inFlowSQL

ODBC registry key: SOFTWARE\ODBC\ODBC.INI\local-sql

---

SQL Setup Troubleshooter Log:

---

10 Aug 2022 01:33:33 INFO [ 1] - Attaching database...

10 Aug 2022 01:33:33 INFO [ 1] - Attaching DB using script: C:\Program Files (x86)\inFlow Inventory\attachDB.sql

10 Aug 2022 01:33:33 INFO [ 1] - Attaching DB using script: C:\Program Files (x86)\inFlow Inventory\attachDB.sql

10 Aug 2022 01:33:33 INFO [ 1] - RunSQLCMD working dir: C:\Program Files (x86)\inFlow Inventory\

10 Aug 2022 01:33:33 INFO [ 1] - RunSQLCMD command: sqlcmd -S .\INFLOWSQL -i attachDB.sql

10 Aug 2022 01:33:42 INFO [ 1] -

10 Aug 2022 01:33:42 INFO [ 1] - Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : SQL Server Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF]. .

Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : Login timeout expired.

Sqlcmd: Error: Microsoft ODBC Driver 17 for SQL Server : A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online..

10 Aug 2022 01:33:42 INFO [ 1] - Command process return value: 1

10 Aug 2022 01:33:42 INFO [ 1] - RunSQLCMD return value: 1

10 Aug 2022 01:33:42 INFO [ 1] - Attach DB return code: 1

10 Aug 2022 01:33:42 INFO [ 1] - Enabling CLR...

10 Aug 2022 01:33:58 INFO [ 1] - Attaching DB throws exception: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server 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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

10 Aug 2022 01:33:58 INFO [ 1] - at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject, Boolean withFailover)

at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject, Boolean withFailover)

at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)

at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)

at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)

at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)

at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)

at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)

at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)

at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)

at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)

at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

at System.Data.SqlClient.SqlConnection.Open()

at Archon.Rapid.Base.ConnectionManager.get_Connection()

at Archon.Rapid.Base.CLRUpdatesHelper.ExecuteSQLAndReturnOutput(String command)

at Archon.Rapid.Base.CLRUpdatesHelper.EnableCLR()

at Archon.Rapid.Base.SQLServerManager.AttachDBAndUpdateCLRObjects(String instanceName)

10 Aug 2022 01:33:58 INFO [ 1] - Exiting with return code: 300

---

Server installation finished.

Writing uninstaller info ...

Finished writing uninstaller info.

Updating registry values ...

Client Installation Finished! (current time: Time=21:34:44)

----------------------- SUMMARY.TXT -----------------------

Could not find Microsoft SQL Server installation Summary.txt file.

Answer 1

Arshadi -

I wish we could help but we do not handle server issues here at all. I gave you links to the forums where this is dealt with, enough you should be ble to get help quick there if you will post in the correct forum.

Answer 2

Thanks. I will try. However it is an issue with windows and SQL installation, anything helps.

Answer 3

Hi Arshad. I'm Greg, 10 years awarded Windows MVP, here to help you.

Please ask server questions at our sister forums for IT Professionals, Q&A forums here: https://docs.microsoft.com/en-US/answers/index.... as Microsoft Community is strictly an end-consumer forum.

Solutions we give here will conflict with Group Policy which is not used in consumer Windows at all.

There are also equally good (and sometimes busier) IT Pro forums here:

https://www.techrepublic.com/forums/

https://www.spiceworks.com/

I hope it helps.