>>>
>>>So, I'll post another thread in SQL Server forum in a sec., but just in case, how can I use two connection strings to switch between development/local?
>>>
>>>The connection string is in web.config
>>>
>>
>>
>>I just have them all in config.web and comment out the ones I'm not using like this...
>>
>>

>>		<!-- TEST - SQL2005
			<add key="SqlConnectionString" value="MyConnectionStringTEST"/>
		-->
>>		
>>		<!-- DEBUG - SQL2005
			<add key="SqlConnectionString" value="MyConnectionStringDEBUG"/>
               -->
>>	
>>		<!-- DEV - SQL2005
			<add key="SqlConnectionString" value="MyConnectionStringDEV"/>
                -->
>>		
>>		<!-- Local DB	SQL 2K
			<add key="SqlConnectionString" value="MyConnectionStringLOCAL2K"/>
		-->
>>		
>>		<!-- Local DB	SQL 2005 -->
>>			<add key="SqlConnectionString" value="MyConnectionStringTESTLOCAL2005"/>
>>
>>

>>
>>Bruce
>
>Thanks a lot. Since I'm so dumb that I can not even add a user, I specified Windows Authentication for now for my local tests and got pass the first stage. Now at least I can start testing...

You are welcome. It is frustrating when there is so much new to learn. I told a co-worker yesterday, "I am learning so much new stuff, I'm amazed that my head just doesn't explode!". I have the advantage of doing maintenance on an existing app, but I am afraid I am learning many NOT best-practices. We are re-writing it one piece at a time and doing a lot of refactoring.