通过面板上的Plesk主机故障的SQL Server数据库 [英] Trouble hosting SQL Server database via Plesk panel

问题描述

首先，我给我的产品的订阅信息，我已经为Windows一年保换终极，申购与Plesk主机除了我已经认购SiteLock的一年。我试图与宿主的SQL Server数据库的ASP.NET网站，我有很难这样做。首先通过的Plesk面板，我做了以下内容：

First I give information about my products subscription, I have one year "Ultimate" subscription for Windows hosting with Plesk in addition I have subscribed for one year of SiteLock. I am trying to host ASP.NET websites with SQL Server databases, I am having hard time doing so. Firstly via the Plesk panel I did the following:

1. 我创建的SQL Server数据库，然后我试图上传我的数据库 .bak的的版本，但遗憾的是我得到了味精：该功能当前不可用

1. I created SQL Server database, then I tried to upload .bak version of my database but unfortunately I got the msg: the feature currently unavailable.

的MS数据库不可用功能

我创建步骤1中创建我的数据库一个​​新的数据库用户，我连我的SQL Server Management Studio中，然后试图创建或导入数据库，但不幸的是，用户没有管理权限。用户的Plesk面板允许您创建具有有限权限查看数据库的用户只。

I created a new database user for my database created in step 1, I connected my SQL Server Management Studio and then tried to create or import databases, but unfortunately the user has no admin permission. The users Plesk panel allow you to create user which has only limited permission for viewing the databases only.

权限被拒绝

有没有一种方法来创建管理员用户通过Plesk控制面板我的SQL Server数据库？请指教。

Is there a way to create admin user for my SQL Server database via Plesk control panel? Please advice.

推荐答案

这也许是因为新的12.5默认权限，检查工具与;设置＆gt;数据库主机设置：

It maybe because of new 12.5 default permissions, check Tools&Settings > Database Hosting Settings:

这篇关于通过面板上的Plesk主机故障的SQL Server数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！