Como colocar login en una bd SQL en el enterprise manager

[GatoNegro]

chequea estos connections strings
Standard Security:"Driver={SQL Server};Server=Aron1;Database=pubs;Uid=sa;Pwd=asda sd;"


Trusted connection:"Driver={SQL Server};Server=Aron1;Database=pubs;Trusted_Connect ion=yes;"



Prompt for username and password:

oConn.Properties("Prompt") = adPromptAlways
oConn.Open "Driver={SQL Server};Server=Aron1;DataBase=pubs;"