Microsoft 365 and Office | Access | For business | Windows
A family of Microsoft relational database management systems designed for ease of use.
Again, check your default database.
SQL Server Migration Assistant for Access issue
![](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(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
I am trying to use the above tool to migrate an Access backend database to SQL Server.
It ran fine on my PC under SQL 2017 and migrated to the correct SQL database. When I run it on my Client's Server under SQL 2022 the tool tries to create the tables in the Master database not the destination database I have selected, and then fails as I don't have permissions to create tables in the Master database.
Any clues?
Microsoft 365 and Office | Access | For business | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
5 additional answers
Sort by: Most helpful
-
George Hepworth 22,855 Reputation points Volunteer Moderator2023-08-07T18:17:49+00:00 It should be pretty easy to understand. SSMA needs to know where you want to create the migrated tables. If you don't tell SSMA which database to use, it's forced to pick one (or fail) and the path of least resistance for that choice is Master.
"Oh, you didn't want Master? Well, tell me. Which database you DO want to create the tables in? If you make that one the default, I can use it, but I'm not going to keep guessing...."
-
Anonymous
2023-08-03T01:55:17+00:00 On the database on my PC and on the database on the Server I have db_owner rights.
-
George Hepworth 22,855 Reputation points Volunteer Moderator
2023-07-31T12:55:10+00:00 I just wanted to comment that it's a good thing the process fails when trying to create user tables in Master....
-
![](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(284.8, 62%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDH%3C/text%3E%3C/svg%3E)
Duane Hookom 26,825 Reputation points Volunteer Moderator2023-07-31T01:28:06+00:00 I assume the login running the tool has rights to the intended target database. I had this issue a decade ago and resolved it by setting the login’s default database to the target database.