Finance | Project Operations, Human Resources, ...

Access Denied while importing the database

(0) Share

Report

Posted on by veera seenivasan

575

Guys,

I exported Sandbox db from LCS and copied to my Onebox

I am restoring my Onebox db from SBX DB data

I am importing my database in to Onebox db

C:\Program Files (x86)\Microsoft SQL Server\140\DAC\bin>SqlPackage.exe /a:import /sf:C:\SBXSQLBACKUP\SBbackup.bacpac/tsn:D365-Dev04/tdn:AXDBSBXCOPY/p:CommandTimeout=1200

I am getting This info

3414.pastedimage1581067935335v1.png

After closing this I am getting Access is Denied msg in command prompt. I am running cmd only as administrator. Any ideas are welcome

I have the same question (0)

All responses (8)

Answers (0)

Clive Richard on at

Like (0)

Report

Hi Veera,

If you are using the same command mentioned in your post then your command is missing "SPACE" I highlighted it in Red below. example after .bacpac /tsn:D365. Please use the command with space and let me know if you still face issue.

C:\Program Files (x86)\Microsoft SQL Server\140\DAC\bin>SqlPackage.exe /a:import /sf:C:\SBXSQLBACKUP\SBbackup.bacpac/tsn:D365-Dev04/tdn:AXDBSBXCOPY/p:CommandTimeout=1200

Regards,

Clive Purushothaman

This post is my own opinion and does not necessarily reflect the opinion or view of my company or Microsoft.

Was this reply helpful? Yes No
veera seenivasan 575 on at

Like (0)

Report

Thanks for your reply clive. The same issue exist

Was this reply helpful? Yes No
Clive Richard on at

Like (0)

Report

Hello Veera,

Please use the below command with user and password which has access to your SQL as Admin (create DB rights).

SqlPackage.exe /a:import /sf:"C:\Temp\testUATbackup.bacpac" /tsn:<your value> /UserId=axdbadmin /Password=********** /tdn:<your value> /p:CommandTimeout=1200

Let me know the result and also the error screenshot.

Regards,

Clive Purushothaman

This post is my own opinion and does not necessarily reflect the opinion or view of my company or Microsoft.

Was this reply helpful? Yes No
Suggested answer

Asif365 1,431 on at

Like (0)

Report

1. Run command prompt as an administrator.

go to Directory where SQLpackage.exe located.

cd C:\Program Files (x86)\Microsoft SQL Server\130\DAC\bin

2. Run the below command to Import the database

SqlPackage.exe /a:import /sf:C:\SBXSQLBACKUP\SBbackup.bacpac /tsn:localhost /tdn:AXDBSBXCOPY /p:CommandTimeout=1200

Note

During import, the user name and password aren't required. By default, SQL Server uses Microsoft Windows authentication for the user who is currently signed in

Was this reply helpful? Yes No
veera seenivasan 575 on at

Like (0)

Report

Thanks for your reply Asif. The same issue exist

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Many web hosts only give you access to one database. Your SQL file is trying to create a new database (with a line near the top like CREATE DATABASE `socialnew`... as you see in the error message).

The likely solution is to not create the database from your script. You can either edit the .sql file manually and remove the lines starting with CREATE DATABASE `socialnew`... and USE `socialnew`;, or, if your phpMyAdmin is pretty up-to-date, you could do the export again from your XAMPP and make sure the checkbox is not selected for "Add CREATE DATABASE / USE statement".

Then when doing the import, make sure you're selecting the Import tab from within the database you wish to import to.

Was this reply helpful? Yes No
Suggested answer

Asif365 1,431 on at

Like (0)

Report

You probably have some security permission issue. Try these method

1. SqlPackage.exe /a:import /sf:C:\SBXSQLBACKUP\SBbackup.bacpac /tsn:localhost /userId=axdbadmin /Password=AOSWebSite@123 /tdn:AXDBSBXCOPY /p:CommandTimeout=1200

Note: In oneBox dev environment the axdbadmin has default password is :"AOSWebSite@123"

2.Open SQL management Studio and try to import with GUI method.

Open SSMS connect {"localhost or "."} with Sql Authentication user "axdbadmin" and pass:"AOSWebSite@123"

let us know if issue still persist.

Was this reply helpful? Yes No
Ameen1623 on at

Like (0)

Report

Hi Veera,

Am getting the same error. Did you find the solution

Was this reply helpful? Yes No