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
- Copy the client AppleTalk Net-Library (Dbmsadsn.dll) from the \WINNT\system32 directory of the server to the same directory of a remote computer running Microsoft® Windows NT® or Microsoft Windows® 2000 Services for Macintosh.
- On the remote workstation, start SQL Server Client Configuration.
- If AppleTalk is listed in the Disabled protocols list, click AppleTalk, and then click Enable.
- In the Enabled protocols by order list, click AppleTalk, and then click the up button until AppleTalk is at the top of the list.
- Click OK.
- Attempt an ISQL connection with the AppleTalk service object name.
For example, at the command line, type:
isql -Usa -P -Sservicename
If you can connect with ISQL and execute queries, the server is configured properly 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 an instance of SQL Server. If you attempt to make local connections through the ADSP Net-Library to an instance of SQL Server listening on AppleTalk, you will receive the following network error:
Net-Library error 11: getsockopt().