connecting to sqlserver from remote client

[kindus]

What are steps to be taken to connect to sqlserver database from a remote clients ?
1. Is there anything like listener in oracle to be configured/running?
2. Is there anyhting like net80 to be configured in the client machine ?

Please help
thanks

 

[fluteplr]

Depends on what connection type you are trying to make for example ODBC or ADO?

1. No
2. No

 

[kindus]

I am looking to connect thru sqlserver 7 client's query analyzer. Please let me know what I need to do to able to establish the connection.

 

[tlbroadbent]

Generally, all you will need to do is start QA. The 'Connect to SQL Server' dialog will appear. Type the name of the server in the SQL Server box. If SQL Server is setup with NT or Windows authentication and your login has been granted access, select Windows Authentication. Otherwise, select SQL authentication, enter a login and password then click OK.

If you fail to connect, you may need to use the SQL Client Network Utility to setup the SQL network library and and an optional alias.

Terry L. Broadbent
faq183-874 contains some tips and ideas for posting questions in these forums. Please review it if you have time.