Sunday, February 19, 2012

Access otehr sql server ina domain w/ Query Analyzer

Hi everybody,

I do not know if this is the correct area to post this topic? So, How to access
different sql server with query analyzer? Usually, when to install sql server, it
access the database server locally installed, now I like to access other sql server
within a domain using query analyzer. How to configure this in order I could use
query analyzer to access other sql server within a domain? Thanks in advanced.

den2005

Simply choose Connect from the menu and connect to a different server. If you want to you another server in your query you can setup a linked server whereas you can query across different servers in one query.

HTH, jens Suessmeyer.

No comments:

Post a Comment