New installation fails connecting to imported database

[Ensenada]

Hello,

 

I exported (sql 2005) and imported (sql 2017) correctly the database. After install PS on a new W2019, i tried to configured PS as an other server of hight avaibility option pointing to the database server sql 2017 and o got this error:

 

An Error has occurred executing the Call 'QueryPasswordResetPortalSystemSettings' - SyslogUDP&stacktrace=   at System.Data.ProviderBase.FieldNameLookup.GetOrdinal(String fieldName)
   at System.Data.OleDb.OleDbDataReader.get_Item(String name)
   at (Object , String )
   at PasswordstateService.PasswordstateService.QueryPasswordResetPortalSystemSettings()

 

Did I choose the correct option? other options was standalone server creating a blank database.

 

Regards,

[support]

Hello Ensenada,

With the support ticket you sent us, it seems you are using the free version of Passwordstate, which means you cannot use our High Availability module - this is a module which needs to be purchased, along with some Passwordstate licenses.

Please contact Sales from the following page if you would like a quote - https://www.clickstudios.com.au/support.aspx 

Regards

Click Studios

[Ensenada]

Hello,

 

I dont know if a need to use HA version.

 

Currently we have this environment:

PS installed on a server 2008 and database SQL 2005 on server 2008.

 

Im trying to migrate to 2019, i exported/imported database on a sql 2017 and installed PS on a new server 2019. But i dont know how i must configure the new installation, when open webpage first time, there are two options:

 

1 -New blank database

2 - Hight Availability

 

I have a database with all passwords i dont need a blank database, this is why im trying use the HA option.

 

I just wanna migrate to updated operating system. Can you tell me what is the procedure ?

 

Thanks for the answer,

[support]

Hello Ensenada,

 

As mentioned in the email we've sent you, unfortunately technical support from us is not available with the free version of our software. Please follow the instructions in the email if you would like to buy maintenance with your software.

Regards

Click Studios

[Ensenada]

I still don't understand the criteria you use to help some users in the forums and not others.

 

 

Regards,

[support]

Hello Ensendada,

 

Many users in the forums have purchase Annual Support and Upgrade Protection (Maintenance) with their software.

Regards

Click Studios

[Ensenada]

So the forum is not a forum..

 

Any way, finally i got my PS migrated, website and database, my problem was an error on webconfig file.

 

Thanks to all for the help !

[support]

Hello Esenada,

 

We're glad you've figured it out.

 

We are also happy to offer our software for free, for 5 users, but we're not resourced provide technical support for free. Thanks for your understanding.

Regards

Click Studios