July 30, 2015 at 10:03 am
Hi Team,
We have a SQL Server say 'DBSQL\LC', this server has 4 DB's say
DB1
DB2
DB3
DB4
DB1 to DB3 are handled by me, DB4 is handled by another team.
Now I need to access DB4 from DB1 to DB3. Can I create a linked server for this , though all r on the same instance?.
This is because DB4 inturn accesses other DB's. So if I take access on just DB4 , it might not work.
Please help me can we create linked server for accessing DB's on the same sql server
July 30, 2015 at 10:10 am
GonnaCatchIT (7/30/2015)
Hi Team,We have a SQL Server say 'DBSQL\LC', this server has 4 DB's say
DB1
DB2
DB3
DB4
DB1 to DB3 are handled by me, DB4 is handled by another team.
Now I need to access DB4 from DB1 to DB3. Can I create a linked server for this , though all r on the same instance?.
This is because DB4 inturn accesses other DB's. So if I take access on just DB4 , it might not work.
Please help me can we create linked server for accessing DB's on the same sql server
I don't think you can. I don't understand why you would want to. You don't need a linked server to address other databases on the same server\instance.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
July 30, 2015 at 12:53 pm
You can't create a local SQL Server as a linked server and secondly whichever databases are accessed within DB4 (and if they are not on this server) then you need access to those DBs and for that you may need link server.
July 31, 2015 at 7:54 am
Yes we can, our SQL team created it now. Issue resolved.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply