Logon Tracker - SQL user

[Simcfc73]

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?

 

[nickbro]

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

[Edu-IT]

What about when IIS is 6.5 and on another server?

[nickbro]

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

[Edu-IT]

I'm on about this. http://www.edugeek.net/showthread.php?t=102667

[nickbro]

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

 

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

[Edu-IT]

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

[nickbro]

Not for IIS6.5

[ragbuster]

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.