MSSQLSERVER Login failed for user '' after upgrade

Anycase anyone still intrested I managed to fix it with the 2.0 script, something with the check to use the providers fails unless you have OLE DB driver installed and it tries to use username/password which aren’t configured.
I simply marked down all the if and only left the connection line which solved it:

'If Not AUTH.Exists(“type”) or AUTH(“type”) = “system” Then
CONN.Properties(“Integrated Security”).Value = “SSPI”
'Else
’ CONN.Properties(“User ID”).Value = AUTH(“username”)
’ CONN.Properties(“Password”).Value = AUTH(“password”)
'End If

2 Likes