Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sophie1
Starting Member
17 Posts |
 Posted - 2013-07-01 : 17:58:35
|
| Hi, Im practicing linked server .Im connecting default instance to named instance(INSTANCE2)I did these steps and now i can see INSTANCE2 under server object of default instance. however I cant see instance2 seperatly.steps I did was.1- select new linked server, from general i wrote my PC name\INSTANCE22- FROM SECURITY TAB i selected ""be made using the login's current security content"OK-----------please help me out I think IM not doing right steps to connet named server |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-07-01 : 18:19:38
|
quote:
Originally posted by sophie1
Hi, Im practicing linked server .Im connecting default instance to named instance(INSTANCE2)I did these steps and now i can see INSTANCE2 under server object of default instance. however I cant see instance2 seperatly.steps I did was.1- select new linked server, from general i wrote my PC name\INSTANCE22- FROM SECURITY TAB i selected ""be made using the login's current security content"OK-----------please help me out I think IM not doing right steps to connet named server
What does "however I cant see instance2 seperatly" mean? If you want to see INSTANCE2 outside of the default instance tree, make a new connection to the database engine (Click the connect button at the top left of object explorer and select Database Engine) |
 |
|
|
sophie1
Starting Member
17 Posts |
Posted - 2013-07-01 : 18:51:37
|
| Yes I got it,, and is here any way to check if I have connected to instance2? |
|
|
|
sophie1
Starting Member
17 Posts |
Posted - 2013-07-01 : 18:55:16
|
| and one more question for now,, Linked server is used to connect with other instances on my system.and what if there are other DBAs in an office how can I connect with their instances? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-07-02 : 02:11:52
|
quote:
Originally posted by sophie1
and one more question for now,, Linked server is used to connect with other instances on my system.and what if there are other DBAs in an office how can I connect with their instances?
So far as all of their instances are on same domain you should be able to create linked servers to them and connectsee below for steps to create a linked server programaticallyhttp://www.sqlteam.com/forums/topic.asp?TOPIC_ID=164892------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
|
|
|
link server