Unable to Connect to SQLSERVER14 Database in VB script connection is not open in Windows Authentific
Function objOpenADODBConnectionToDBSSPI(m_strDBServer, m_strDBName) 'Declare Variables Dim objConn 'create the ADODB.Connection and Open the connection Set objConn = CreateObject("ADODB.Conne...
Hi ,
If I understand correctly, you are trying to connect to the database using the Windows authentication. I would say that you cannot connect because of the connection string. It seems to be incorrect.
If you need to use the SPI connection, I suppose you need to have a CE device and use the following connection string: https://www.connectionstrings.com/microsoft-data-sqlclient/localdb-named-instance/
If this is a local database, perhaps, the simple connection string like this one (https://www.connectionstrings.com/sqlconnection/trusted-connection-from-a-ce-device/) will be enough.
