Forum Discussion

tocy80's avatar
tocy80
Copper Contributor
May 08, 2023

SQL Server Linked Server on local PC

Hello folks, Before the version below, which I have now   Microsoft SQL Server 2022 (RTM) - 16.0.1000.6 (X64) Oct 8 2022 05:58:25 Copyright (C) 2022 Microsoft Corporation Express Edition (6...
Linked Server
sql server
olafhelper's avatar
olafhelper
Bronze Contributor
May 09, 2023
 N'C:\Users\xx123123\OneDrive\Desktop\Folder1\file1',

 

tocy80 , C:\Users\ are the user profile folders, where only the user do have access for, but not the SQL Server service account.

Use a different folder, where SQL Server service account have at least read access for.

Resources