Credentials Issue : Not able to login

[nishantbharathan]

Hi, downloaded the project but unable to login. The below credentials are not working. Username: admin Password: password

Please tell me what to do..need to check the mega menu stuff in this project Help !

[gg3orgiev]

Hi nishantbharathan,

The credentials are correct. Did you receive any Authentication Exception on login or just incorrect credentials validation error? Could you check the Logs under ~/App_Data/Sitefinity/Logs and let me know if there are any records ?

Regards, Georgi

[AkshayGaur]

Hi gg3orgiev, I am also getting the same issue. Gives me incorrect credentials validation error. And below is the log file details under ~/App_Data/Sitefinity/Logs. Please what may be the exact issue. thanking you !

Message: Error writing diagnostics data: Telerik.OpenAccess.Exceptions.DataStoreException: The user instance login flag is not supported on this version of SQL Server. The connection will be closed. Telerik.OpenAccess.RT.sql.SQLException: The user instance login flag is not supported on this version of SQL Server. The connection will be closed. ---> System.Data.SqlClient.SqlException: The user instance login flag is not supported on this version of SQL Server. The connection will be closed. at 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) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource1 retry) at System.Data.SqlClient.SqlConnection.Open() at OpenAccessRuntime.Intellitrace.OpenConnection(DbConnection connection, String connectionString, String id) at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.connect(ConnectionString connectionString, PropertySet driverProps, ConnectionPoolType poolType, LogEventStore pes) --- End of inner exception stack trace --- at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.connect(ConnectionString connectionString, PropertySet driverProps, ConnectionPoolType poolType, LogEventStore pes) at OpenAccessRuntime.Relational.sql.SqlDriver.InitializeFor(ConnectionString connectionString, Boolean noConnect, PropertySet props, DBDriver& driver, Connection& conn, ConnectionPoolType poolType) ---> Telerik.OpenAccess.RT.sql.SQLException: The user instance login flag is not supported on this version of SQL Server. The connection will be closed. ---> System.Data.SqlClient.SqlException: The user instance login flag is not supported on this version of SQL Server. The connection will be closed. at 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) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionClosed.TryOpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource1 retry) at System.Data.SqlClient.SqlConnection.Open() at OpenAccessRuntime.Intellitrace.OpenConnection(DbConnection connection, String connectionString, String id) at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.connect(ConnectionString connectionString, PropertySet driverProps, ConnectionPoolType poolType, LogEventStore pes) --- End of inner exception stack trace --- at Telerik.OpenAccess.RT.Adonet2Generic.Impl.DBDriver.connect(ConnectionString connectionString, PropertySet driverProps, ConnectionPoolType poolType, LogEventStore pes) at OpenAccessRuntime.Relational.sql.SqlDriver.InitializeFor(ConnectionString connectionString, Boolean noConnect, PropertySet props, DBDriver& driver, Connection& conn, ConnectionPoolType poolType) --- End of inner exception stack trace --- at OpenAccessRuntime.ExceptionWrapper.Throw() at OpenAccessRuntime.storagemanager.StorageManagerFactoryBuilder.createSmfForURL() at OpenAccessRuntime.storagemanager.StorageManagerFactoryBuilder.createStorageManagerFactory() at OpenAccessRuntime.DataObjects.PersistenceManagerFactoryImp.createStorageManagerFactory() at OpenAccessRuntime.DataObjects.PersistenceManagerFactoryBase.init() at OpenAccessRuntime.DataObjects.PersistenceManagerFactoryImp.init() at OpenAccessRuntime.DataObjects.BootstrapPMF.getPersistenceManagerFactory(PropertySet props) at OpenAccessRuntime.Helper.getPersistenceManagerFactory(PropertySet props) at OpenAccessRuntime.DatabaseAdapter.AssertPersistenceManagerFactory(String usr, String password, Boolean open) at OpenAccessRuntime.DatabaseAdapter.GetObjectScope(TransactionProvider provider) at Telerik.OpenAccess.Database.GetObjectScope(TransactionProvider provider) at Telerik.OpenAccess.OpenAccessContextBase.GetScope() at Telerik.OpenAccess.OpenAccessContextBase.SaveChanges(ConcurrencyConflictsProcessingMode failureMode) at Telerik.Sitefinity.Diagnostics.Data.OpenAccessContextWrapper.SaveChanges() at Telerik.Sitefinity.Diagnostics.Impl.DataAccessLogWriter.PersistPerformanceSamples(ConcurrentQueue`1 buffer) at Telerik.Sitefinity.Diagnostics.Impl.DataAccessLogWriter.TimerElapsed()

---

[gg3orgiev]

Hi AkshayGaur,

What version of SQL Server are you using ? Based on the exception you provided, your SQL Server Version does not support the user instance attribute. Could you please try to remove the "User Instance=true" attribute from your DataConfig.config under ~/App_Data/Sitefinity/Configurations. Then recycle the application pool, clean the Logs folder. Attach the database manually all over again and attempt to login. If any errors persist, let me know.

Regards, Georgi

[AkshayGaur]

Hello Georgi,

Thanks for your help, finally it is working .

Can you tell What thing is required for mega menu actually i need to implement in my application and i run your application it is what i want but i am not able to understand how you implemented.

Can you guide me.

Thanks In Advance

[AkshayGaur]

Hello Georgi,

One more query , this example is created in sitefinity version10.1.6500.0 and my application version 8.2.5941.0 so please let me know how can I or can i implement mega menu in my application.

Thanks