Problem with log-in using SetDatabaseLogon()

[rnooraei]

Hi
This syntax is working with ACCESS database

crReport.SetDatabaseLogon("bar_adm", "******")

Now I migrated the database to SQL SERVER and the syntax shoulb like

crReport.SetDatabaseLogon("bar_adm", "******", "KINGSTON", "BAR_TEST")

but I can not log in to database. here is my connection string
<add name="BARSQLConnectionString" connectionString="Data Source=KINGSTON;Initial Catalog=BAR_TEST;Persist Security Info=True;User ID=bar_adm;Password=******"
providerName="System.Data.SqlClient" />

any help appreciated.

Thanks

 

[bigfoot]

Did you find this yet, rnooraei?

Connection strings can get weird. Try UID and PWD in place of User ID and Password and see if that helps.

I'm home and can't see my code at the moment.