I use the Microsoft Access 2010 front end with linked tables when installing SQL Server 2012. Local Area Network. When Access starts, a VBA script is launched that connects to the SQL server and performs some checks. I recently upgraded from SQL Server 2008 to 2012, when communications between the client and server began to break intermittently.
When the connection between my client and server fails, I see a general message, "SQL Server does not exist or is not available for access." This is described in the Microsoft support article http://support.microsoft.com/kb/328306 . The potential causes described in this article are not consistent with the problem I am facing.
This connectivity issue is intermittent. The problem occurs about 3 times a week and lasts about 30 minutes at a time. Between these 30-minute crashes, the system works perfectly.
My Current VBA Connection String: (tried several times to fix the problem):
Dim conn As ADODB.Connection
Set conn = New ADODB.Connection
conn.Open "Provider=SQLOLEDB;Server=Server3.companydomain.local;Database=My_Database;Trusted_Connection=Yes"
I hope I can find something in the SQL Server logs (which I have access to), but I don’t know which log file I should examine.
source
share