Subscribing is a smart move!
You can subscribe to this board after you log in or create your free account.
Failure to archive a PME database using Database Manager from Management Console
Power Monitoring and Energy Automation NAM
This forum is created for the exchange of information and open dialogue regarding electrical power monitoring and energy automation products and services. Participants will have access to downloadable material as well as chat opportunities with subject matter experts.
Invite a Co-worker
Send a co-worker an invite to the portal.Just enter their email address and we'll connect them to register. After joining, they will belong to the same company.
Send Invite Cancel
Link copied. Please paste this link to share this article on your social media post.
When I try to archive a certain period of time of the database ION_Data using Database Manager.
(Management Console >Tools > Database Manager)
The following error is returned: " An error occurred while executing SqlPackage. Could not deploy package. Unable to connect to master or target server 'ION_Data_Archive22_11_14_9_16'. You must have a user with the same password in master or target server 'ION_Data_Archive22_11_14_9_16' "
The Windows User is already a member of the Sysadmin server role.
How could I solve this situation?
Link copied. Please paste this link to share this article on your social media post.
Some extra pictures about this issue are illustrated below.
As well as the services are running. The Database manager was run how "administrator", this user has a sysadmin role.
The database is normally accessed by SSMS.
Despite the error shown, it doesn't seem like a problem of access to SQL.
Link copied. Please paste this link to share this article on your social media post.
Create your free account or log in to subscribe to the board - and gain access to more than 10,000+ support articles along with insights from experts and peers.