SQL Server 2005 local on my PC

I just upgraded my website with Discount.asp to utilize SQL Server 2005. It works great online.

My problem is that I have a copy of my website and database installed on my computer. I need to be able to properly connect to it as a development environment.

here's what I have:
Windows XP SP2
IIS version 5.1
SQL Server 2005 Express
Website written in Classic ASP

Originally the database was created with SQL Server 2000 but I migrated to 2005.

I attached the database to my SQL 2005 Express.

I have tried several SQLOLEDB connect strings but none of them seem to work. I even created an ODBC connection that utilizes NT validation (I think) that connects fine from within the ODBC client tool, but I cannot connect with my code.

I tried "DSN=DSN_KOFCRI" but it failed.

When I installed SQL Express I don't remember a username and password being created per se, I think it's utilizing my NT validation. What do I have to do to make my web code work?

I don't want to have to connect to Discount ASP (which works) but would cause me problems since I would be in a dev mode and could easily break the real website!

Thanks in advance for your help,
Paul

 

Hi,
I've created some Webcasts for this, more available per request.
http://www.dasptv.com/
http://www.iis7test.com/webcasts/

What I would recommend is for you to install SQL Server 2008 Express.
With it you can pump data with the Import/Export wizards.
The previous Express versions didn't allow that, you could only have one connection at a time in them.
Need any more tips/help just post.
All the best,
Mark