如何将我的Azure Sql Server管理员用户添加到"Sysadmin"服务器角色? [英] How do I add my Azure Sql Server Admin User to 'Sysadmin' Server Role?

问题描述

我正在尝试使用新的数据迁移助手v2.0 (

I'm attempting to migrate a Sql Db from a local server to Azure using the new Data Migration Assistant v2.0 (announced here).

似乎已正确连接到我的源(本地SQL 2014服务器，Windows Auth)和目标(Azure V12 SQL，服务器管理员用户名和密码)服务器，但是在尝试进入添加数据库"步骤时出现以下错误.

It seems to have connected to my source (a local SQL 2014 server, Windows Auth) and destination (Azure V12 SQL, server admin username and password) servers correctly, but gives the following error when attempting to get to the 'Add Database' step.

为目标服务器提供的凭据 'fooserver.database.windows.net'服务器级别不足 执行迁移的权限.用于连接到的凭据 目标服务器必须是sysadmin服务器角色的成员.

Provided credentials for target server 'fooserver.database.windows.net' have insufficient server-level permissions to perform migration. The credentials used to connect to the target server must be a member of the sysadmin server role.

如何将我的Azure Sql Server管理员用户添加到"sysadmin"服务器角色?我在Azure门户中看不到与此相关的任何内容.

How do I add my Azure Sql Server admin user to the 'sysadmin' server role? I couldn't see anything related to this in the Azure Portal.

推荐答案

我不认为Data Migration Assistant是完成这项工作的正确工具.如果原始数据库是Microsoft SQL，则可以使用Microsoft SQL Server 2016升级顾问预览或SQL Server Management Studio中的导出数据层"应用程序向导.我已经多次使用这两种方法，并且它们工作得很好.

I do not believe that Data Migration Assistant is the right tool for the job. If you original database is Microsoft SQL one you could either use The Microsoft SQL Server 2016 Upgrade Advisor Preview or The Export Data Tier application wizard in SQL Server Management Studio. I have used both approaches many times and they work very well.

以下文章可能是我们那里最好的文章，列出并解释了所有可用的选项-

The following article is probably the best one our there that lists and explains all available options - SQL Server database migration to SQL Database in the cloud.

如果您有任何疑问，请告诉我.

Let me know if you have any questions.

更新1 -@Ted已与Microsoft联系，他们说数据迁移助手目前不支持迁移到Azure.将来的版本将支持此方案.

Update 1 - @Ted has contacted Microsoft and they have said that Data Migration Assistant does not support migrating to Azure at the moment. This scenario will be supported in a future version.

这篇关于如何将我的Azure Sql Server管理员用户添加到"Sysadmin"服务器角色?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！