Hi,

I need to move Umbraco to a new server. I restored the database onto the new server, copied the website across, however I'm getting the following error:

Login failed for user <name of user>

The user does exist in the database, and the stacktrace possibly tells a different story:

Umbraco Exception (DataLayer): SQL helper exception in ExecuteReader
   at umbraco.DataLayer.SqlHelper`1.ExecuteReader(String commandText, IParameter[] parameters)
   at umbraco.cms.businesslogic.web.Domain.<GetDomains>b__0()

   at umbraco.cms.businesslogic.cache.Cache.GetCacheItem[TT](String 
cacheKey, Object syncLock, CacheItemPriority priority, 
CacheItemRemovedCallback refreshAction, CacheDependency cacheDependency,
 TimeSpan timeout, GetCacheItemDelegate`1 getCacheItem)
   at 
umbraco.cms.businesslogic.cache.Cache.GetCacheItem[TT](String cacheKey, 
Object syncLock, CacheItemPriority priority, CacheItemRemovedCallback 
refreshAction, TimeSpan timeout, GetCacheItemDelegate`1 getCacheItem)

   at umbraco.cms.businesslogic.cache.Cache.GetCacheItem[TT](String 
cacheKey, Object syncLock, CacheItemRemovedCallback refreshAction, 
TimeSpan timeout, GetCacheItemDelegate`1 getCacheItem)
   at 
umbraco.cms.businesslogic.cache.Cache.GetCacheItem[TT](String cacheKey, 
Object syncLock, TimeSpan timeout, GetCacheItemDelegate`1 getCacheItem)
   at umbraco.cms.businesslogic.web.Domain.GetDomains()
   at umbraco.cms.businesslogic.web.Domain.Exists(String DomainName)
   at umbraco.requestHandler.CreateXPathQuery(String url, Boolean checkDomain)
   at umbraco.requestHandler..ctor(XmlDocument umbracoContent, String url)
   at umbraco.UmbracoDefault.Page_PreInit(Object sender, EventArgs e)
   at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e)
   at System.EventHandler.Invoke(Object sender, EventArgs e)
   at System.Web.UI.Page.PerformPreInit()
   at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Any ideas?