Forum Discussion
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...
The other process you are doing is right while creating a linked server. You just need to change this
The linked server you are adding is a user-specific folder but Not with an SQL server account.
You need to add it to a different folder where the SQL server could read and access it.
After this you can check it here:
SELECT *
FROM test_server.database.schema.table;
I hope this will help.
The linked server you are adding is a user-specific folder but Not with an SQL server account.
You need to add it to a different folder where the SQL server could read and access it.
After this you can check it here:
SELECT *
FROM test_server.database.schema.table;
I hope this will help.