首先需要先確認, 安裝SQL Server的伺服器上, 有沒有安裝此套件.
權限部分, 要export/import的db_owner還不夠.
不過不是不夠, 理論上db role 只要開到read與write就ok.
因為需要其他server role.
除了sysadmin的其他都要(還沒測試到最小權限)
並且
如果有使用SSIS的話, 還需要MSDB的Write權限.
– Permission to read from the source database or file.
– Permission to write data to the destination database or file.
– To save the Integration Services package created by the wizard, the security principal requires INSERT permission on the msdb database. – If it is necessary to create a new database or table to complete the wizard, the appropriate permissions are required on the destination database instance.
-- If you want to create a new destination database or table or file, permissions sufficient to create the new database or table or file. In SQL Server 2005, this requires CREATE DATABASE or CREATE TABLE permissions.
-- If you want to save the package created by the wizard, permissions sufficient to write to the msdb database or to the file system. In Integration Services, this requires INSERT permissions on the msdb database.
-- For more information about how to manage permissions for Integration Services packages by using SQL Server Management Studio, see Integration Services Roles.
參考來源:
https://www.techveze.com/using-sql-server-import-export-wizard/ https://dba.stackexchange.com/questions/238634/permission-error-when-trying-to-import-sql https://www.sqlservercentral.com/forums/topic/permission-issue-for-excute-export-import https://solutioncenter.apexsql.com/how-to-import-and-export-sql-server-data-to-an-excel-file/
Share on Twitter Share on FacebookSQL Server Analytics Service 1
SEO(1) Github(2) Title Tag(2) ML(1) 李宏毅(1) SQL Server(18) Tempdb(1) SSMS(1) Windows(1) 自我成長(2) Excel(1) python Flask(1) python(5) Flask(2)
Max Chen (159)