Smartconnector upgraded from 2.4 -> 2.5 now unable to login

[sesa113537]

Hi all

i upgraded SC ver.2,4 into 2.5, main reason for this was a lost admin's password. i uninstalled SC but still cant login with default adminpw or with one i had, any ideas? 

-LHa

[ardak]

Hi,

Unless you choose to remove the database in the uninstall, the password and configuration will not be reset.

If you have forgotten the password you could delete all the users directly in the database. You can use SQL Server Management Studio and run this query, adjust for your database name:

DELETE
FROM [SmartConnector.User].[dbo].[AspNetUsers] WHERE 1 = 1

This will reset all users and the default user will be created again.

BR

Armend

[sesa113537]

Hi 

thx for the answer, i actually did remove SQL database  (by default)  and checked with management studio that everything in fact is gone, it was. After a clean install i still cant log in... any more ideas? 

[ardak]

Ok, great!

That's interesting, could you attach the relevant Smartconnector log?

Armend

[sesa113537]

Hi, Indeed i could

--------------

2022-05-24 12:08:25.8070,Trace,Database,<no principal>,Setting Database Execution Strategy to SqlAzureExecutionStrategy.,
2022-05-24 12:08:28.5257,Status,Service,<no principal>,SmartConnector is starting,
2022-05-24 12:08:28.5414,Status,Service,<no principal>,Intializing User DB context,
2022-05-24 12:08:29.0257,Info,Service,<no principal>,Cleaning up orphaned ParameterSet instances,
2022-05-24 12:08:29.1820,Status,Service,<no principal>,Ensuring Service Broker is enabled,
2022-05-24 12:08:29.1976,Status,Service,<no principal>,Spinning up WorkerManager,
2022-05-24 12:08:29.1976,Status,WorkerManager,<no principal>,Mongoose WorkerManager running with 5 Processor threads.,
2022-05-24 12:08:29.9320,Status,Service,<no principal>,Attaching context listeners,
2022-05-24 12:08:30.0414,Status,Service,<no principal>,Starting PortalAddress,
2022-05-24 12:08:30.8070,Info,Service,<no principal>,No service license found, please install a license.,

--------------

[ardak]

Nothing else after that, no errors?

Could you attach the connectionStrings from Mongoose.Service.exe.config (from installation directory)? You can redact the username and password if they are sensitive.

BR

Armend

[sesa113537]

im wondering that sqlexpress -part.. 

 <connectionStrings>
<add name="SmartConnectorDb" providerName="System.Data.SqlClient" connectionString="Server=RAUNET2SCHNEIDE;Database=SmartConnector.Service;User Id=sa;Password=password!" />
<add name="SmartConnectorUserDb" providerName="System.Data.SqlClient" connectionString="Server=RAUNET2SCHNEIDE;Database=SmartConnector.User;User Id=sa;Password=password" />
</connectionStrings>
<appSettings>
<add key="EncryptionKey" value="127698D8DFA4B0B01A506D323113DA0C8649EE8A4942517945B9C5427AA0E885" />
</appSettings>
<!--<connectionStrings>
<add name="SmartConnectorDb" providerName="System.Data.SqlClient" connectionString="Server=localhost\SQLEXPRESS;Database=SmartConnector.Service;User Id=sa;Password=Admin!23" />
<add name="SmartConnectorUserDb" providerName="System.Data.SqlClient" connectionString="Server=localhost\SQLEXPRESS;Database=SmartConnector.User;User Id=sa;Password=Admin!23" />
</connectionStrings>

[ardak]

Hi,

This means that you have selected SQL Express during installation. Is this maybe the problem, you have a SQL Server database and not SQL Express? 

Armend