VigilEnt Policy Center 5.x
VPC database has been migrated from one SQL server to another.
The following SQL query will delete the old account, and re-create a new VPC_user account for you. Please note that this query assumes that the name of the account being used is "VPC_User", which is the account name created by default during the installation of VigilEnt Policy Center:
USE [NetIQVPC]GOALTER AUTHORIZATION ON SCHEMA::[vpc_user] TO [dbo]GODROP USER vpc_userGOCREATE LOGIN vpc_userWith PASSWORD = 'G@llant$pirit',Default_Database = NetIQVPC,Default_Language = English,Check_Expiration = OffCREATE USER vpc_user FOR LOGIN vpc_userWITH DEFAULT_SCHEMA = vpc_user;EXEC sp_addrolemember N'db_owner', N'vpc_user'GOALTER AUTHORIZATION ON SCHEMA::[vpc_user] TO [vpc_user]GO
C:\Program Files\NetIQ\VigilEnt Policy Center\server\shared\classesLocate the DB.Properties file, and open this file with note pad for editing purposes.
When a database is restored to a different server it contains a set of users and permissions but there may not be any corresponding logins or the logins may not be associated with the same users. This condition is known as having "orphaned users." Logins are associated to users by the security identifier (SID) and this login is required for access to the SQL Server server. Since the SIDs will not match after the database is restored, this user account must be recreated.
Before executing any queries against your SQL database, please take care to have proper back ups available.