If you have SQL Server connections to databases on localhost in ASP.NET applications in Dreamweaver MX 2004 and they have suddenly stopped working, or you can’t create new connections, here is one possible reason.

If you installed Windows XP SP2, this breaks the functionality in Dreamweaver which enables you to connect to local SQL Server databases. Handy or what?
Luckily, Macromedia have released an extension to fix this. You can find out more info about the problem and instructions on how to solve it by clicking the link below:

Database connectivity fails with local ASP.NET and ASP servers

I came across a few issues in applying the fix. I got “unable to remove connection scripts: access denied” errors. However, if I manually removed the connection tags from the web.config file that worked. Then I needed to restart Dreamweaver a few times to get all sites to co-operate. Eventually, everything works again…

This entry was posted on Sunday, March 6th, 2005 at 3:44 pm and is filed under .net. You can follow any responses to this entry through the RSS 2.0 feed. You can skip to the end and leave a response. Pinging is currently not allowed.