Bug reports Found a bug? Post it here please.
Version 4.x > Bug reports > can't login run kentico any more... View modes: 
User avatar
Member
Member
rookie07 - 5/20/2009 2:50:44 AM
   
can't login run kentico any more...
i'm evaluation kentico and integrated it into an existing site (or vice versa). i hade to create CMSInlineControls in order to put them into the BlankASPX template.

the CMSInlineControls are about a custom newsletter wherefore i needed some custom tables which i createdt successfully.
in one of these forms i'm using an asp:ListBox. i wanted to add a datasource declarativley, so i switched to the desingner-mode and configured a new connection(string) to the sql server mdf-file...

since then i'm not able to log on to the db anymore. if i look via the ms sql-server management studio into the database i can see that the user is attached to the database an has sufficient rights to log on.
in the vwd 2008 (express) ich can also log on an brows the data, what is going wrong?

here is the error-log (unfortunately in german, but one can get the clue out of it):



Server Error in '/KenticoCMS' Application.
[DataConnection.ExecuteQuery]: Query: Proc_CMS_QueryProvider_SelectGeneration: caused exception: Die von der Anmeldung angeforderte "KenticoCMS"-Datenbank kann nicht geöffnet werden. Fehler bei der Anmeldung.
Fehler bei der Anmeldung für den Benutzer 'WS-STEFAN\Administrator'.
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.Exception: [DataConnection.ExecuteQuery]: Query: Proc_CMS_QueryProvider_SelectGeneration: caused exception: Die von der Anmeldung angeforderte "KenticoCMS"-Datenbank kann nicht geöffnet werden. Fehler bei der Anmeldung.
Fehler bei der Anmeldung für den Benutzer 'WS-STEFAN\Administrator'.

Source Error:

Line 159:
Line 160: // Re-initialize tasks which were stopped by application end
Line 161: SchedulingExecutor.ReInitCorruptedTasks();
Line 162: ModuleCommands.NewsletterClearEmailsSendingStatus();
Line 163: EmailInfoProvider.ResetSendingStatus();


Source File: c:\webs\KenticoCMS\App_Code\Global.asax.cs Line: 161

Stack Trace:

[Exception: [DataConnection.ExecuteQuery]: Query: Proc_CMS_QueryProvider_SelectGeneration: caused exception: Die von der Anmeldung angeforderte "KenticoCMS"-Datenbank kann nicht geöffnet werden. Fehler bei der Anmeldung.
Fehler bei der Anmeldung für den Benutzer 'WS-STEFAN\Administrator'.]
CMS.DataProviderSQL.DataConnection.ExecuteQuery(String queryText, Object[,] queryParams, QueryTypeEnum queryType) +1303
CMS.DataProviderSQL.DataConnection.CMS.IDataConnectionLibrary.IDataConnection.ExecuteQuery(String queryText, Object[,] queryParams, QueryTypeEnum queryType) +42
CMS.SettingsProvider.SqlHelperClass.ExecuteQuery(String queryText, Object[,] queryParams, QueryTypeEnum queryType, IDataConnection conn) +102
CMS.SettingsProvider.SqlHelperClass.ExecuteQuery(String queryText, Object[,] queryParams, QueryTypeEnum queryType) +42
CMS.SettingsProvider.QueryProvider.LoadGeneration(Int32 generation) +251
CMS.SettingsProvider.ProviderDictionaryCollection.LoadGeneration(Int32 generation) +48
CMS.SettingsProvider.ProviderDictionaryCollection.LoadDefaultItems() +94
CMS.SettingsProvider.QueryProvider.LoadInfos() +215
CMS.SettingsProvider.QueryProvider.GetQuery(String queryName, IDataConnection conn, Boolean throwException) +36
CMS.DataEngine.GeneralConnection.RunQuery(String queryName, Object[,] parameters, String where, String orderBy, Int32 topN, String columns) +49
CMS.DataEngine.GeneralConnection.ExecuteQuery(String queryName, Object[,] parameters, String where) +48
CMS.Scheduler.TaskInfoProvider.GetTaskToReInit() +61
CMS.Scheduler.SchedulingExecutor.ReInitCorruptedTasks() +70
Global.FirstRequestInitialization(Object sender, EventArgs e) in c:\webs\KenticoCMS\App_Code\Global.asax.cs:161
Global.Application_BeginRequest(Object sender, EventArgs e) in c:\webs\KenticoCMS\App_Code\Global.asax.cs:392
System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +68
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75

User avatar
Kentico Developer
Kentico Developer
kentico_zbysekn - 5/25/2009 7:18:01 AM
   
RE:can't login run kentico any more...
Hello,
well this error seems to be connected with user rights. Please check them once again if you have set them properly, you had to entered wrong connection string or something like that, this problem isn't connected with CMS itself.
Best Regards,
Zbysek Nemec.

User avatar
Member
Member
rookie07 - 6/2/2009 7:24:11 AM
   
RE:can't login run kentico any more...
still can't start kentico-website

the original connectionstring i havn't touched

<add name="CMSConnectionString" connectionString="Persist Security Info=False;Integrated Security=SSPI;database=KenticoCMS;server=WS-STEFAN\SQLEXPRESS;Current Language=English;Connection Timeout=240;" />

the mdf and ldf file has full access for administrator & aspnet (i'm using xp prof)

in the database the authetication seems to be right, it is still possible to access the sql server management studio.

when i try to start the debugger of the vwd express i get the access denied-error for the administartor, when i start call the website via the browser (iis) i get the same erro for the aspnet-user...

this drives me nuts - especially i was about to finish with this site!!!

what would you suggest? export the database and reinstall kentico? (first i have to make a backup of me tools, modules)

thanks!

User avatar
Member
Member
rookie07 - 6/2/2009 8:39:53 AM
   
RE:can't login run kentico any more...
ok weird, i don't know what finally leaded to this but for the moment it is ok.

i just copied the database-files into the app_data directory, set filepermission of total access for user administrator, aspnet and then i used a new connectionstring which usually creates the vwd (express) by its own like:

<add name="CMSConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\KenticoCMS.mdf;Integrated Security=True;User Instance=True" providerName="System.Data.SqlClient"/>

now i can start the app and connect, unfortunately everything works now very slow - from time to time i get a db-timeout...but for the moment this is ok..."$%&%(