I have just moved from Vista to Windows 7 with my development environment and ALL OF A SUDDEN my web app cannot connect to the local SQL Server instance
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
Funily enough, SQL Management studio express can connect fine. The connection string im using is:
Provider=SQLOLEDB.1;User ID=sa;Initial Catalog=mydatabase;Data Source=.\myinstance;Password=xxx
Does anyone have any idea as to why?