How to verify that SQL Server is listening on AppleTalk and can accept a client connection (Client Network Utility)

To verify that SQL Server is listening on AppleTalk and can accept a client connection

1. Copy the client AppleTalk Net-Library (Dbmsadsn.dll) from the \Mssql7\Binn directory of the server to the same directory of a remote Microsoft® Windows NT®-based computer running the Windows NT Services for Macintosh®.
2. On the remote workstation, start SQL Server Client Configuration.
3. In the Default network library box, on the General tab, change the default network protocol to AppleTalk.
4. Click OK.
5. Attempt an ISQL connection with the AppleTalk service object name. For example:

   isql -Usa -P -Sservicename

     

   If you can connect with ISQL and execute queries, the server is properly configured to listen on AppleTalk and is accepting connections.

Note The Microsoft Win32® AppleTalk (ADSP) client side Net-Library (Dbmsadsn.dll) is included for testing ADSP connections and troubleshooting AppleTalk connections between Macintosh clients and Microsoft SQL Server™. This Net-Library is intended to be used only when testing a connection from a remote client to SQL Server. If you attempt to make local connections through the ADSP Net-Library to a server running SQL Server and listening on AppleTalk, the following network error is generated:

Net-Library error 11: getsockopt().