How to create link server

How to create link server

Query: 

How to create link server


Support Comment: 

Kindly follow the below steps for creating a link server.


1. Open the Sql Server and login with id and password.



2.Open the server object options.


3.Right Click on Linked Servers option



4.Click on New Linked Server option


5.Select the sql server option and enter the linked server IP Address.



6. Click on security option



7. Select option be made using this security context option and enter the remote login with password and click on ok.





    • Related Articles

    • Steps to create New Store in iVend

      Environment iVend 6.6 7989 Query Steps to create New Store in iVend HO MC Answer One can follow our e-Learning Video on Store Creation from below link/ portal: It is also suggested to create Store backup file from iVend Enterprise MC in downtime when ...
    • Linked server creation from SAPB1 HANA Server to SQL Server

      Environment : iVend 6.6 With SAPB1 HANA Server Problem Statement : There is need to access SAPB1 HANA tables on iVend Enterprise database Resolution : You can check out the below video link to create Linked server from HANA to SQL Server ...
    • How to link cloud MC linceses with Cloud users

      Environment: iVend 6.6 cloud integrated with SAPB1 Problem Statement: How to link cloud MC licenses with Cloud users Resolution/Work Around: There are two options to assign the MC license. Open cloud enterprise MC --> Administrator --> Retail ...
    • How to link cloud MC linceses with Cloud users

      Environment: iVend 6.6 cloud integrated with SAPB1 Problem Statement: How to link cloud MC licenses with Cloud users Resolution/Work Around: There are two options to assign the MC license. Open cloud enterprise MC --> Administrator --> Retail ...
    • Methods of back up of Enterprise Server SQL Database

      Version: Not any specific version. Query: Kindly advise methods of backup of Enterprise Server SQL database. Answer: We can only take SQL backup from SQL Server only for enterprise databases. We don't have any utility to take an enterprise backup. ...