• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Troubleshooting

Remote Database Connection Problems

Q1:Access hangs or throws an error message when you attempt to connect to a remote MSDE or SQL Server database.
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).

Another common cause of connection failures is incorrect spelling of the server name when you create the alias. The SQL Server Client Network Utility doesn't test for existence of the server when you define the server alias.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint