How to configure server machine to accept remote SQL server connections
Posted on 2006-05-16
I have a machine with SQL server running on it, and another machine that needs to access this data.
I am trying to set up a DSN on the remote machine to connect to this SQL server.
When I use the ODBC utility in the control panel, and attempt to add a System DSN, this SQL Server
does not seem to be visible. The two computers are connected by a LAN. The SQL Server uses
Windows Authentication. From remote machine I can see the server machine's filesystem, though the
only visible folder is Printers. I have created an account on the server machine with the same username
and password as the account on the remote machine.
What do I need to do on the server machine to make the SQL Server visible?
Incedentally, going the other way around works fine (i.e. from the server machine I can see an instance of
SQL Server running on the remote machine).