Since March
2008, we no longer support SQLExpress engine. If you are not sure if
your website is using SQLExpress and need to perform migrate action,
please check the instructions below.
Please note,
if you are NOT using ASP.NET 2.0 or above, and if your ASP.NET website
does not have dynamic data, such as product information, membership
information, you are most likely not using SQLExpress.
To confirm whether you\'re using sql express database or sql server database, you can follow the following step.
Please check
the web.config file under your domain/application root folder. Look for
keyword "sqlexpress" within this text file, if you are using
SqlExpress, you should find something similar to:
<add
name="ConnectionString" connectionString="Data
Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\datafilename.MDF;Integrated
Security=True;User Instance=True;Initial Catalog=dbname"
providerName="System.Data.SqlClient"/>
(you may find this
keyword, but it's commented out by <!-- -->, in such case this
connection string does not take effect and you are not affected)
If you do
not find the above keyword or a connectionstring specifying SqlExpress,
you are not affected and you can ignore this notification.
To attach the SQL express database,
step1: You will need to go to control panel -> database -> mssql admin -> attach new db
step2: Create an FTP account in the SQL server with the FTP login of [accountid_db],
step3: After
that, you have to download your SQL express database data file from
your web server App_data folder via your FTP account in your web server
with login name of [accountid] Or If you have the SQL express database
in your local computer, you can go directly to step 4
step4: Upload the SQL express database data file to the SQL server using the FTP account you just created in the SQL server
step5: Please attach the database in the SQL server by inputing the database name, database login and database password.
step6: Finally, you have to reconfigure your connection string in your web.config of the file you set your connection string:
change from something like
<add
name="ConnectionString" connectionString="Data
Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\datafilename.MDF;Integrated
Security=True;User Instance=True;Initial Catalog=dbname"
providerName="System.Data.SqlClient"/>
to
<add
name="ConnectionString"
connectionString="Server=SQLServerAddress;Initial
Catalog=DBName;uid=DBLogin;pwd=DBPassword;"
providerName="System.Data.SqlClient" />
where SQLServerAddress is the new SQL database server address designated when you attache the database.