Trustwave Unveils New Offerings to Maximize Value of Microsoft Security Investments. Learn More

Trustwave Unveils New Offerings to Maximize Value of Microsoft Security Investments. Learn More

Services
Capture
Managed Detection & Response

Eliminate active threats with 24/7 threat detection, investigation, and response.

twi-managed-portal-color
Co-Managed SOC (SIEM)

Maximize your SIEM investment, stop alert fatigue, and enhance your team with hybrid security operations support.

twi-briefcase-color-svg
Advisory & Diagnostics

Advance your cybersecurity program and get expert guidance where you need it most.

tw-laptop-data
Penetration Testing

Test your physical locations and IT infrastructure to shore up weaknesses before exploitation.

twi-database-color-svg
Database Security

Prevent unauthorized access and exceed compliance requirements.

twi-email-color-svg
Email Security

Stop email threats others miss and secure your organization against the #1 ransomware attack vector.

tw-officer
Digital Forensics & Incident Response

Prepare for the inevitable with 24/7 global breach response in-region and available on-site.

tw-network
Firewall & Technology Management

Mitigate risk of a cyberattack with 24/7 incident and health monitoring and the latest threat intelligence.

Solutions
BY TOPIC
Offensive Security
Solutions to maximize your security ROI
Microsoft Exchange Server Attacks
Stay protected against emerging threats
Rapidly Secure New Environments
Security for rapid response situations
Securing the Cloud
Safely navigate and stay protected
Securing the IoT Landscape
Test, monitor and secure network objects
Why Trustwave
About Us
Awards and Accolades
Trustwave SpiderLabs Team
Trustwave Fusion Security Operations Platform
Trustwave Security Colony
Partners
Technology Alliance Partners
Key alliances who align and support our ecosystem of security offerings
Trustwave PartnerOne Program
Join forces with Trustwave to protect against the most advance cybersecurity threats
Loading...
Loading...

ERRMSG: Cannot create remote view when updating an array

Expand / Collapse


This article applies to:

  • MailMarshal SPE

Symptoms:

  • After adding or editing an array, the Management Interface returns a toast error indicating one or more items could not be added to SQL Server
  • Logs show similar to:

    Could not add view to Remote SQL Server.
    See KB article 11600 in the Trustwave Knowledgebase for more information

Cause:

SPE could not add the required views, tables, and stored procedures on the remote MailMarshal database. 

The SQL credential used to connect to the MailMarshal database does not have sufficient permissions. 

Fix:

To correct this issue:

  • In the Management Interface navigate to the Server Configuration > Arrays > (array name) > General > Database page. 
  • Set the database credential for each MailMarshal array to a credential with permission to add items, select data, and execute stored procedures on the MailMarshal database. 
  • Click Save.
  • Once the credential is saved and accepted, click Deploy SQL Scripts.

For earlier releases, similar functionality is available in the Admin Console.

Limiting permissions:

After successfully creating the objects, you could revert to a database credential with lower permissions.

You must ensure that the credential has the following permissions:

  • Execute permission on all stored procedures in the MailMarshal database that have names starting "SPE".
  • Insert, Select, Update, Delete permission on all tables and views in the MailMarshal database that have names starting "SPE".
  • Select permission on all other tables in the MailMarshal database.
    • To grant appropriate permissions on the native MailMarshal items, make the credential a member of the @ArrayManager database role.


To contact Trustwave about this article or to request support:


Rate this Article:
     
Tags:

Add Your Comments


Comment submission is disabled for anonymous users.
Please send feedback to Trustwave Technical Support or the Webmaster
.