Please leave any questions you may have and our support team will get to you as soon as possible!
The first step is to check if the new user login has been created in SQL Server.
*Try to login into SQL Server Management Studio(SSMS) under the SQL Authentication
using the "newuser" and "newuser123".
*If you are unable to login, you would need to login into SSMS using the windows
authentication and create a new login called "newuser".
*Set up the access to the newly created database for "newuser".
*Logout of SSMS and try logging in again using the newly created login and password.
* If you are able to successfully open the RC databases you are set and now please
try accessing localhost/rc.
*During installation, SQL Server Database Engine is set to either Windows
Authentication mode or SQL Server and Windows Authentication mode.
* After installation, you can change the authentication mode at any time.
*We need to use the SQL Server and Windows Authentication mode . Most
likely during installation of the SQL server only the Windows
Authentication was selected,instead of the mixed mode.
*Login into Sql Server Management Studio using your Windows Authentication login.
*In SQL Server Management Studio Object Explorer, right-click the server,
and then click Properties.
* On the Security page, under Server authentication, select the new server
authentication mode, and then click OK.
* In the SQL Server Management Studio dialog box, click OK to acknowledge
the requirement to restart SQL Server.
* In Object Explorer, right-click your server, and then click Restart.
If SQL Server Agent is running, it must also be restarted.
Hi, i have the same Problem like user Willis had in 2017. During installation i get about 12 to 15 times message saying that something could not be converted. But installation runs successfully.
When I open URL localhost/ro it says Login Failed for user (MySQLCredentials).
I can Login to SSMS by using my SQLCredentials correctly.
Here is the web.config line:
<add key="DesPassword" value="Xf2lSUcFzM+UtYwcIHsyBw==" />
The passwords do match exactly.
Today I installed a test machine:
During Rintagi installation I had about 10 errors saying something could not be converted.
First call of Website http://localhost/ro still gave same error as mentioned in my older posts (login failed for user MySQLCredentials).
I checked SQL-Table dbo.systems for password match with web.config (correct) and also db-owner role (correct).
Login to SSMS was okay using user/pass.
I guess its either a problem with the connection string in web.config or its a problem with password encryption/decryption. On the other hand i don't understand the 10 conversion-errors during installation.
Here is the detail to the error message:
bei System.Data.OleDb.OleDbConnectionInternal..ctor(OleDbConnectionString constr, OleDbConnection connection) bei System.Data.OleDb.OleDbConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) bei System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions) bei System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) bei System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource
1 retry, DbConnectionOptions userOptions) bei System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) bei System.Data.OleDb.OleDbConnection.Open() bei System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) bei System.Data.Common.DbDataAdapter.Fill(DataTable[] dataTables, Int32 startRecord, Int32 maxRecords, IDbCommand command, CommandBehavior behavior) bei System.Data.Common.DbDataAdapter.Fill(DataTable dataTable) bei RO.Access3.LoginAccess.GetLoginSecure(Credential cr) in c:\Rintagi\RO\Access3\LoginAccess.cs:Zeile 219. bei RO.Facade3.LoginSystem.GetLoginSecure(Credential cr) in c:\Rintagi\RO\Facade3\LoginSystem.cs:Zeile 70. bei RO.Web.ModuleBase.AnonymousLogin() in c:\inetpub\wwwroot\RO\Web\App_Code\ModuleBase.cs:Zeile 1482. bei RO.Web.ModuleBase.CheckAuthentication(Boolean pageLoad, Boolean AuthRequired) in c:\inetpub\wwwroot\RO\Web\App_Code\ModuleBase.cs:Zeile 1518. bei RO.Web.ShowPageModule.InitializeComponent() in c:\inetpub\wwwroot\RO\Web\modules\ShowPageModule.ascx.cs:Zeile 86. bei RO.Web.ShowPageModule.Page_Init(Object sender, EventArgs e) in c:\inetpub\wwwroot\RO\Web\modules\ShowPageModule.ascx.cs:Zeile 68. bei System.Web.UI.Control.OnInit(EventArgs e) bei System.Web.UI.Control.InitRecursive(Control namingContainer) bei System.Web.UI.Control.InitRecursive(Control namingContainer) bei System.Web.UI.Control.InitRecursive(Control namingContainer) bei System.Web.UI.Control.InitRecursive(Control namingContainer) bei System.Web.UI.Control.InitRecursive(Control namingContainer) bei System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
Update:
I got Rintagi to run with the following installation method:
Webserver = Hostname_of_Machine (NOT localhost)
Client Tier = C:\Rintagi\RO\Web
Regular Web Service Tier = C:\Rintagi\RO\ROWs
XLS Import Tier = C:\Rintagi\RO\WsXls
Rule Tier = C:\Rintagi\RO
Server Instance = Hostname_of_Machine\SQLEXPRESS
Then I can Access the Site under http://hostname_of_machine/RO and Login with John Doe.
Rintagi won't run with these configurations:
a) When Client Tier, Regular Web Service Tier and XLS Tier point to a directory under C:\inetpub ---> I receive the old errors.
b) When I use "localhost" instead of the hostname ---> I receive the old errors.
Now up to the next step:
I prepared and compiled the development package "Rintagi as Developer" and I get the install.exe and two other files.
I installed it on the same machine with the XX Namespace and following configuration:
Webserver = Hostname_of_Machine (NOT localhost)
Client Tier = C:\Rintagi\XX\Web
Regular Web Service Tier = C:\Rintagi\XX\XXWs
XLS Import Tier = C:\Rintagi\XX\WsXls
Rule Tier = C:\Rintagi\XX
Server Instance = Hostname_of_Machine\SQLEXPRESS
When I enter the Site http://hostname/XX I receive the error message: "stored procedure "GetLoginSecure" cannot be found.
So, what's next?
I figured it out. The Problem is as follows:
The new created database xxDesign does not contain the following database objects:
I exported these from the original RODesign Database, changed database names in the objects and imported them into the new xxdesign database. Now I am able to log into the new XX namespace. I will test it out and see whats next.
Hi Kibrom,
my suggestion is to read carefully through the software prerequisites and check if you installed the correct versions of the prerequisites.
You might want to install newer versions, but in my case that did not work at all. Only the prerequisites and module versions mentioned by rintagi really worked.
Also use the correct hostname of your computer to configure Rintagi and to enter the development sites. Since Microsoft updates in Windows 7/8/10/Server do not recommend to use loopback "localhost" anymore due to security and performance reasons you should not use it in your configuration.
If your config is correct, check out SQL permissions / security settings in SQL Server. You can check for Event errors in windows System log for further errors.