This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(195.2, 7.000000000000001%, 28%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAA%3C/text%3E%3C/svg%3E)
Hi, while trying to upload a large .mdf file(300 GB) from Microsoft sql server management to azure i recieved 3 errors.
The errors apeared only after the database was done exporting and they are all concerning import errors(the temp directory i has on the computer had 290 GB of free space left).
I would like to get an advice on how to solve this issue, i added a photo of the errors.
If you click the Error links, are there any messages?
Yeah sorry for not sharing :|
"
Could not import package. (Microsoft.SqlServer.Dac)
ADDITIONAL INFORMATION:
Unable to connect to master or target server 'XXXX'. You must have a user with the same password in master or target server 'XXXX'. (Microsoft.Data.Tools.Schema.Sql)
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 78%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECZ%3C/text%3E%3C/svg%3E)
Hi @Amir Ariely ,
Is there any update on this case? Was your issue resolved?
If the answer is helpful, please click "Accept Answer" and upvote it.This can be beneficial to other community members reading the thread.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
"Unable to connect to master or target server 'XXXX'." is a generic "cannot connect to server" message. There are many reasons for this message.
First, make sure you have the latest version of SSMS, https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-ver15
Then you need to make sure you can connect to the server from SSMS.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(124.80000000000001, 54%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMB%3C/text%3E%3C/svg%3E)
I remember facing this issue few years back. I had issue with the C drive as it was falling short of space.
your temp directory, on which drive is it on your computer?
The temp directory was on D drive(that had almost 300 of GB left).
It seems that the problem derives from my user not having the same password in target server but i dont know hot to verify that.
Thanks a lot in advance,
Amir
Hi @Amir Ariely ,
Please try to use the Data Migration Assistant (DMA) tool to migrate database to Azure.
If the answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Hi, if possible i would rather to use the microsoft sql server.
The error was as follows(I think that my passwords are the same but not sure how to make sure...):
"
Could not import package. (Microsoft.SqlServer.Dac)
ADDITIONAL INFORMATION:
Unable to connect to master or target server 'XXXX'. You must have a user with the same password in master or target server 'XXXX'. (Microsoft.Data.Tools.Schema.Sql)"
Any ways, thanks a lot for your help.