More in this section

Forums / General Discussions / Sitefinity 5 Error Cannot open user default database

Sitefinity 5 Error Cannot open user default database

2 posts, 0 answered
  1. Nancy
    Nancy avatar
    35 posts
    Registered:
    10 Apr 2012
    30 Apr 2012
    Link to this post
    I am using Sitefinity 5 project manager on a localhost to develop a site. I've had the site running for a few days. When I started up the system this morning, it suddenly cannot connect to the database that it has had no trouble connecting to previously. The error: Cannot open user default database. Login failed.Login failed for user 'windowsbuild\Nancy Rackleff'. I have seen other posts about this and have tried all solutions that I have found an none have worked. I made sure that the windowsbuild\Nancy Rackleff user has full permissions on the Sitefinity.mdf and Sitefinity_log.ldf files. I also downloaded and installed the SQL Server Manager and made sure I was not otherwise connected to the database in case there were too many connections. Any other ideas?

    Stack trace if it will help:
    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: Telerik.OpenAccess.RT.sql.SQLException: Cannot open user default database. Login failed.
    Login failed for user 'windowsbuild\Nancy Rackleff'.

    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: 

    [SQLException: Cannot open user default database. Login failed.
    Login failed for user 'windowsbuild\Nancy Rackleff'.]
       Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.connect(ConnectionString connectionString, IDictionary driverProps, ConnectionPoolType poolType, LogEventStore pes) +1551
       OpenAccessRuntime.Relational.sql.SqlDriver.InitializeFor(ConnectionString connectionString, Boolean noConnect, PropertySet props, DBDriver& driver, Connection& conn, ConnectionPoolType poolType) +387
    
    [DataStoreException: Cannot open user default database. Login failed.
    Login failed for user 'windowsbuild\Nancy Rackleff'. Telerik.OpenAccess.RT.sql.SQLException: Cannot open user default database. Login failed.
    Login failed for user 'windowsbuild\Nancy Rackleff'.
       at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.connect(ConnectionString connectionString, IDictionary driverProps, ConnectionPoolType poolType, LogEventStore pes)
       at OpenAccessRuntime.Relational.sql.SqlDriver.InitializeFor(ConnectionString connectionString, Boolean noConnect, PropertySet props, DBDriver& driver, Connection& conn, ConnectionPoolType poolType)]
       DynamicModule.ns.Wrapped_OpenAccessMetaDataProvider_e024712f6f88472e832b686c2e37daae.Initialize(String providerName, NameValueCollection config, Type managerType) +405
       Telerik.Sitefinity.Data.ManagerBase`1.InstantiateProvider(IDataProviderSettings providerSettings, Type providerType, ExceptionPolicyName policy, ManagerBase`1 manager) +1972
       Telerik.Sitefinity.Data.ManagerBase`1.InstantiateProvider(IDataProviderSettings providerSettings, ExceptionPolicyName policy, ManagerBase`1 manager) +74
       Telerik.Sitefinity.Data.ManagerBase`1.SetProvider(String providerName, String transactionName) +526
    
    [TargetInvocationException: Exception has been thrown by the target of an invocation.]
       System.RuntimeTypeHandle.CreateInstance(RuntimeType type, Boolean publicOnly, Boolean noCheck, Boolean& canBeCached, RuntimeMethodHandleInternal& ctor, Boolean& bNeedSecurityCheck) +0
       System.RuntimeType.CreateInstanceSlow(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache) +117
       System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipVisibilityChecks, Boolean skipCheckThis, Boolean fillCache) +247
       System.Activator.CreateInstance() +88
       Telerik.Sitefinity.Data.ManagerBase`1.GetManager(String providerName, String transactionName) +120
       Telerik.Sitefinity.Services.SystemManager.Initialize() +232
       Telerik.Sitefinity.Abstractions.Bootstrapper.RegisterRoutes(RouteCollection routes) +307
       Telerik.Sitefinity.Abstractions.Bootstrapper.Bootstrap() +386
       Telerik.Sitefinity.Web.SitefinityHttpModule.Init(HttpApplication context) +116
       System.Web.HttpApplication.InitModulesCommon() +192
       System.Web.HttpApplication.InitInternal(HttpContext context, HttpApplicationState state, MethodInfo[] handlers) +1504
       System.Web.HttpApplicationFactory.GetNormalApplicationInstance(HttpContext context) +348
       System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext context) +200
       System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +286
  2. Nancy
    Nancy avatar
    35 posts
    Registered:
    10 Apr 2012
    01 May 2012
    Link to this post
    A little more info. I have created a couple more projects and this has happened each time. When I try to view the files in SQL Server Management Studio, here is the exact error: "The specified file is either not a valid SQL Server Compact file or it is corrupted. Would you like to repair it?" I say yes and then I can see it. In the left pane of Management Studio there is a tree. "Tables" is the first item. When I click to open it, it has "System Tables" inside, but no tables listed. Should I see tables?
2 posts, 0 answered