How can I integrate my .mdf file into my local SQL server from a remote computer?

Data and Databases
1

I am trying to incorporate an .mdf database file from a remote computer into my local SQL Server instance. When attempting to attach the file, SQL Server returns an error related to directory lookup, indicating an ‘access denied’ issue. I suspect the problem might be linked to permission settings or file access paths between the networked systems. Below is the revised code snippet I used that did not work as expected:

CREATE DATABASE ConnectedDB
ON (FILENAME = 'D:\NetworkFiles\SQL\ConnectedDB_Data.mdf'),
   (FILENAME = 'D:\NetworkFiles\SQL\ConnectedDB_Log.ldf')
FOR ATTACH;

I would appreciate any advice or modifications needed to overcome this error and correctly attach the database file.

2

hey, try moving the mdf and log files locally – remote shares often have sneaky permission issues. checks file rights too, might help!

3

Based on personal experience, it is essential to verify that the SQL Server service account has the necessary permissions to access the folder where the .mdf file and associated log file reside. One effective method is to set the appropriate network share permissions for the service account on the remote location. Additionally, reviewing the file path for potential discrepancies may resolve issues related to directory lookup. Testing in a controlled environment where permissions are explicitly granted can pinpoint the cause of the access error and lead to a successful attachment of the database file.

4

hey, maybe try mapping the remote folder as a drive and verifiying that the sql service accout has rights on it. did you ever give that a go? lets see if that trick helps solve the permissions puzzel.

5

hey, check if the sqlserver user has right acess to the remote folder. try running as admin, or copy files to a local disk to see if that fixes it. mayb the net permissions arent set correctly.