The following error was occured in the process of creating localhost installation of a live-site. I followed the instruction of the training video and don't know what and where is wrong. Can anyone help please? Thank you in advance. Server Error in '/takezycom' Application. -------------------------------------------------------------------------------- Keyword not supported: 'initial;catalog'. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.ArgumentException: Keyword not supported: 'initial;catalog'. Source Error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below. Stack Trace: [ArgumentException: Keyword not supported: 'initial;catalog'.] System.Data.Common.DbConnectionOptions.ParseInternal(Hashtable parsetable, String connectionString, Boolean buildChain, Hashtable synonyms, Boolean firstKey) +4907604 System.Data.Common.DbConnectionOptions..ctor(String connectionString, Hashtable synonyms, Boolean useOdbcRules) +98 System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) +55 System.Data.SqlClient.SqlConnectionFactory.CreateConnectionOptions(String connectionString, DbConnectionOptions previous) +24 System.Data.ProviderBase.DbConnectionFactory.GetConnectionPoolGroup(String connectionString, DbConnectionPoolGroupOptions poolOptions, DbConnectionOptions& userConnectionOptions) +200 System.Data.SqlClient.SqlConnection.ConnectionString_Set(String value) +62 System.Data.SqlClient.SqlConnection.set_ConnectionString(String value) +4 System.Data.SqlClient.SqlConnection..ctor(String connectionString) +24 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) +234 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, CommandType commandType, String commandText) +48 Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteReader(String connectionString, String spName, Object[] parameterValues) +279 DotNetNuke.Data.SqlDataProvider.TestDatabaseConnection(String ConnectionString, String Owner, String Qualifier) +86 DotNetNuke.Data.SqlDataProvider.GetProviderPath() +104 DotNetNuke.Common.Globals.GetStatus() +72 DotNetNuke.Common.Initialize.InitializeApp(HttpApplication app) +385 DotNetNuke.Common.Initialize.Init(HttpApplication app) +152 DotNetNuke.HttpModules.RequestFilter.RequestFilterModule.FilterRequest(Object sender, EventArgs e) +674 System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +68 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75 -------------------------------------------------------------------------------- Version Information: Microsoft .NET Framework Version:2.0.50727.3074; ASP.NET Version:2.0.50727.3074

You have a semicolon between initial and catalog in your connection string. Note that there are two connection strings and both must be correct.

Thanks Joe. it was solved. but, another problem appeared. When I browser to http://localhost/mycom, it directed me to the live-site instead of localhost site. What was missing in the process? I recalled that there was something missing when to assign the security permission to the localhost DNN intallation files. That was the ASPNET was not listed for selection, as a result, the ASP.NET machine account was not in the group user and could not be assigned the 'full control" permission. I am not sure whether that was the cause of the current problem. I will be appreciated if you can provide solutions for both issues. Thank you.

If your site is redirecting, that probably means that you haven't adjusted the portalalias table to point to the live url.

The problem is that it redirected to the live url when browser to localhost/mycom. that means that i cannot access/logon onto the localhost/mycom. Can you please breakdown the steps how to solve the problem?

I am assuming that you have two databases:  one for the live site and one for the localhost site.

The portalalias table for the localhost site should point to the localhost url.  The portalalias table for the live site should point to the live site's url.

If you cannot get into the localhost site, you will have to fix this by going into the database using SQL Management Studio or express version.

I followed the instruction of every step in issue 22 training video and I think there is only one database on my localhost/pc downloaded/backuped from live-site with the same db name. I was also confused what was missing caused the localhost site didn't point to the localhost url. Is that anything to do with the missing of ASP.NET machine account in the group user when assigning to the security of the localhost installation as I mentioned in the previous post? Thank you for help.

If you have one database only, then you probably don't want to try to use it with the localhost site AND the live site.  Pick one and use it there.  You probably want to use it for the live site.  If you want to develop using a local site, it will be best to make a copy of the database, and use that locally.

This shouldn't be related to permissions.  If permissions are incorrect, you will find that the site doesn't work correctly for some file-related actions.

Thanks Joe. It was solved. I made an error by accidentally using two versions of servers associated with DNN 9.3.2 and 5.0.1 respectively on local and live-site. That actually meant there were two db as you indicated. I downloaded the updated db from live site and installed in the local pc and it works then.