SqlServer AttachDbFilename on Mac docker sql instance

Question

Hi team,

I am migrating a project from windows to mac.
A sql server instance has been created and running in a docker on mac.

Tested connecting and mssql login without any problems.

My project is an asp.net core web project with a DB connectionStrings where I put like this.

"DBstr" : "Server=localhost;Initial Catalog=Repos;AttachDbFilename=/Users/TestUser/repos/project_name/App_data/repos.mdf;User Id=sa;Password=**comm1234;TrustServerCertificate=true;Connect Timeout=30"

Then when I run the project in Visual Studio, it thrown an error with info as below.

Unable to open the physical file "/Users/TestUser/repos/project_name/App_data/repos.mdf". Operating system error 2: "2(The system cannot find the file specified.)".
Cannot attach the file '/Users/TestUser/repos/project_name/App_data/repos.mdf' as database 'Repos'.

The path is definitely correct. I am not sure if sql server supports this kind of attaching operation? Can somone help explain please?

Thanks.

Answer 1

Hi @KunLi-4284，

Please make sure your SQL Server account have the permission to read and write data file

And for local db, you can try to drop the Initial Catalog property

Referring to this thread:
https://stackoverflow.com/questions/17012839/cannot-attach-the-file-mdf-as-database/20176660#20176660

-------------

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

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.

Answer 2

Hi Yufeishao-msft,

Thanks for the reply.

I am using 'sa' as login user, I think it should have all permissions as sysadmin? And since this sql server instance is running on Mac within docker, not sure if Sql Server support the mdf file attachment with cross platform?