SQL Server SQLPro Server Objects

lb3vh1jj  于 2023-05-21  发布在  其他
关注(0)|答案(1)|浏览(120)

Does anyone know if it's possible to connect to Linked Servers using SQLPro for MAC? I can connect to the main SQL server but can't see any of the server objects like Linked Servers.

kulphzqa

kulphzqa1#

Yes, You can connect to Linked Server for Mac.

You need to create a new connection in SQL Pro IN the server section, Need to enter the name of the server, In the database, need to select the database which contains the linked server, Within security, you need to add a username and password for the account to use to connect to a server and click on the advanced section. In the linked server select a Linked server and connect Then you will be able to see a linked server in the server object pane and can use the linked server to access data from other databases.

Specifically for connecting to the linked server, work on these: Just make sure the linked server is created server you are connecting to Just make sure the linked server is accessible to the account that you are using and has appropriate permissions.

相关问题