Come creare server collegati sql server 2008

Procedura per aggiungere server collegati, testate da sqlserver 2008 a sqlserver 2008

1. Go to “Server Objects” of the database server where the linked server will be added and right click on “Linked Servers”. Select “Add New Linked Server”.
2. In the “General” tab, add a name for the new linked server in the “Linked Server” field.
3. Select “Other data source”and for “Provider” select “Microsoft OLE DB for SQL Server”
4. For “Product Name” type in “SQLOLEDB”
5. In the “Data Source” field, enter the IP address of the server to be linked
6. “Catalog” is the name of the database on the linked server and is optional
7. Go to the “Security” tab and select “Be made using this security context”. Type in the remote login and credentials