Troubleshooting

Remote Database Connection Problems

Access hangs or throws an error message when I attempt to connect my project to an instance of SQL Server running on a server.

There are many causes for connection failures to remote databases, the most obvious being network problems. Verify that you can connect to the server PC and open server shares with Explorer. If you can connect to a server share but not the database, and your network runs NetBEUI and TCP/IP protocols, you probably have a TCP/IP problem. Use Control Panel's Network tool, disable the NetBEUI protocol, and verify the TCP/IP settings for your network interface card (NIC).