| Deploying site developed in Visual Web Developer Express |
|
This is to relate some gotchas I encountered while trying to deploy a site developed in Microsoft Visual Web Developer Express.
For the remote site, there are a couple of things that you have to do. First, you have to set up the correct tables on the remote SQL Server. This can be done by invoking the wizard at C:\WINDOWS\Microsoft.NET\Framework\<versionNumber>\aspnet_regsql.exe and following the right prompts. The other thing that you do is to tell your website to go ahead use this remote server. This was a little tricky and I had to struggle a little to find the right method. What you need to do is to edit the web.config file and add the following line in the configuration section <connectionStrings> <remove name="LocalSqlServer"/> <add name="LocalSqlServer" connectionString="Data Source=yoursqlserver;Initial Catalog=yourdatabase;Persist Security Info=True;User ID=youruser;Password=yourpassword" providerName="System.Data.SqlClient"/> <connectionStrings> Here obviously you have to substitute your values for the SQL Server, and so on. |
| < Prev | Next > |
|---|