VB/SQL Server 2005 connection string, Windows authentication

Question

I have an old Word 2000 macro (VB6 script).  It connected to Server 2000 database using server authentication.

Now I want to connect to a Server 2005 db, using Windows authentication if possible.  The old string that worked is:

Provider=SQLOLEDB;Data Source='(local)';Initial Catalog='<catalog name>';User ID='sa';Password='<sa's password>'

Can I use Windows authentication?  If so, what do I use for [User ID] and [Password]?  I tried '' for both and it didn't work.

Moreover, where in the world can I find a comprehensive discussion on how to use and setup these blasted connection strings?  I've been to www.connectionstrings.com and it's just a bit sparse on details...

Answer 1

You should be able to replace it with:

 

Provider=SQLOLEDB;Data Source='(local)';Initial Catalog='<catalog name>';Integrated Security = SSPI;