[New installation fails connecting to imported database]

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 !

[New installation fails connecting to imported database]

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

 

 

Regards,

[New installation fails connecting to imported database]

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,

[New installation fails connecting to imported database]

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,

[Problems migrating from 2008 to 2019.]

Hello,

 

My plan is to backup and restore database and install passwordstate in a Windows 2019 server and use the database restored in an SQL 2017.

 

Im doing the backup/restore database from 2005 SQL(running in 2008) to 2017 SQL(running in 2019) like this document:

https://www.clickstudios.com.au/downloads/version9/Move_New_Database_Server.pdf

 

I imported database without problems, but when i try to delete user like says step 4, i got this error:

 

Drop failed for User 'passwordstate_user'.  (Microsoft.SqlServer.Smo)

For help, click: https://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=16.100.47021.0&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Drop+User&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

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

The database principal owns a schema in the database, and cannot be dropped. (Microsoft SQL Server, Error: 15138)

 

Do you know how can i delete it?

 

We have version 8114, i have seen on the web that i must download the version 8995:

https://www.clickstudios.com.au/downloads/version9/Move_New_Web_Server.pdf

 

Why cannot install the last version 9 9583 ?

 

Many thanks,

Best regards