Friday, May 21, 2010

SQL Server 2008 & Access 2007 ODBC Connectivity Issue "delay in opening server connection" - Resolution

I had this nagging problem while attempting to create a linked table in Access 2007 to a SQL Server 2008 database.

For me, it turned out to be a firewall issue.  Basically, on the machine hosting the SQL Server database, I added an exception for the TCP port on which the SQL Server configured (port 1433 by default).  You can check the exact port in SQL Server Configuration Manager.

 If you try this and still have problems, consult this more thorough checklist.

No comments: