HAP SQL Login Tracker Problem

[J_Worth]

Hello,

 

Been trying to get SQL Login Tracker working but for some reason the following page is displayed when logging on to the site.

 

The SQL database is hosted on a different server to the HAP server. I have put the following into the Web.config to specify the SQL Connection to no avail:

 

"SQLConnectionString" connectionString="Server=SQL2\HAP;Database=hap_DB;User Id=hapDB_user;Password=;"

 

If anyone has any bright ideas, I would be most grateful.

 

J.Worth

[nickbro]

Have you run the hap.sql script in the app_data folder to create the tables?

[nickbro]

Can you post the tracker section of the hapConfig.xml file please

[J_Worth]

Attached to this post is a screenshot showing the tables that have been created in the HAP database.

 

Below is the tracker section from the hapConfig.xml file:

 

 

Thanks for your prompt reply

[nickbro]

Set the provider in the tracker to "SQLConnectionString"

[J_Worth]

I have now changed it to SQLConnectionString in hapConfig.xml. However, I am now getting a Login Failed error. I have double checked the password and the hapDB_user has owner permissions to the HAP database.

 

Are there any other permissions/configuration that needs to be done.

 

Your help is very much appreciated.

 

Thanks again.

[nickbro]

shouldn't do, that should be it.

 

Have a look at Evonet | Setting up SQL Server 2008 for an ASP.NET website on IIS 7.0 - To set up SQL Authentication

 

Under Database Role Membership select db_datareader (and db_datawriter if your users are performing INSERT and UPDATE SQL queries).

[J_Worth]

Got it working!

 

I didn't have Windows & SQL Authentication selected on the properties of the SQL Instance. Once I changed it to that, it worked straight away!

 

Thank you very much for all your help - much appreciated.

 

J.Worth.

[nickbro]

Brilliant news