>>
>>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...