Need help setting up dev environment

I'm working on different windows machines and virtual windows machines on a mac. I have a project wich uses SQL server and AD for autentication.

Right now I have to be connected to VPN so that the asp.net web application can conn开发者_开发百科ect to AD using LDAP string to autentivate users, I also have the SQL server on the other side of the VPN connection.

Is there any way to setup my enviroment so that I can work locally without the AD, and on a local SQL server and be able to publish the project without manually changing the web.config file?

You can make some publish profiles, they affect your web.config automatically when you select the profile.

Seen Here Hope I can help you a bit !