SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 link server
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

sophie1
Starting Member

17 Posts

Posted - 07/01/2013 :  17:58:35  Show Profile  Reply with Quote
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\INSTANCE2
2- 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
Flowing Fount of Yak Knowledge

3323 Posts

Posted - 07/01/2013 :  18:19:38  Show Profile  Reply with Quote
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\INSTANCE2
2- 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)
Go to Top of Page

sophie1
Starting Member

17 Posts

Posted - 07/01/2013 :  18:51:37  Show Profile  Reply with Quote
Yes I got it,,
and is here any way to check if I have connected to instance2?
Go to Top of Page

sophie1
Starting Member

17 Posts

Posted - 07/01/2013 :  18:55:16  Show Profile  Reply with Quote
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?
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 07/02/2013 :  02:11:52  Show Profile  Reply with Quote
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 connect

see below for steps to create a linked server programatically

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=164892

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000