i set up a login (reviewer) under security for SQL SERVER

and under the specific database i set up a User (qcvalues\_reviewer) that references this login

i have tried all these different ways to login into the database from vba:

```
 'cn.Open "Provider=SQLOLEDB;Data Source=hermes;Initial Catalog=test;User ID=qcvalues_reviewer; Password=92127; Trusted_Connection=yes"

 'cn.Open "Provider=SQLOLEDB;Server=hermes;Database=test;User Id=qcvalues_reviewer;Password=92127;"

 'cn.Open "Provider=SQLOLEDB;Data Source=hermes;Initial Catalog=test;User Id=qcvalues_reviewer;Password=92127;"

 'cn.Open "Provider=SQLOLEDB;Data Source=10.20.10.18,1433;Network Library=DBMSSOCN;Initial Catalog=test;User ID=qcvalues_reviewer;Password=92127;"

```

each time i get the error message:

```
login failed for user 

```

can someone please help me connect!