{"id":2346,"date":"2017-01-10T15:58:44","date_gmt":"2017-01-10T12:58:44","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=2346"},"modified":"2017-04-10T16:22:18","modified_gmt":"2017-04-10T13:22:18","slug":"how-to-create-linked-server-from-sql-server-to-sql-server-database","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/how-to-create-linked-server-from-sql-server-to-sql-server-database\/","title":{"rendered":"How to Create Linked Server From SQL Server To SQL Server Database"},"content":{"rendered":"<p>You can connect another SQL Server database or different type database from SQL Server database with Linked Server feature. You can use below operations to create new linked server for SQL Server database to SQL Server database.<\/p>\n<p><strong>Create Linked Server Steps<\/strong><\/p>\n<blockquote>\n<ol>\n<li>Create a user on remote database to use connection and give permission on which database using.<\/li>\n<li><strong>SQL Server Management Studio<\/strong> with <strong>sysadmin<\/strong> privilege.<\/li>\n<li>Open <strong>SQL Server Management Studio<\/strong> with <strong>sysadmin<\/strong> privilege.<\/li>\n<li>Click <strong>New Linked Server<\/strong> below <strong>Server Objects<\/strong> &gt; <strong>Linked Servers<\/strong><\/li>\n<li><strong>General<\/strong> Section &gt; Select <strong>SQL Server<\/strong> as <strong>Server type<\/strong>.<\/li>\n<li>Write remote <strong>Instance Name<\/strong> to <strong>Linked Server<\/strong> text box.<\/li>\n<li><strong>Security<\/strong> Section &gt; Add &gt; write Local and Remote User information for connection, and OK.<\/li>\n<li>You can see added new Linked Server below<strong> Linked Server<\/strong> section<\/li>\n<\/ol>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>You can connect another SQL Server database or different type database from SQL Server database with Linked Server feature. You can use below operations to create new linked server for SQL Server database to SQL Server database. Create Linked Server Steps Create a user on remote database to use connection and give permission on which&#8230;<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[11],"tags":[14,96,46],"class_list":["post-2346","post","type-post","status-publish","format-standard","hentry","category-administration-mssql-server","tag-database-administration","tag-mssql-server","tag-sql-server-administration"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-BQ","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2346","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=2346"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2346\/revisions"}],"predecessor-version":[{"id":2347,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/2346\/revisions\/2347"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=2346"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=2346"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=2346"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}