Ok... so I installed SQL 2005 for developers, since that's what our server is using, ran the scripts to get the database, and even imported the data through my VPN last night.
Now when my software goes to connect, it says:
System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.
WHAT THE .... 2 days I've been simply trying to get a local copy of the database so I can play around with it!!!
Is it something different with 2005? I can connect to (local) on another computer (running SQL 2005), why not this one!!?!
Here's my connection string:
"user id=***;password=***;data source=(local);persist security info=False;initial catalog=OrderProcessing"