Accessing remotely without ODBC configured?

[Spidy6123]

Hi there,

So I know it's possible to access a remote SQL Server without setting up an ODBC connection, but I'm not sure how to configure the server to allow that to happen?

Basically I would like to login to the server remotely with SSMS without having to setup an ODBC SQL Server connections on the remote machine..

How is this done? My searches are proving ineffective.. TIA

 

[wcburton]

You should not have to do anything to the server. Are you saying you are having problems connecting to the database engine from SSMS on your PC? Or were you unsure about installing the SSMS on your local PC?

When you start SSMS and get the login prompt for the server, the server name drop down has an item to <browse for more...>. This will scan your local network for servers with the proper port open for connection. It does not need to read your ODBC settings to find them.