Database setup

Posted by Community Admin on 04-Aug-2018 04:35

Database setup

All Replies

Posted by Community Admin on 18-Dec-2017 00:00

My apologies if posting on incorrect topic but there is no Setup topic thread... I am a newby to sitefinity and am having trouble getting the it setup... I am on Win10/SQLExpress and below is the error I get. the user that I am logged in as is admin on machine and SQLExpress.

Server Error in '/' Application.

Login failed for user 'sysadmin'.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.Data.SqlClient.SqlException: Login failed for user 'sysadmin'.

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 (0x80131904): Login failed for user 'sysadmin'.] System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData, DbConnectionPool pool, String accessToken, Boolean applyTransientFaultHandling) +821 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) +332 System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions) +38 System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) +507 System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) +154 System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) +21 System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) +90 System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) +209 System.Data.SqlClient.SqlConnection.Open() +96 OpenAccessRuntime.Intellitrace.OpenConnection(DbConnection connection, String connectionString, String id) +85 Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.connect(ConnectionString connectionString, PropertySet driverProps, ConnectionPoolType poolType, LogEventStore pes) +424 [SQLException: Login failed for user 'sysadmin'.] Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.connect(ConnectionString connectionString, PropertySet driverProps, ConnectionPoolType poolType, LogEventStore pes) +643 OpenAccessRuntime.Relational.sql.SqlDriver.InitializeFor(ConnectionString connectionString, Boolean noConnect, PropertySet props, DBDriver& driver, Connection& conn, ConnectionPoolType poolType) +296 [AuthorizationException: Login failed for user 'sysadmin'.] DynamicModule.ns.Wrapped_OpenAccessMetaDataProvider_5254e080d7634074baa6c61ba650767f.Initialize(String providerName, NameValueCollection config, Type managerType) +184 Telerik.Sitefinity.Data.ManagerBase`1.InstantiateProvider(IDataProviderSettings providerSettings, Type providerType, ExceptionPolicyName policy, Type managerType) +416 Telerik.Sitefinity.Data.ManagerBase`1.InstantiateProvider(IDataProviderSettings providerSettings, ExceptionPolicyName policy, Type managerType) +57 Telerik.Sitefinity.Data.ManagerBase`1.SetProvider(String providerName, String transactionName) +315 Telerik.Sitefinity.Data.ManagerBase`1..ctor(String providerName, String transactionName) +146 Telerik.Sitefinity.Data.Metadata.MetadataManager..ctor() +12 [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, StackCrawlMark& stackMark) +119 System.RuntimeType.CreateInstanceDefaultCtor(Boolean publicOnly, Boolean skipCheckThis, Boolean fillCache, StackCrawlMark& stackMark) +247 System.Activator.CreateInstance() +117 Telerik.Sitefinity.Data.ManagerBase`1.GetManager(String providerName, String transactionName) +85 Telerik.Sitefinity.Data.OA.OpenAccessConnection.InitializeProvider(IOpenAccessMetadataProvider provider, String connectionName, Boolean safeMode) +487 Telerik.Sitefinity.Data.Decorators.OpenAccessDecorator.InitializeDatabase(DataProviderBase dataProvider, NameValueCollection config) +103 Telerik.Sitefinity.Data.Decorators.OpenAccessDecorator.Initialize(String providerName, NameValueCollection config, Type managerType) +17 Telerik.Sitefinity.Data.DataProviderBase.Initialize(String providerName, NameValueCollection config, Type managerType, Boolean initializeDecorator) +980 Telerik.Sitefinity.Security.Data.MembershipDataProvider.Initialize(String providerName, NameValueCollection config, Type managerType) +2184 Telerik.Sitefinity.Web.UI.Backend.StartupWizard.CreateInstantProvider(String providerName, String connectionString, IDataProviderSettings settings) +641 Telerik.Sitefinity.Web.UI.Backend.StartupWizard.CreateInstantProvider(String providerName, String connectionString, ConfigElementDictionary`2 providers) +92 Telerik.Sitefinity.Web.UI.Backend.StartupWizard.GetMembershipProvider() +74 Telerik.Sitefinity.Web.UI.Backend.AdministratorPane.CreateChildControls() +1785 System.Web.UI.Control.EnsureChildControls() +92 System.Web.UI.WebControls.CompositeControl.get_Controls() +16 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +24 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +204 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +144 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +204 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +144 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +204 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +144 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +204 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +144 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +204 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +144 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +204 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +144 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +204 System.Web.UI.Control.LoadChildViewStateByIndex(ArrayList childState) +144 System.Web.UI.Control.LoadViewStateRecursive(Object savedState) +204 System.Web.UI.Page.LoadAllState() +464 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +1743 

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

Posted by Community Admin on 20-Dec-2017 00:00

Hi Alan,

I do not know if there are any issues with your configuration, but I have some suggestions for troubleshooting. Maybe they will help you arrive at the cause of the issue.

1. Check that your SQL express instance has been set up properly. For example, can you launch SQL Server Management Studio and connect using Windows Authentication as SysAdmin? Normally this works but it is worthwhile to confirm.

2. Another test would be to configure a new user in SQL Express with SQL Authentication. Grant this user Admin rights in SQL. Then configure SiteFinity to user this other user. Go to the DataConfig.config file in \\your project name\App_Data\Sitefinity\Configuration. Edit the connection string to use your new login

<add connectionString="data source=ALANSWINBOX;uid=alan;PWD=1234;initial catalog=SiteFInityDBName " providerName="System.Data.SqlClient" dbType="msSql" name ="SiteFinity" />

3) Reset IIS and then run your test again to see what happens. If you get the same error message then ignore authentication as this isn't the issue

 

This thread is closed