After having problems with import/export because of SSIS not in MS SQL Express, I had to uninstall all the MS SQL Express database, and replace it with the new MS SQL 2005 Standard.
Everything when well for the import/export. The problem is that my ASPNETDB.MDF settings in Visual Studio 2005 is changing the connection source all the time to the old EXPRESS.
What I did is :
1- right click the database ASPNETDB.MDF.
2- modify connection
3- change data source to "Microsoft SQL Server (SqlClient)"
4- check the box "always use this section"
Everytimes I close Visual Studio, then the data source change back to "Microsoft SQL Server database file" which correspond to the old EXPRESS. Therfore I have to re-configure it to MSSQLServer again.
What is going on, and how to fix this unvoluntary change?