October 26, 2005 at 11:55 am
Hi all,
I m a new guy in SQL Server environment. I have problem which i want to discuss.
My company has two locations in two cities, both r connected with dialup having static IP. On both sides SQL Server 2000 (standard edition) is running, with same databases and same set of users, same SA password. Now my question is, How can i connect my SQL server with other one to access all objects. Is i have to create a liked server or Remote Server, if any any option then HOW,
I will be very thankful to u for this help.
October 26, 2005 at 12:40 pm
Linked server can have sql and procedures ran against them and remote servers can only use procedure calls.
The easiest way I have found to set up a linked server:
First create an alias in the client network utilility. This only provides a friendly name for querying (Select * From ALIAS.db.owner.object instead of Select * From [servername, port].dbname.owner.object)
Then in the security tab under linked servers create a new linked server using type sql server using the alias name created in the first step. Then under the security tab map a local user to the remote server with a password and click ok. If this has been set up correctly you can now expand the newly created linked server and view objects. If you have 'System admin' privlidges run (Select Count(*) From ALIAS.master.dbo.sysobjects) from isql or QA.
October 26, 2005 at 2:11 pm
I wonder if Muhammad knows how to register a server since he says he is new to SQL Environment. Linked server is good to run SQL queries. But if you would like to do a remote administration you need to create a new SQL Server registration by right-clicking SQL Server group in Enterprise Manager and selecting New SQL Server Registration. In the Wizard click Next, then on the Next screen enter the remote server name or IP on the left, move it to the right box by clicking Add, click Next, select SQL Server Authentication, enter login name and password, like SA and its password, Next, click Next on the screen to add a server to SQL Server Group (or select other group if you have any) Next, Finish.
You will have now 2 servers in your Enterprise manager: Local and your other server.
Now, here is a trick: if you are in Enterprise Manager and you click on the other server and after that you click Tools-Query Analyzer, then Query Analyzer will open being focused on the other server and you can run ad-hoc queries towards another server. You will achieve the same result if you just open query analyzer and do File->Connect and connect to another server.
Yelena
Regards,Yelena Varsha
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply