|
Obaid
|
Posted Tue 23 Apr 2013
|
|
Group: Forum Members
Last Active: Sat 20 Jun 2015
Posts: 36,
Visits: 118
|
I followed your instructions for reinstalling Kartris backend.
1) Comment out
<globalization resourceProviderFactoryType="SqlResourceProviderFactory" culture="auto" uiCulture="auto" enableClientBasedCulture="true"/>
2) Then change db name in connection string to a db that does not exeist:
<add name="KartrisSQLConnection" connectionString="Data Source=OBAID-PC\SQLEXPRESS;Integrated Security=True;Initial Catalog=IdoNotExist" providerName="System.Data.SqlClient"/>
3) Ran installation routine. All goes ok and I checked to install sample db.
I have done this a few times but every time it says the user name or password does not exist.
(Yes, 1 and 2 was updated before trying to login)
|
|
|
|
|
Obaid
|
Posted Tue 23 Apr 2013
|
|
Group: Forum Members
Last Active: Sat 20 Jun 2015
Posts: 36,
Visits: 118
|
I see that there is on "Admin" user account in sql management studio
|
|
|
|
|
Mart
|
Posted Wed 24 Apr 2013
|
|
Group: Administrators
Last Active: Wed 18 Nov 2020
Posts: 148,
Visits: 3,450
|
This is likely a permissions issue. The installer (or more correctly the web application it is running as) will likely not have permissions to create a new database.
Its probably easier to
1) setup an empty database with a name via SQL Management Studio.
2) either give the IUSR/App Pool that your web is using permissions to that database, or setup a SQL user on that database and use the username and password and appropriate option during the Kartris install
|
|
|
|
|
Obaid
|
Posted Wed 24 Apr 2013
|
|
Group: Forum Members
Last Active: Sat 20 Jun 2015
Posts: 36,
Visits: 118
|
"not have permissions to create a new database"
But the database with all tables populated gets created every time!
|
|
|
|
|
Obaid
|
Posted Wed 24 Apr 2013
|
|
Group: Forum Members
Last Active: Sat 20 Jun 2015
Posts: 36,
Visits: 118
|
The front end works fine but still the same issue with backend, 'Admin' and/or password not found!
|
|
|
|
|
Mart
|
Posted Wed 24 Apr 2013
|
|
Group: Administrators
Last Active: Wed 18 Nov 2020
Posts: 148,
Visits: 3,450
|
Ah okay... so the installation went fine, this database error isn't during install, its when you try to hit the backend?
|
|
|
|
|
Obaid
|
Posted Thu 25 Apr 2013
|
|
Group: Forum Members
Last Active: Sat 20 Jun 2015
Posts: 36,
Visits: 118
|
Yes, its the backend that is the issue. Frontend loads fine and I get all the sample categories and products.
In sql server, all the tables are there and populated.
When I look at in Security/Users for any of the many sample database I have installed (because I have run the install routine many times) I see the following:
dbo
guest
INFORMATION_SCHEMA
NT AUTHORITY\NETWORK SERVICE
sys
For the actual database sql server instance, OBAID-PC\SQLEXPRESS, in Properties/Security I am using SQL Server and Windows Authentication.
During the installation routine I select Windows Authentication.
|
|
|
|
|
Mart
|
Posted Thu 25 Apr 2013
|
|
Group: Administrators
Last Active: Wed 18 Nov 2020
Posts: 148,
Visits: 3,450
|
But from what you're saying its not the database passwords that are the issue - its the username and password that Kartris creates for you to use the backend? I think that is what you are saying?
These are generated during install and given to you during the install process. Did you get those?
|
|
|
|
|
Obaid
|
Posted Thu 25 Apr 2013
|
|
Group: Forum Members
Last Active: Sat 20 Jun 2015
Posts: 36,
Visits: 118
|
Yes, I have these. Here is the latest one.
Username Admin
Password e3Ea$[}G
and in the table tblKartrisLogin Admin is there with "Login_Password" as "+0jBS68V8EQ48eoFTQuItVm0JzgJ+ctxC2fZ2pzWWIM="
I also note down the hash salt key displayed at the end of installation:
Hash Salt Key:244246ad-b4ff-432e-a208-baab5563a9eb
|
|
|
|
|
Obaid
|
Posted Thu 25 Apr 2013
|
|
Group: Forum Members
Last Active: Sat 20 Jun 2015
Posts: 36,
Visits: 118
|
Sorry if I was not clear. But yes, the problem is with "Admin" user created by Kartris to login to the backend.
|
|
|
|