by default where username is "
[email protected]" is the admin, so default username and password is
[email protected] / pass
You also can find the admin password to login as administrator
here are the tables to check customer info.
select * from [dbo].[Customer]
Select * from [dbo].[CustomerPassword]
select * from [dbo].[Customer_CustomerRole_Mapping]
-- CustomerRole.id=customer_id
select * from [dbo].[CustomerRole]
following query will fetch all customer, now check where [CustomerRole].Name='[CustomerRole]'
you will get all admin info.
save following join as view in your SQL
=====================================
SELECT dbo.Customer.Id, dbo.Customer.Username, dbo.Customer_CustomerRole_Mapping.CustomerRole_Id, dbo.CustomerPassword.CustomerId, dbo.CustomerPassword.Password, dbo.CustomerPassword.PasswordFormatId,
dbo.CustomerRole.Name, dbo.CustomerRole.Active, dbo.CustomerRole.IsSystemRole, dbo.CustomerRole.EnablePasswordLifetime, dbo.Customer.Email
FROM dbo.Customer INNER JOIN
dbo.Customer_CustomerRole_Mapping ON dbo.Customer.Id = dbo.Customer_CustomerRole_Mapping.Customer_Id INNER JOIN
dbo.CustomerPassword ON dbo.Customer.Id = dbo.CustomerPassword.CustomerId INNER JOIN
dbo.CustomerRole ON dbo.Customer_CustomerRole_Mapping.CustomerRole_Id = dbo.CustomerRole.Id