If you are migrating from SQL Express to SQL 2005 server you will need to change your connection string in the web config file to contain the following values: <connectionStrings> <clear /> <add name="[Cnct String Name]" connectionString="Data Source=[Your Sql Server]; initial catalog=[Your Database Name]; user ID=[Your User Name]; password=[Your Password]" providerName="System.Data.SqlClient" /> </connectionStrings> Replace the values ([Your Database Name], [Your User Name], [Your Password]) with your own database values. You specify these when you create your database in Dot Net Panel. The value [Your Sql Server] should be the IP address of your Sql Server as specified in the database settings in helm control panel Replace the value [Cnct String Name] with the name of the connection string that your ASP.NET application is expecting. This varies by ASP.NET application. Some common applications and connection string names: Commerce Starter Kit 2.0: 2 identical connection strings named "CommerceTemplate" and "LocalSqlServer" DotNetNuke: SiteSqlServer. Also, in App Settings, there is a key named "SiteSqlServer" that should have the same connection string. Note: Do not add a semi-colon (;) at the end of your connection string! Leave the last semi-colon out ... otherwise, you may encounter issues when the SqlClient parses the connection string.
Did you find this article useful?