Tuesday, 22 March 2016

Creating Linked Servers in SQL Server 2012 to SQLServer 2000

 Linked server is Equivalent to Database link in Oracle database.
It is easy to create linked Server in SQL Server 2012 to any version till SQL Server 2008 using SQL Server management studio.
Challenges are encountered while creating linked server for a DB from SQL2012 to SQL2000

While creating a Linked Server, it throws following error reason being that SQL Server 2012 does not support Native Client 11 to connect to SQL 2000.



Resolution Steps:
  • Downloaded and installed the SQL Native Client 10.
  • Install the SQL Native client 10 and create Linked Server as below.
EXEC sp_addlinkedserver @server = N'TESTLNSVR',
                        @srvproduct=N'MSSQL',
                        @provider=N'SQLNCLI10',
                        @provstr=N'PROVIDER=SQLOLEDB;SERVER=xx.xx.xx.xx'

  • This will create the  link server  but while accessing it could throw error as:


To rectify the above error , following steps should be followed:
Define ODBC data source using SQL native client 10 in ODBC tool in Windows server.



Once the ODBC Data source is completed ,perform the connectivity test and it should be successful.
1)     Now create the linked server using script.
EXEC sp_addlinkedserver @server = N'TESTLNK_SVR',
                        @srvproduct=N'',
                        @provider=N'MSDASQL',
                        @provstr=N'DRIVER={SQL Server};SERVER=xx.xx.xx.xx;UID=test;PWD=Test123;',
                        @catalog=N'DBNAME'
Server:  TESTLNK_SVR is the link server name through which DB on target server is accessed.

Provider: MSDASQL is an OLEDB provider that connects to ODBC, instead of a database.

Provider string: SQL Server Is the OLE DB provider-specific connection string that identifies a unique data source.

Server in Provstr: Server name where the SQL Server 2000 instance is setup

Catalog: DBName is the database name that we are trying to access in target SQL Server instance.

Once the Linked Server is created, it can be accessed using below SQL.
SELECT * FROM OPENQUERY(TESTLNK_SVR,’SELECT * FROM TABLE’)

Author:
Mohammed Fazulullah
Kovaion Consulting-PeopleSoft Practice

102 comments:

  1. The blog gave me idea to create linked server Thanks for sharing it
    Dot Net Training in Chennai

    ReplyDelete
  2. Superb. I really enjoyed very much with this article here. Really it is an amazing article I had ever read. I hope it will help a lot for all. Thank you so much for this amazing posts and please keep update like this excellent article.thank you for sharing such a great blog with us. expecting for your.
    Digital Marketing Company in India
    seo Company in India

    ReplyDelete
  3. Thank you for taking the time to provide us with your valuable information. We strive to provide our candidates with excellent care and we take your comments to heart.As always, we appreciate your confidence and trust in us.

    Home Cleaning Services Mumbai

    ReplyDelete
  4. You post explain everything in detail and it was very interesting to read. Thank you. nata coaching centres in chennai

    ReplyDelete
  5. Very Nice Blog I like the way you explained these things. I’ve been looking for ways to improve my website and overall rankings.I hope your future article will help me further.Take SEO Training in Chennai to mould yourself.

    ReplyDelete
  6. This blog is having the general information. Got a creative work and this is very different one.We have to develop our creativity mind.This blog helps for this. Thank you for this blog. This is very interesting and useful.
    Pest Control in Chennai

    ReplyDelete
  7. Really incredible and interesting article. Keep the good work. I really appreciate your effort on putting such thoughts in the post. Thanks for sharing with us. Latest php jobs in hyderabad

    ReplyDelete
  8. Good one, very informative.. thanks for sharing your views and ideas.. it is very useful to me.. thanks once again

    Software Testing Training in chennai

    ReplyDelete
  9. Really Good blog post.provided a helpful information.I hope that you will post more updates like this.
    Digital marketing company in Chennai

    ReplyDelete
  10. I have attended the PHP course. Course content is excellent. I would recommend this course anyone wants to make career in PHP. Instructor describes you course in detail. All Presentations are very good. The Course Material is truly great,and good thing is that you will get Real time Project Explanation with Case Studies.Thank you ASTERHR IT SOLUTION PHP training in chennai

    ReplyDelete
  11. Thanks for your marvelous posting! It is very useful and good. Come on. I want to introduce the best aso services for you, I try it and I feel it is so good to rank app to top in app store search results, have you ever heard it?

    ReplyDelete
  12. This comment has been removed by the author.

    ReplyDelete
  13. What a really awesome post this is. Truly, one of the best posts I've ever witnessed to see in my whole life. Wow, just keep it up. wordpress

    ReplyDelete
  14. There are three popular approaches to server virtualization: the virtual machine model, the paravirtual machine model, and virtualization at the operating system (OS) layer.
    minecraft server hosting

    ReplyDelete
  15. Excellent blog I visit this blog it's really awesome. The important thing is that in this blog content written clearly and understandable. The content of information is very informative.
    Oracle Fusion HCM Online Training
    Oracle Fusion SCM Online Training
    Oracle Fusion Financials Online Training
    Big Data and Hadoop Training In Hyderabad

    ReplyDelete
  16. Very interesting blog Really excellent information and thank you for giving your valuable information

    Oracle Fusion HCM Online Training

    ReplyDelete
  17. I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well.

    Oracle Fusion SCM Online Training

    ReplyDelete
  18. Божественно познавательныеда еще удивительно точнейшие интернет гадания для уточнении загадывания вашего ближайшего будущего: это именно то, с чем вы познакомитесь на сайте гаданий. Онлайн гадания бесплатно на картах, на ближайшее оказывается наиболее доступным и легким способом для получения нужных знаний из эмпирического поля земли.

    ReplyDelete
  19. Hi buddies, it is great written piece entirely defined, continue the good work constantly.

    Data Science Course

    ReplyDelete
  20. It is extremely nice to see the greatest details presented in an easy and understanding manner.

    Data Science Training

    ReplyDelete
  21. I couldn't leave your website until I told you that I really appreciated the high quality information it presents to your visitors. I will come back frequently to check for new posts.

    360DigiTMG Data Science Courses

    ReplyDelete
  22. Hello! I just want to give a big thank you for the great information you have here in this post. I will probably come back to your blog soon for more information!

    360DigiTMG Data Science Certification

    ReplyDelete
  23. I will be interested in more similar topics. I see you have some really very useful topics, I will always check your blog thank you.

    360DigiTMG Artificial Intelligence Course in Bangalore

    ReplyDelete
  24. Hmm ... it's good to be here on your article or post, whatever, I think I should also work hard for my own website as I see some good and updated on your site.

    360DigiTMG Business Analytics Course in Bangalore

    ReplyDelete
  25. The regular visits listed here are the easiest way to appreciate its energy, which is why I go to the website every day for new and interesting information. Thank you so much!

    360DigiTMG Data Analytics Course in Bangalore

    ReplyDelete
  26. Fantastic blog extremely good well enjoyed with the incredible informative content which surely activates the learners to gain the enough knowledge. Which in turn makes the readers to explore themselves and involve deeply in to the subject. Wish you to dispatch the similar content successively in future as well.

    artificial intelligence certification in bhilai

    ReplyDelete
  27. Extraordinary blog went amazed with the content that they have developed in a very descriptive manner. This type of content surely ensures the participants to explore themselves. Hope you deliver the same near the future as well. Gratitude to the blogger for the efforts.

    Digital Marketing training

    ReplyDelete
  28. Impressive blog to be honest definitely this post will inspire many more upcoming aspirants. Eventually, this makes the participants to experience and innovate themselves through knowledge wise by visiting this kind of a blog. Once again excellent job keep inspiring with your cool stuff.

    Data Science training

    ReplyDelete
  29. Различные разновидности предсказания грядущего упоминаются как астральные науки. Определенный характер гадания исключителен и подготовлен для различных результатов. Гадание на картах на женщину и точность ворожбы напрямую зависит от практики человека. Всякий желает узнать собственную судьбу и представляет определенные типы хиромантии наиболее действенными.

    ReplyDelete
  30. Fantastic article with valuable information found very knowledgeable and helpful waiting for next blog thank you.
    Data Science Course in Hyderabad 360DigiTMG

    ReplyDelete

  31. Great article with top quality information, found very helpful thanks for sharing waiting for next blog update.
    Ethical Hacking Course in Bangalore

    ReplyDelete
  32. It took a while to understand all the comments, but I really enjoyed the article. It turned out to be really helpful for me and I'm positive for all the reviewers here! It's always nice to be able to not only be informed, I'm sure you enjoyed writing this article.
    Cyber Security Course in Bangalore

    ReplyDelete
  33. Happy to chat on your blog, I feel like I can't wait to read more reliable posts and think we all want to thank many blog posts to share with us.
    Cyber Security Training in Bangalore

    ReplyDelete
  34. Fantastic blog extremely good well enjoyed with the incredible informative content which surely activates the learners to gain the enough knowledge. Which in turn makes the readers to explore themselves and involve deeply in to the subject. Wish you to dispatch the similar content successively in future as well.

    artificial intelligence course in bhilai

    ReplyDelete
  35. Really nice and interesting blog information shared was valuable and enjoyed reading this one. Keep posting. Thanks for sharing.
    Data Science Training in Hyderabad

    ReplyDelete
  36. Really wonderful blog completely enjoyed reading and learning to gain the vast knowledge. Eventually, this blog helps in developing certain skills which in turn helpful in implementing those skills. Thanking the blogger for delivering such a beautiful content and keep posting the contents in upcoming days.

    Data Science certification in Bhilai

    ReplyDelete
  37. Truly incredible blog found to be very impressive due to which the learners who ever go through it will try to explore themselves with the content to develop the skills to an extreme level. Eventually, thanking the blogger to come up with such an phenomenal content. Hope you aarrive with the similar content in future as well.

    Digital Marketing training in Bhilai

    ReplyDelete
  38. Tremendous blog quite easy to grasp the subject since the content is very simple to understand. Obviously, this helps the participants to engage themselves in to the subject without much difficulty. Hope you further educate the readers in the same manner and keep sharing the content as always you do.

    Data Science training in Raipur

    ReplyDelete
  39. Stupendous blog huge applause to the blogger and hoping you to come up with such an extraordinary content in future. Surely, this post will inspire many aspirants who are very keen in gaining the knowledge. Expecting many more contents with lot more curiosity further.

    Digital Marketing training in Raipur

    ReplyDelete
  40. Fantastic blog extremely good well enjoyed with the incredible informative content which surely activates the learners to gain the enough knowledge. Which in turn makes the readers to explore themselves and involve deeply in to the subject. Wish you to dispatch the similar content successively in future as well.

    ai course in raipur

    ReplyDelete
  41. Top quality blog with very informative information found very useful thanks for sharing.
    Data Analytics Course Online

    ReplyDelete
  42. Fantastic blog extremely good well enjoyed with the incredible informative content which surely activates the learners to gain the enough knowledge. Which in turn makes the readers to explore themselves and involve deeply in to the subject. Wish you to dispatch the similar content successively in future as well.

    artificial intelligence certification in bhilai

    ReplyDelete
  43. Tremendous blog quite easy to grasp the subject since the content is very simple to understand. Obviously, this helps the participants to engage themselves in to the subject without much difficulty. Hope you further educate the readers in the same manner and keep sharing the content as always you do.

    Data Science Course in Bhilai

    ReplyDelete
  44. Truly incredible blog found to be very impressive due to which the learners who ever go through it will try to explore themselves with the content to develop the skills to an extreme level. Eventually, thanking the blogger to come up with such an phenomenal content. Hope you aarrive with the similar content in future as well.

    Digital Marketing Course

    ReplyDelete
  45. It's always nice to be able to not only be informed, but also entertained! I'm sure you enjoyed writing this article. PMP Training in Hyderabad

    ReplyDelete
  46. This article is very useful. Thank you very much. I would recommend you to visit my website, online Converter - https://youtube-to-mp3-converter.com/. With this free Youtube 2 mp3 Converter, you can download your favorite song to your iPhone.

    ReplyDelete
  47. Многочисленное множество игр издается ежемесячно. Преимущественно верным путем достать ожидаемую игрушку является https://games9.ru/load/gonki/. Знать что к чему в элементах кибер игр не так просто по факту слишком большого их объема. Поставив игры с Torrent вы получаете пиковый уровень безопасности. Жулики попробуют использовать неосведомленность юзеров и прикладывать вирусы. Скачка торрента оказывается обыкновенной процедурой, подходящей к тому же для неграмотных пользователей.

    ReplyDelete
  48. Great article with excellent information found resourceful and enjoyed reading it thank you, looking forward for next blog.
    typeerror nonetype object is not subscriptable

    ReplyDelete
  49. Really nice and interesting blog information shared was valuable and enjoyed reading this one. Keep posting. Thanks for sharing.
    Data Science Training in Hyderabad

    ReplyDelete
  50. Really, this article is truly one of the best, information shared was valuable and resourceful Very good work thank you.
    Data Scientist Training in Hyderabad

    ReplyDelete
  51. I have read good things here. Definitely worth to bookmark again. I am amazed at how much effort you put into creating such an informative website. PMP Certification in Hyderabad

    ReplyDelete
  52. Ниже рассмотрены глобальные достоинства кооперации с данной фирмой. Разнообразный ассортимент инвентаря для жилищной сферы. Воспользуйтесь наибольшими преимуществами исключительно здесь купить детские игровые комплексы от производителей.

    ReplyDelete
  53. Thanks for sharing great information. I highly recommend you.data science courses

    ReplyDelete
  54. Чуть ниже рассмотрены наиболее важные преимущества кооперации с этой фирмой. Огромный сортимент оборудования для жилищной сферы. Получите максимальные выгоды именно здесь https://snabtop.ru/category/plastikovye-kontejnery/.

    ReplyDelete
  55. Сосредоточьтесь не только на керамогранитной плитке западного изготовления, но и на наши образцы. Выбирая качественный продукт как например saloni необходимо рассмотреть максимальное число продуктов. Кафельная очень хорошо подойдет к каждому интерьеру. Оптимальный выбор настенного покрытия может приукрасить всякую кухню или ванную комнату.

    ReplyDelete
  56. Impressive blog to be honest definitely this post will inspire many more upcoming aspirants. Eventually, this makes the participants to experience and innovate themselves through knowledge wise by visiting this kind of a blog. Once again excellent job keep inspiring with your cool stuff.

    Digital Marketing Course

    ReplyDelete
  57. Terrific post thoroughly enjoyed reading the blog and more over found to be the tremendous one. In fact, educating the participants with it's amazing content. Hope you share the similar content consecutively.

    Data Science Course in Bhilai

    ReplyDelete
  58. Stupendous blog huge applause to the blogger and hoping you to come up with such an extraordinary content in future. Surely, this post will inspire many aspirants who are very keen in gaining the knowledge. Expecting many more contents with lot more curiosity further.

    Data Science Course in Raipur

    ReplyDelete
  59. Truly mind blowing blog went amazed with the subject they have developed the content. These kind of posts really helpful to gain the knowledge of unknown things which surely triggers to motivate and learn the new innovative contents. Hope you deliver the similar successive contents forthcoming as well.

    Digital Marketing training

    ReplyDelete
  60. Фирма «Skoro Dengi» предлагает своим заказчикам новые мфо онлайн займ на карту и возможность подбора финансовых групп. Сами оформляйте понравившийся коммерческий продукт на всевозможные цели. Никому более не потребуется посещать банк, чтобы получить необходимую сумму.

    ReplyDelete
  61. Truly mind blowing blog went amazed with the subject they have developed the content. These kind of posts really helpful to gain the knowledge of unknown things which surely triggers to motivate and learn the new innovative contents. Hope you deliver the similar successive contents forthcoming as well.

    Digital Marketing training

    ReplyDelete
  62. Stupendous blog huge applause to the blogger and hoping you to come up with such an extraordinary content in future. Surely, this post will inspire many aspirants who are very keen in gaining the knowledge. Expecting many more contents with lot more curiosity further.

    Data Science certification in Raipur

    ReplyDelete
  63. Tremendous blog quite easy to grasp the subject since the content is very simple to understand. Obviously, this helps the participants to engage themselves in to the subject without much difficulty. Hope you further educate the readers in the same manner and keep sharing the content as always you do.

    Digital Marketing training

    ReplyDelete
  64. I've read this post and if I could I desire to suggest you some interesting things or suggestions. Perhaps you could write next articles referring to this article. I want to read more things about it!
    data science training in Hyderabad

    ReplyDelete
  65. I wanted to leave a little comment to support you and wish you the best of luck. We wish you the best of luck in all of your blogging endeavors.

    Artificial Intelligence Course in Bangalore

    ReplyDelete
  66. Три в ряд – более чем известный слот средь виртуальных игр Kazino X. Подробное меню и стремительный поиск – это гарантированный способ выбрать интересующую азартную игрушку. Всего лишь на данной платформе казино х официальный посетитель может погрузиться в невероятные путешествия.

    ReplyDelete
  67. Сервисная служба в любое время придет на помощь и оперативно разрешит самую непростую проблему. Имейте в виду, что казино x скачать на андроид никогда не спрашивает денег за проведение сеанса регистрации пользователей. Просмотреть оригинальность портала можно на центральной странице casino-x-oficialniy-sayt.com.

    ReplyDelete
  68. Использовав игровые автоматы мистер бит вы попадете в удивительный мир игры на компьютере. Люди состязаются в реакции, организовывают настоящие команды и берут награды в турнирах. Развлечения молодого поколения с большими подарками. Киберспорт – это последний этап становления высокопрофессиональных чемпионатов.

    ReplyDelete
  69. Really wonderful blog completely enjoyed reading and learning to gain the vast knowledge. Eventually, this blog helps in developing certain skills which in turn helpful in implementing those skills. Thanking the blogger for delivering such a beautiful content and keep posting the contents in upcoming days.

    Data Science certification in Raipur

    ReplyDelete
  70. Truly incredible blog found to be very impressive due to which the learners who ever go through it will try to explore themselves with the content to develop the skills to an extreme level. Eventually, thanking the blogger to come up with such an phenomenal content. Hope you arrive with the similar content in future as well.

    Digital Marketing training in Raipur

    ReplyDelete
  71. Highly appreciable regarding the uniqueness of the content. This perhaps makes the readers feels excited to get stick to the subject. Certainly, the learners would thank the blogger to come up with the innovative content which keeps the readers to be up to date to stand by the competition. Once again nice blog keep it up and keep sharing the content as always.

    Data Science Course in Bhilai

    ReplyDelete
  72. Wonderful blog found to be very impressive to come across such an awesome blog. I should really appreciate the blogger for the efforts they have put in to develop such an amazing content for all the curious readers who are very keen of being updated across every corner. Ultimately, this is an awesome experience for the readers. Anyways, thanks a lot and keep sharing the content in future too.

    Digital Marketing Course

    ReplyDelete
  73. I have to search sites with relevant information ,This is a
    wonderful blog,These type of blog keeps the users interest in
    the website, i am impressed. thank you.
    Data Science Course in Bangalore

    ReplyDelete
  74. Цена покрытия существенно различается. Разновидность рисунков и форматов. Кафель клинкерная плитка cerrad cer реализуют в невероятном количестве, и каждая компания планирует запустить особый уникальный дизайн.

    ReplyDelete
  75. Really impressed! Everything is a very open and very clear clarification of the issues. It contains true facts. Your website is very valuable. Thanks for sharing.

    Business Analytics Course

    ReplyDelete
  76. Любые методы предсказания будущего называются как астральные науки. Определенный род хиромантии уникален и необходим для разного рода задач. Гадание на картах онлайн любит ли он меня и чистота ворожбы прямо зависит от навыков гадающего. Любой стремится подсмотреть собственную судьбу и воспринимает определенные средства предсказания будущего более действенными.

    ReplyDelete
  77. Керамогранитная плитка http://otzyvoff.ru/index.php?subaction=userinfo&user=uhule используется почти во всех помещениях. Огромный ассортимент изделий, показанный в прейскуранте торговой площадки, доступен каждому по самой актуальной цене. На вебсайте компании Легенда Gres каждый желающий сможет выбрать кафель по оптимально приемлемой стоимости.

    ReplyDelete
  78. Ассортимент материалов, выставленный в каталоге legendagres.ru https://metalverk.ru/forum/?PAGE_NAME=profile_view&UID=25518, правда обширен. Главными элементами при производстве являются светлая глина и незначительное количество прибавок, изменяющих оттенок и микроструктуру. Производством отделочной плитки занимаются очень многие компании на всех континентах.

    ReplyDelete
  79. Рыбные деликатесы отличного качества есть в магазине на Бережковской набережной в любое время. Посещая наш магазин, вы приобретете именно качественную рыбопродукцию от надежных дилеров. Широкий ассортимент продукции http://www.apicarrara.it/modules.php?name=Journal&file=display&jid=16161 и своевременная доставка.

    ReplyDelete

  80. I see the greatest contents on your blog and I extremely love reading them.
    business analytics course

    ReplyDelete
  81. Раскрыты подробности смерти актера Дмитрия Писаренко. Источник https://newstes.ru/2021/02/24/raskryty-podrobnosti-smerti-aktera-dmitrija-pisarenko.html

    ReplyDelete
  82. В большинстве случаев сверла для механической дрели применяют для прямого исполнения отверстий в бытовых условиях. Стандартные сверла обладают достаточно приличной заточкой. Стандартным сверлом невероятно легко сверлить маленькие круглые пазы. Именно комплект закаленный SDS-PLUS бур по бетону купить – хороший вариант, проходит к твердым сплавам, как пример, для листового металла.

    ReplyDelete
  83. Зажарить сытную курицу без специфических сложностей на редкость легко https://trebuha.ru/442-svinaja-vyrezka-s-syrnoj-glazurju-i-sousom.html. Примените нужный элемент для создания нестандартного вкуса, допустим, красный лук. Припасы для готовки курятины недорогие, достаточно лишь курочка и незначительное число приправы. Главная причина заключается в самой системе жарки. Полезно вымочить вырезку и добавить особых добавок по душе.

    ReplyDelete
  84. Impressive. Your story always bring hope and new energy. Keep up the good work.
    data scientists training

    ReplyDelete
  85. I really enjoy every part and have bookmarked you to see the new things you post. Well done for this excellent article. Please keep this work of the same quality.
    Artificial Intelligence course in Chennai

    ReplyDelete
  86. Fantastic blog with excellent information and valuable content just added your blog to my bookmarking sites thank for sharing.
    Data Science Course in Chennai

    ReplyDelete
  87. i am glad to discover this page : i have to thank you for the time i spent on this especially great reading !! i really liked each part and also bookmarked you for new information on your site.
    best data science courses in bangalore

    ReplyDelete
  88. I want to leave a little comment to support and wish you the best of luck.we wish you the best of luck in all your blogging enedevors.
    best data science courses in hyderabad

    ReplyDelete
  89. Самый наглядный случай – на любой кухне непременно есть чайник. Кухонную утварь возможно символично разделить на две крупные категории – декоративные и практические, для ежедневного применения. На сайте онлайн-магазина «МАКСИДЕН» запросто выбрать гладильная доска купить в нижнем новгороде по самой актуальной цене.

    ReplyDelete
  90. Разнообразные способы для гадания употреблялись людьми с древнейших времен. В некоторых направлениях хиромантия определяется ложной наукой. Цифрология - больше всего востребованные манипуляции для ворожбы https://gadanie.fun/gadanie-na-parnya-onlajn/.

    ReplyDelete