Logon Tracker - SQL user

Hi,

I am trying to install the apppool\hap user to the database users but have installed SQL 2012 and the new user creation is baffling me. When I create the new user it throws a wobby saying there is an invalid character.. when i try and add one using the query builder its saying it can't find krusty\HAP.

Anyone got this working on SQL 2012 who can offer advise?

Attachment 15523

The user should be IIS AppPool\HAP, you should be able to type that user in as is.

The login name can just be HAP

What about when IIS is 6.5 and on another server?

You can customize the sql connection string, see ConnectionStrings.com - Forgot that connection string? Get it here!

I'm on about this. http://www.edugeek.net/forums/home-access-plus/102667-possible-log-access-users-using-hap-home.html

You can use a SQL Connection string to use a different user on the sql server.

So instead of TrustedConnection you use a username and password. This is defined in the web.config file

Code:

---

Server=sqlserver;Database=HAP;User Id=HAP;Password=h4p;

---

So there's no need for all that setting the user up as IIS AppPool?

Not for IIS6.5

I got it to work with using the domain name\netbios name$ of the IIS server.
The $ is important

I did wonder when trying to get around this issue if a user/password could be used in the connection string.