How to make SQL Connection String revert to mixed-mode security?

[ryansupak]

Hi, I'm trying to write an SQL connection string into a third-party application.

The SQL database I'm attempting to connect to uses mixed-mode security, and I do not have access to any actual SQL passwords.

I'm currently trying to use something like:

"server=TheServer;database=TheDatabase;uid=WindowsUser;pwd=WindowsUserPassword;"

...but it won't authenticate.

So, I need to somehow flag it, I suppose, to revert to mixed-mode security.

I'm imagining adding something like

"UseMixedMode = true"

but I just don't know the syntax.

Any help is appreciated!
rs

 

[spwhite]

Try:

"Provider=SQLOLEDB.1;Integrated Security=SSPI;Initial Catalog=TheDatabase;Data Source=TheServer"