Unable to activate/deactivate domain or import MSSQL dump: User or role does not exist in this database - Support Cases from Plesk Knowledge BaseUnable to activate/deactivate domain or import MSSQL dump: User or role does not exist in this database - Support Cases from Plesk Knowledge Base
Unable to activate/deactivate domain or import MSSQL dump: User or role does not exist in this database - Support Cases - Plesk Knowledge Base




Skip to content Contact us: +34 944 58 06 58 Plesk Partner Program Plesk Lifecycle Policy Blog Contact us Plesk 360 Menu Contact us: +34 944 58 06 58 Plesk Partner Program Plesk Lifecycle Policy Blog Contact us Plesk 360 Solutions By Role Developers Content Managers Digital Agencies IT Admins Web Hosters Hyperscalers Menu Developers Content Managers Digital Agencies IT Admins Web Hosters Hyperscalers By Edition Web Admin Edition Web Pro Edition Web Host Edition Business & Collaboration Plesk WordPress Edition Menu Web Admin Edition Web Pro Edition Web Host Edition Business & Collaboration Plesk WordPress Edition By Cloud Amazon Web Services Microsoft Azure Alibaba Cloud GCP Marketplace Vultr DigitalOcean Linode Menu Amazon Web Services Microsoft Azure Alibaba Cloud GCP Marketplace Vultr DigitalOcean Linode Partner Program Exclusive discounts, benefits and exposure to take your business to the next level Become a partner Product Explore Features Everyone Admins & Web Hosters Developers Designers & Agencies Plesk Features Menu Everyone Admins & Web Hosters Developers Designers & Agencies Plesk Features Key Topics WordPress Toolkit SEO Toolkit Plesk eCommerce Toolkit Joomla! Toolkit Plesk Premium Email Plesk Email Security Menu WordPress Toolkit SEO Toolkit Plesk eCommerce Toolkit Joomla! Toolkit Plesk Premium Email Plesk Email Security Feature Packs Business & Collaboration WordPress Pack Hosting Pack Power Pack Language Pack Menu Business & Collaboration WordPress Pack Hosting Pack Power Pack Language Pack Featured Extension Plesk eCommerce Toolkit Pricing Extensions Help Center More Careers Events Plesk University FREE TRIAL Solutions By Role Developers Content Managers Digital Agencies IT Admins Web Hosters Hyperscalers By Edition Web Admin Edition Web Pro Edition Web Host Edition Business & Collaboration WordPress Edition By Cloud Amazon Web Services Microsoft Azure Alibaba Cloud GCP Marketplace Vultr DigitalOcean Linode Partner Program Partner Program Product Explore Features Everyone Admins & Web Hosters Developers Designers & Agencies Plesk Features Key Topics WordPress Toolkit SEO Toolkit Plesk eCommerce Toolkit Joomla! Toolkit Plesk Premium Email Plesk Email Security Feature Packs Business & Collaboration WordPress Pack Hosting Pack Power Pack Language Pack Featured Extension Extension Pricing Extensions Help center More Careers Events Webinars Plesk University Blog Plesk Partner Program Contact Us FREE TRIAL Menu Solutions By Role Developers Content Managers Digital Agencies IT Admins Web Hosters Hyperscalers By Edition Web Admin Edition Web Pro Edition Web Host Edition Business & Collaboration WordPress Edition By Cloud Amazon Web Services Microsoft Azure Alibaba Cloud GCP Marketplace Vultr DigitalOcean Linode Partner Program Partner Program Product Explore Features Everyone Admins & Web Hosters Developers Designers & Agencies Plesk Features Key Topics WordPress Toolkit SEO Toolkit Plesk eCommerce Toolkit Joomla! Toolkit Plesk Premium Email Plesk Email Security Feature Packs Business & Collaboration WordPress Pack Hosting Pack Power Pack Language Pack Featured Extension Extension Pricing Extensions Help center More Careers Events Webinars Plesk University Blog Plesk Partner Program Contact Us FREE TRIAL Knowledge Base Unable to activate/deactivate domain or import MSSQL dump: User or role does not exist in this database databasedatabasesdomainsplesk for windowssecurity Symptoms Unable to activate/deactivate domain or import MSSQL dump, the following error appears: Error: Unable to activate/deactivate domain: User or role 'db_user' does not exist in this database.at (VADOConnection::execute line 90)at Disable user db_user in MSSQL database database_name on host 203.0.113.2SQLEXPRESS.(domainmng::alter_mssql_users line 730)at Turn off dbusers for domain domain.tld(domainmng::db_users_on_off line 486)at (domainmng::db_users_on_off line 487)at Turn off domain domain.tld (state=1)(domainmng::turnDomain line 120) Or Error: Some of the selected subscriptions were not activated. Enable database user failed: mssqlmng failed: User or role 'db_user' does not exist in this database. at (VADOConnection::execute line 78) at execute console command --access-user-enable(vconsoleapp::start line 100) at execute "C:Program Files (x86)ParallelsPleskadminbinmssqlmng.exe" --access-user-enable "--server=localhost" "--login=sa" "--password=*" "--database=database_name " "--user-login=db_user"(vconsoleapp::run line 117) (Error code 1) When going to Domains > example.com > Databases >Database Users > db_username and pressing OK the following error appears: Error: mssqlmng failed: User or role 'database_name' does not exist in this database.at (VADOConnection::execute line 78)at updateUserPermissions(user=db_user, database=database_name, grant_alter_database=false, repair_roles=true)(MSSQLSerSkip - to - content - Contact - us: - +34 - 944 - 58 - 06 - 58 - Plesk - Partner - Program - Plesk - Lifecycle - Policy - Blog - Contact - us - Plesk - 360 - Menu - Contact - us: - +34 - 944 - 58 - 06 - 58 - Plesk - Partner - Program - Plesk - Lifecycle - Policy - Blog - Contact - us - Plesk - 360 - Solutions - By - Role - Developers - Content - Managers - Digital - Agencies - IT - Admins - Web - Hosters - Hyperscalers - Menu - Developers - Content - Managers - Digital - Agencies - IT - Admins - Web - Hosters - Hyperscalers - By - Edition - Web - Admin - Edition - Web - Pro - Edition - Web - Host - Edition - Business - & - Collaboration - Plesk - WordPress - Edition - Menu - Web - Admin - Edition - Web - Pro - Edition - Web - Host - Edition - Business - & - Collaboration - Plesk - WordPress - Edition - By - Cloud - Amazon - Web - Services - Microsoft - Azure - Alibaba - Cloud - GCP - Marketplace - Vultr - DigitalOcean - Linode - Menu - Amazon - Web - Services - Microsoft - Azure - Alibaba - Cloud - GCP - Marketplace - Vultr - DigitalOcean - Linode - Partner - Program - Exclusive - discounts - - benefits - and - exposure - to - take - your - business - to - the - next - level - Become - a - partner - Product - Explore - Features - Everyone - Admins - & - Web - Hosters - Developers - Designers - & - Agencies - Plesk - Features - Menu - Everyone - Admins - & - Web - Hosters - Developers - Designers - & - Agencies - Plesk - Features - Key - Topics - WordPress - Toolkit - SEO - Toolkit - Plesk - eCommerce - Toolkit - Joomla! - Toolkit - Plesk - Premium - Email - Plesk - Email - Security - Menu - WordPress - Toolkit - SEO - Toolkit - Plesk - eCommerce - Toolkit - Joomla! - Toolkit - Plesk - Premium - Email - Plesk - Email - Security - Feature - Packs - Business - & - Collaboration - WordPress - Pack - Hosting - Pack - Power - Pack - Language - Pack - Menu - Business - & - Collaboration - WordPress - Pack - Hosting - Pack - Power - Pack - Language - Pack - Featured - Extension - Plesk - eCommerce - Toolkit - Pricing - Extensions - Help - Center - More - Careers - Events - Plesk - University - FREE - TRIAL - Solutions - By - Role - Developers - Content - Managers - Digital - Agencies - IT - Admins - Web - Hosters - Hyperscalers - By - Edition - Web - Admin - Edition - Web - Pro - Edition - Web - Host - Edition - Business - & - Collaboration - WordPress - Edition - By - Cloud - Amazon - Web - Services - Microsoft - Azure - Alibaba - Cloud - GCP - Marketplace - Vultr - DigitalOcean - Linode - Partner - Program - Partner - Program - Product - Explore - Features - Everyone - Admins - & - Web - Hosters - Developers - Designers - & - Agencies - Plesk - Features - Key - Topics - WordPress - Toolkit - SEO - Toolkit - Plesk - eCommerce - Toolkit - Joomla! - Toolkit - Plesk - Premium - Email - Plesk - Email - Security - Feature - Packs - Business - & - Collaboration - WordPress - Pack - Hosting - Pack - Power - Pack - Language - Pack - Featured - Extension - Extension - Pricing - Extensions - Help - center - More - Careers - Events - Webinars - Plesk - University - Blog - Plesk - Partner - Program - Contact - Us - FREE - TRIAL - Menu - Solutions - By - Role - Developers - Content - Managers - Digital - Agencies - IT - Admins - Web - Hosters - Hyperscalers - By - Edition - Web - Admin - Edition - Web - Pro - Edition - Web - Host - Edition - Business - & - Collaboration - WordPress - Edition - By - Cloud - Amazon - Web - Services - Microsoft - Azure - Alibaba - Cloud - GCP - Marketplace - Vultr - DigitalOcean - Linode - Partner - Program - Partner - Program - Product - Explore - Features - Everyone - Admins - & - Web - Hosters - Developers - Designers - & - Agencies - Plesk - Features - Key - Topics - WordPress - Toolkit - SEO - Toolkit - Plesk - eCommerce - Toolkit - Joomla! - Toolkit - Plesk - Premium - Email - Plesk - Email - Security - Feature - Packs - Business - & - Collaboration - WordPress - Pack - Hosting - Pack - Power - Pack - Language - Pack - Featured - Extension - Extension - Pricing - Extensions - Help - center - More - Careers - Events - Webinars - Plesk - University - Blog - Plesk - Partner - Program - Contact - Us - FREE - TRIAL - Knowledge - Base - Unable - to - activate/deactivate - domain - or - import - MSSQL - dump: - User - or - role - does - not - exist - in - this - database - databasedatabasesdomainsplesk - for - windowssecurity - Symptoms - Unable - to - activate/deactivate - domain - or - import - MSSQL - dump - - the - following - error - appears: - Error: - Unable - to - activate/deactivate - domain: - User - or - role - 'db_user' - does - not - exist - in - this - database.at - (VADOConnection::execute - line - 90)at - Disable - user - db_user - in - MSSQL - database - database_name - on - host - 203.0.113.2SQLEXPRESS.(domainmng::alter_mssql_users - line - 730)at - Turn - off - dbusers - for - domain - domain.tld(domainmng::db_users_on_off - line - 486)at - (domainmng::db_users_on_off - line - 487)at - Turn - off - domain - domain.tld - (state=1)(domainmng::turnDomain - line - 120) - Or - Error: - Some - of - the - selected - subscriptions - were - not - activated. - Enable - database - user - failed: - mssqlmng - failed: - User - or - role - 'db_user' - does - not - exist - in - this - database. - at - (VADOConnection::execute - line - 78) - at - execute - console - command - --access-user-enable(vconsoleapp::start - line - 100) - at - execute - "C:Program - Files - (x86)ParallelsPleskadminbinmssqlmng.exe" - --access-user-enable - "--server=localhost" - "--login=sa" - "--password=*" - "--database=database_name - " - "--user-login=db_user"(vconsoleapp::run - line - 117) - (Error - code - 1) - When - going - to - Domains - > - example.com - > - Databases - >Database - Users - > - db_username - and - pressing - OK - the - following - error - appears: - Error: - mssqlmng - failed: - User - or - role - 'database_name' - does - not - exist - in - this - database.at - (VADOConnection::execute - line - 78)at - updateUserPermissions(user=db_user - - database=database_name - - grant_alter_database=false - - repair_roles=true)(MSSQLSer -