+ Post New Thread
Results 1 to 9 of 9
Home Access Plus+ Thread, Logon Tracker - SQL user in Projects:; Hi, I am trying to install the apppool\hap user to the database users but have installed SQL 2012 and the ...
  1. #1

    Join Date
    Nov 2005
    Location
    North
    Posts
    1,809
    Thank Post
    24
    Thanked 91 Times in 71 Posts
    Rep Power
    50

    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?

    Logon Tracker - SQL user-untitled-1.jpg

  2. #2
    nickbro's Avatar
    Join Date
    Jul 2010
    Location
    Gilwern, Wales
    Posts
    3,469
    Thank Post
    37
    Thanked 483 Times in 415 Posts
    Rep Power
    109
    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

  3. #3

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,088
    Thank Post
    402
    Thanked 618 Times in 565 Posts
    Rep Power
    180

    Logon Tracker - SQL user

    What about when IIS is 6.5 and on another server?

  4. #4
    nickbro's Avatar
    Join Date
    Jul 2010
    Location
    Gilwern, Wales
    Posts
    3,469
    Thank Post
    37
    Thanked 483 Times in 415 Posts
    Rep Power
    109
    You can customize the sql connection string, see ConnectionStrings.com - Forgot that connection string? Get it here!

  5. #5

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,088
    Thank Post
    402
    Thanked 618 Times in 565 Posts
    Rep Power
    180

    Logon Tracker - SQL user


  6. #6
    nickbro's Avatar
    Join Date
    Jul 2010
    Location
    Gilwern, Wales
    Posts
    3,469
    Thank Post
    37
    Thanked 483 Times in 415 Posts
    Rep Power
    109
    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;

  7. #7

    Edu-IT's Avatar
    Join Date
    Nov 2007
    Posts
    7,088
    Thank Post
    402
    Thanked 618 Times in 565 Posts
    Rep Power
    180

    Logon Tracker - SQL user

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

  8. #8
    nickbro's Avatar
    Join Date
    Jul 2010
    Location
    Gilwern, Wales
    Posts
    3,469
    Thank Post
    37
    Thanked 483 Times in 415 Posts
    Rep Power
    109
    Not for IIS6.5

  9. #9

    Join Date
    Nov 2011
    Location
    Somerset
    Posts
    66
    Thank Post
    2
    Thanked 5 Times in 5 Posts
    Rep Power
    6
    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.

SHARE:
+ Post New Thread

Similar Threads

  1. Replies: 5
    Last Post: 29th February 2012, 03:30 PM
  2. No Logon for domain users
    By stevenwba in forum Windows Server 2000/2003
    Replies: 11
    Last Post: 1st March 2010, 08:43 AM
  3. SIMS SQL users problem
    By dyoung5 in forum MIS Systems
    Replies: 1
    Last Post: 26th January 2010, 11:40 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •