I have a SQLServer instance on ubuntu (on my VM) and i want to create a linkedserver to link this instance with another one that exists on the SQL server that is installed on the host machine (Windows), is it possible ?
If cross network, you need to have access to that server and you can use those credentials to connect with that server, most of the time linked server is needed when person write query and would like to access other servers in same query. Make sense?
i have a question i have created the link server but when i try to run a store procedures its does noting just keep showing executing query is there any permission i need to check bcoz i am login with sysadmin but i am unable to update any script
Msg 7314, Level 16, State 1, Line 1 The OLE DB provider "SQLNCLI11" for linked server "x.x.x.x" does not contain the table ""DNname"."user".".tablename "". The table either does not exist or the current user does not have permissions on that table. am getting this error , kindly help to solve this issue
Hi TB's,
Many thanks for such useful and easily understandable videos.
Keep updating videos.
Thank you so much.
First search hit was this video. Amazing to be also the most useful. Thank you
Glad it was helpful!
Nice Vid... thanks for taking the time.
You are welcome.
Thanks TechBrothersIT! Its really helpful.
you are welcome, glad it was helpful. Thanks for watching!
This video is very informative to create link database to sql
Thank you for liking our effort and Thanks for watching!
I have a SQLServer instance on ubuntu (on my VM) and i want to create a linkedserver to link this instance with another one that exists on the SQL server that is installed on the host machine (Windows), is it possible ?
Can other users access the linked server or just the user we created can access it?
Awesome videos..
Is there a way to generate scripts for linked server dynamically
Thanks a lot. Great tutorial
You are welcome! Thanks for watching.
Hi,
is the linked server supposed to be on the same network? Or can you link to a server on a distant computer?
If cross network, you need to have access to that server and you can use those credentials to connect with that server, most of the time linked server is needed when person write query and would like to access other servers in same query. Make sense?
i have a question i have created the link server but when i try to run a store procedures its does noting just keep showing executing query is there any permission i need to check bcoz i am login with sysadmin but i am unable to update any script
Msg 7314, Level 16, State 1, Line 1
The OLE DB provider "SQLNCLI11" for linked server "x.x.x.x" does not contain the table ""DNname"."user".".tablename "". The table either does not exist or the current user does not have permissions on that table.
am getting this error , kindly help to solve this issue
Thanks TechBrothers!
Great teaching!!!!!!
Thanks! Very Helpful Video :)
+Shinoj P Koduvally You are welcome and thanks for watching!
Do we require port opening SQL server is in different subnet
Super.. Many thanks for the Vid.
Thank you but, it would be great if you show how to create a linked server from SQL Server 2014 to MySQL by OLE DB driver!
+Ariel Espindola Thanks for watching, Will create that video as well. I don't have My SQL Installed. But will do one day!
It works! Thank you very much
Thank you so much
Thanks!
Todd Knudsen You are welcome!
Tks!! it helps a lot!
Could you please tell me how to create trigger between those databases? anyone?
Thanks TB!
You are welcome!!!
Can get the Script for this