Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Activity
    Rintagi Development Team
    @rintagi-team
    Please feel free to ask any burning questions here! We are always happy to help.
    Willis
    @willisfu_twitter
    Hi Rintagi support, I found some database related problems when running Rintagi Installer.
    Willis
    @willisfu_twitter
    When I left "Server Inistance" empty as the sample screenshot showned in "Initial-Setup" web page, one error message "Please enter the data server name and try again" was pop-up.
    Willis
    @willisfu_twitter
    So I filled in "Server Instance" field as "SQLEXPRESS" or "SQLExpress", another one error message "[DBNETLIB][ConnectionOpen (Connect()).]SQL_Server not exist or reject to access" was pop-up. (part of the error message was displayed in Chinese characters, so the message mentioned here is transalted by me)
    My environment is: Winodws 7 + SQL Server 2014 Express.
    Willis
    @willisfu_twitter
    image.png
    Rintagi Development Team
    @rintagi-team
    Hi @willisfu_twitter, thanks for your descriptive question and screenshot. Our engineers are reviewing this problem and will get back to you soon.
    Willis
    @willisfu_twitter
    Ok, thanks!
    Rintagi Development Team
    @rintagi-team
    Hi Willis. Thank you for your question. Regarding your query, kindly try typing .\SQLEXPRESS , in the server instance. Please let me know if you are still facing any trouble.
    Willis
    @willisfu_twitter
    Yes, it works. But I found another problem shown as below after successful deployment.
    image.png
    The detailed words in the login fail page is:
    於 System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) 於 System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) 於 System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions) 於 System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) 於 System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource1 retry, DbConnectionOptions userOptions) 於 System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) 於 System.Data.OleDb.OleDbConnection.Open() 於 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) 於 System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) 於 System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) 於 RO.Access3.LoginAccess.GetLoginSecure(Credential cr) 於 c:\Rintagi\RO\Access3\LoginAccess.cs: 行 219 於 RO.Facade3.LoginSystem.GetLoginSecure(Credential cr) 於 c:\Rintagi\RO\Facade3\LoginSystem.cs: 行 70 於 RO.Web.ModuleBase.AnonymousLogin() 於 c:\inetpub\wwwroot\RO\Web\App_Code\ModuleBase.cs: 行 1482 於 RO.Web.ModuleBase.CheckAuthentication(Boolean pageLoad, Boolean AuthRequired) 於 c:\inetpub\wwwroot\RO\Web\App_Code\ModuleBase.cs: 行 1518 於 RO.Web.ShowPageModule.InitializeComponent() 於 c:\inetpub\wwwroot\RO\Web\modules\ShowPageModule.ascx.cs: 行 86 於 RO.Web.ShowPageModule.Page_Init(Object sender, EventArgs e) 於 c:\inetpub\wwwroot\RO\Web\modules\ShowPageModule.ascx.cs: 行 68 於 System.Web.UI.Control.OnInit(EventArgs e) 於 System.Web.UI.Control.InitRecursive(Control namingContainer) 於 System.Web.UI.Control.InitRecursive(Control namingContainer) 於 System.Web.UI.Control.InitRecursive(Control namingContainer) 於 System.Web.UI.Control.InitRecursive(Control namingContainer) 於 System.Web.UI.Control.InitRecursive(Control namingContainer) 於 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
    Rintagi Development Team
    @rintagi-team
    Hi Willis, For your initial login kindly use as shown below.
    image.png
    @willisfu_twitter The system initially sets up a username and password. UserName - John Doe , Password - JohnDoe .
    Please use this to open your system.
    Willis
    @willisfu_twitter
    Sorry, I don't explain my problem clearly. When I entered "localhost/ro" in my browser, it showed the login fail page as described before. So I have no chance to enter the initial username/password as John Doe.
    Rintagi Development Team
    @rintagi-team
    @willisfu_twitter , Hi Willis.. thank you for sending the information. Can you kindly check in sql sever - under login , if the newuser has the can login to the database Please find below the images to help you .
    image.png
    image.png
    @willisfu_twitter Please let us know if you are still facing any issues.
    Willis
    @willisfu_twitter
    I still face the same problem. Following please find the screenshots captured from my computer.
    image.png
    image.png
    Rintagi Development Team
    @rintagi-team
    Hi @willisfu_twitter . Sorry you are facing this problem. it is purely a login issue.
    Can you please a couple of these below checks to see if it has been setup correctly.
    1. Can you login into SSMS using the newuser login and password (newuser123)
    image.png
    1. Please open the web.config file in the C:\inetpub\wwwroot\RO\Web and search for newuser, you will find the encrypted password below the newuser line. Make a copy of this password
    now go to http://localhost/ro/EncryptPwd.aspx and type in the password for newuser (newuser123) in the Before Encryption: field,
    and click on Encrypt, a encrypted password is shown, please compare this with the password in web.config . It should be the same.
    Please let us know if this does not work as expected . Thank You
    Willis
    @willisfu_twitter
    I can login into SSMS using the newuser login and password (newuser123), but the browser showed the same error page as before after I access http://localhost/ro/EncryptPwd.aspx. The error page is shown below.