Database migration error on shared server for umbraco website

Using Umbraco 7

I uploaded the umbraco 7 website on a shared server. Its working fine with .sdf file but while I am trying to set new connection string to database in web.config (migrated the database from sdf file using webmatrix) , showing error.

Server Error in '/' Application.

Error running Reader:
SQL Statement:
SELECT id, domainName FROM umbracoDomains ORDER BY id

Exception:
System.ArgumentException: Keyword not supported: 'server'.
  at System.Data.SqlServerCe.SqlCeConnectionStringBuilder.set_Item(String keyword, Object value)
  at System.Data.Common.DbConnectionStringBuilder.set_ConnectionString(String value)
  at System.Data.SqlServerCe.SqlCeConnectionStringBuilder..ctor(String connectionString)
  at System.Data.SqlServerCe.SqlCeConnection.set_ConnectionString(String value)
  at SQLCE4Umbraco.SqlCeContextGuardian.EnsureOpenBackgroundConnection(String connectionString)
  at SQLCE4Umbraco.SqlCeContextGuardian.Open(String connectionString)
  at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)

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: SqlCE4Umbraco.SqlCeProviderException: Error running Reader:
SQL Statement:
SELECT id, domainName FROM umbracoDomains ORDER BY id

Exception:
System.ArgumentException: Keyword not supported: 'server'.
  at System.Data.SqlServerCe.SqlCeConnectionStringBuilder.set_Item(String keyword, Object value)
  at System.Data.Common.DbConnectionStringBuilder.set_ConnectionString(String value)
  at System.Data.SqlServerCe.SqlCeConnectionStringBuilder..ctor(String connectionString)
  at System.Data.SqlServerCe.SqlCeConnection.set_ConnectionString(String value)
  at SQLCE4Umbraco.SqlCeContextGuardian.EnsureOpenBackgroundConnection(String connectionString)
  at SQLCE4Umbraco.SqlCeContextGuardian.Open(String connectionString)
  at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)

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:


[SqlCeProviderException: Error running Reader: 
SQL Statement:
SELECT id, domainName FROM umbracoDomains ORDER BY id

Exception:
System.ArgumentException: Keyword not supported: 'server'.
   at System.Data.SqlServerCe.SqlCeConnectionStringBuilder.set_Item(String keyword, Object value)
   at System.Data.Common.DbConnectionStringBuilder.set_ConnectionString(String value)
   at System.Data.SqlServerCe.SqlCeConnectionStringBuilder..ctor(String connectionString)
   at System.Data.SqlServerCe.SqlCeConnection.set_ConnectionString(String value)
   at SQLCE4Umbraco.SqlCeContextGuardian.EnsureOpenBackgroundConnection(String connectionString)
   at SQLCE4Umbraco.SqlCeContextGuardian.Open(String connectionString)
   at SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters)]
   SqlCE4Umbraco.SqlCeApplicationBlock.ExecuteReader(String connectionString, CommandType commandType, String commandText, SqlCeParameter[] commandParameters) +409
   SqlCE4Umbraco.SqlCEHelper.ExecuteReader(String commandText, SqlCeParameter[] parameters) +26
   umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +161

[SqlHelperException: Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader]
   umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters) +361
   umbraco.cms.businesslogic.web.Domain.<GetDomains>b__0() +148
   Umbraco.Core.Cache.<>c__DisplayClass1`1.<GetCacheItem>b__0() +15
   System.Lazy`1.CreateValue() +497
   System.Lazy`1.get_Value() +14338318
   Umbraco.Core.Cache.HttpRuntimeCacheProvider.GetCacheItem(String cacheKey, Func`1 getCacheItem, Nullable`1 timeout, Boolean isSliding, CacheItemPriority priority, CacheItemRemovedCallback removedCallback, CacheDependency dependency) +798
   Umbraco.Core.Cache.HttpRuntimeCacheProvider.GetCacheItem(String cacheKey, Func`1 getCacheItem, Nullable`1 timeout, Boolean isSliding, CacheItemPriority priority, CacheItemRemovedCallback removedCallback, String[] dependentFiles) +200
   Umbraco.Core.Cache.CacheProviderExtensions.GetCacheItem(IRuntimeCacheProvider provider, String cacheKey, Func`1 getCacheItem, Nullable`1 timeout, Boolean isSliding, CacheItemPriority priority, CacheItemRemovedCallback removedCallback, String[] dependentFiles) +264
   umbraco.cms.businesslogic.web.Domain.GetDomains(Boolean includeWildcards) +421
   Umbraco.Web.Routing.PublishedContentRequestEngine.FindDomain() +257
   Umbraco.Web.Routing.PublishedContentRequestEngine.PrepareRequest() +18
   Umbraco.Web.UmbracoModule.ProcessRequest(HttpContextBase httpContext) +503
   System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +92
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +165

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.34212

Copy Link

Jan Skovgaard 11280 posts 23678 karma points MVP 10x admin c-trib

Mar 14, 2015 @ 14:38

Hi Ganesh and welcome to our :)

Are you certain that connection string is correct? It would help if you could post the exact error message you're seeing in here please.

Remember to set <customErrors mode="off"> in the web.config file if you have not done so already. Otherwise you'll just see a message telling you to do this.

/Jan

Copy Link

Ryan Nguyen 27 posts 80 karma points

Apr 17, 2015 @ 21:48

Did you guys resolve this problem?

Thanks

Ryan

Copy Link

is working on a reply...

Flag this post as spam?

Database migration error on shared server for umbraco website

Server Error in '/' Application.