Hei,

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?

Thanks

Did you change web.config? That's got the normal connection string.

Yes, I have modified my web.config like this:

<connectionStrings>

  <remove name="LocalSqlServer"/>
    <add name="LocalSqlServer" connectionString="Data Source=motemape;Initial Catalog=AgroDatabase;Integrated Security=True;AttachDBFilename=|DataDirectory|aspn etdb.mdf" providerName="System.Data.SqlClient"/>

</connectionStrings>

AgroDatabase: is my database name.
motemape: is my Server name.
aspnetdb.mdf: is the database file located in App_Data folder

After modifying the connection, I get this name on Visual Studio:

motemape.AgroDatabase.dbo.

But after closing and restarting Visual Studio, it's get back to:

ASPNETDB.MDF "With Microsoft SQL Server database file"

instead of keeping the "Microsoft SQL Server (SqlClient).

click on start ---> programs ---> Microsoft Visual Studio 2005 ---> Visual Studio tools ---> Visual Studio 2005 Command Prompt then type this command :
sqlcmd -E -S .\YourSQLServerName
Once you are in the sqlcmd program, you run the following command to attach the database:
sp_attach_db "DatabaseName", "full path to your mdf file"
go

example:

sp_attach_db "aspnetdb", "c:\Websites\TheBeerHouse\App_Data\AspNetDB.md f"
go

when your database is attached reconfigure visual studio 2005 again from server explorer.

cheers