Integrated Security & Persist Security Info

[jaydwest]

I'm trying to create a Connection String between an MS Access 2003 Database and SQL Server 2005. I want to use OLEDB as the provider. And use SQL Server Authentication. I have added the UserID and Password to the Connection String. When do I need to use "Integrated Security = SSPI" and "Persist Security Info = true/false"?

Is there a book and KB article that describes how these are used?

Thanks for your help.

 

[SQL_Hell]

Hi there,

Integrated Security = SSPI and Persist Security Info = true/false are connection string settings to be used with Windows accounts, but if you have a user name and password then you are using a sql server account and these settings do not need to be used.