question

shikha avatar image
shikha asked

Configuring SQL Server 2000 remotely

I have installed SQL Server 2000 on 2 systems, 1 having Windows XP and the other having Windows Vista.

Now I want to remotely access the SQL Server 2000 from Query Analyzer through both the systems.

Can anybody help me with what kind of settings are required for it?

sql-server-2000query-analyzer
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Melvyn Harbour 1 avatar image Melvyn Harbour 1 commented ·
Do you mean simply what is required to connect to a database on a different machine using Query Analyser? What aspects exactly do you want to configure remotely?
0 Likes 0 ·
shikha avatar image shikha commented ·
to configure remotely as it is not even connected thtough query analyzer with default way by specifying the ip address if the system.
0 Likes 0 ·

1 Answer

·
Gustavo avatar image
Gustavo answered

Let me see if i understood your question:

  • If you have two sql 2000 servers ( 1 XP and 1 Vista ) and 1 client using Query Analyser, and want to connect to both systems

If this is the case, do you have any problems with the default way of connecting ? like specify server name ( or ip adress depends on TCP/IP or named pipes connection protocol ), and either windows or sql server authentication.

If they are on separate networks, you will need to enable TCP/IP connection protocol ( i think its enabled by default ), and use IP address instead of server names to connect.

If you have firewalls, sql server use ports 1433 ( tcp ) and 1434 ( udp ). To help on firewall configuration check: http://support.microsoft.com/kb/287932

  • If you want to link both together, and from a single client run queries on both of them

If this the case, choose one server and create a linked server to the other, and with the proper credentials you could run things like:

select * from [server1].dbo.table1 as S1 
inner join [server2].dbo.table1.column1 as S2 on S1.column1 = S2.column1

Let us know if this helped.

10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.