Prev   Next

Back to the top of the FAQ

Q. SQLOLEDB connection string, and useful MS articles

A. Should be of the form:

ConnectionString="Provider=SQLOLEDB.1;Password=WebUser1;
Persist Security Info=True;User ID=WebUser1;
Initial Catalog=VideoQuota;Data Source=MMS-ITVMEDIA;
Integrated Security=SSPI"
Also see this useful article from Microsoft:
Q247931: Authentication Methods for Connections to SQL Server in Active Server Pages
and
Q176379: IIS and SQL Server on Separate Machines with Trusted Connection

Also see How to setup SQL database on a different machine.

Back to the top of the FAQ

Prev   Next