Data Migration Assistant fails on a shared network drive

Jay Lauriano 20 Reputation points
2023-04-28T06:28:02.0933333+00:00

Please see attached. The network share is inaccessible, and I have zero clue what the problem is since it is otherwise accessible by all means from all servers. Why does SQL Server even need access to this share? I gave it permissions (NT SERVICE\MSSQL$CHISQLJAY1 - the account for my instance), but the failure is still evident.

Why do I even need this stupid backup directory? I don't want a backup. I don't need it. I just want to migrate my data to a new SQL Server instance. If the transfer fails, who cares?

I'm spending 99% of my time on a problem that has less than 1% relevance to what I want to do.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
11,628 questions
0 comments
Accepted answer
  1. AniyaTang-MSFT 11,411 Reputation points Microsoft Vendor
    2023-05-01T01:52:55.7666667+00:00

    Hi @Jay Lauriano

    I don't see your attachment, maybe it's missing, please upload it again. As Olaf said, we need more information to help you solve the problem.

    Best regards,

    Aniya

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 36,191 Reputation points
    2023-04-28T06:41:50.8066667+00:00

    Please see attached.

    There is nothing attached.

    Why does SQL Server even need access to this share?

    What for a share?

    Instead of complaining over the whole post, you should provide usefull informations, like from where to where you want to migrate, which versions and so on; without the informations no one can assist you.

    0 comments