Classic ASP - SQL Server 2008 Connection String using Windows Authentication

Here's an easy way to generate connection strings that work.

1. Right-click an empty spot on the desktop and choose NEW, TEXT DOCUMENT from the context menu

2. Save it with a .udl extension, and click yes when it asks are you sure.

3. Double-click the new udl file you just created. It will open a dialogue. Go to the Provider tab, and choose the appropriate provider.

4. Go to the Connection tab and fill in the server name and database name, and choose NT authentication (or use a specific username and password, which is SQL authentication). Now click Test Connection. If it works, you're ready to click OK and move on to the final step. If it doesn't you need to resolve permission issues, or you've mis-typed something.

5. Now right-click the file on the desktop and open it in notepad. It will display the connection string that you can copy and paste to wherever you need it.

I assume you have the 2008 Native Client installed? Also, I noticed that you're missing the "provider" tag at the beginning - do you have any more luck with this one:

Provider=SQLNCLI10.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=climb4acure;Data Source=(local);

Have you had a look at connectionstrings.com? They are a pretty good reference (but, in my experience, they don't work too well in the Google Chrome browser).