Unable to Connect to SQLSERVER14 Database in VB script connection is not open in Windows Authentific

[Babulu]

Function objOpenADODBConnectionToDBSSPI(m_strDBServer, m_strDBName)

'Declare Variables
Dim objConn

'create the ADODB.Connection and Open the connection
Set objConn = CreateObject("ADODB.Connection")

'Connection String

objConn.ConnectionString = "Provider=SQLOLEDB;Data Source=" & m_strDBServer & ";Initial Catalog=" & m_strDBName & ";Integrated Security=SSPI;"

objConn.Open

'Return the Connection Object
Set objOpenADODBConnectionToDBSSPI = objConn

'Reltease memory from the objec
Set objConn = Nothing

End Function

[YuriPeshekhonov · Accepted solution]

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. 

[Babulu]

Thanks for the information. I found the issue because we were used sqlserver 2012 database now they are upgrade the database so we need to update the sql server driver.

https://docs.microsoft.com/en-us/archive/blogs/sqlreleaseservices/released-microsoft-ole-db-driver-f...

once we are update the driver then its working fine.