Search results
16 cze 2021 · I get a runtime error 3709 when trying to connect via VBA to a SQL Server using Windows authentication. The problem occurs on this line: .ActiveConnection = conn. Here is the complete code used to connect: Dim strConn As String. Dim wsReport As Worksheet. Dim col As Integer. strConn = "Provider=SQLOLEDB;"
21 wrz 2023 · This article series helps you troubleshoot the most common SQL Server connectivity issues and describes the tools and methods you can use for troubleshooting. If multiple SQL Server instances in your environment are impacted, or the issue is intermittent, it usually indicates Windows policy or networking issues.
19 sie 2021 · I have always been successful in connecting my VBA solutions in MS Access as a client to my company’s SQL Server, but I struggled for a long time to figure out how to connect to a SQL Server Express LocalDB instance on my personal computer until now.
16 maj 2018 · After the new windows 10 update (may 10) my program cant connect to the sql server anymore. The executable is on a shared folder on another computer. I've tried to run it as administrator, disabled the firewall, but doesnt work. i googled, found: nothing.
17 lut 2012 · For your setup, it sounds like all you need to use is the server name. On the other hand, if you have a named instance (for example, multiple instances of SQL Server on one PC), the FOLDER might be an instance name such as COMP1\SERVER2.
8 gru 2022 · Some connection attempts generate error messages when the connection fails. Examples include ‘the EMS System encountered a problem,’ ‘protocol error in TDS Stream’ and ‘unknown token received from SQL Server’.
21 mar 2011 · Problem. Sometimes you may have issues connecting to SQL Server and you may get messages such as the following: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible.
