Simcfc73 Posted October 10, 2012 Posted October 10, 2012 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 Posted October 10, 2012 Posted October 10, 2012 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 Posted October 13, 2012 Posted October 13, 2012 What about when IIS is 6.5 and on another server?
nickbro Posted October 13, 2012 Posted October 13, 2012 You can customize the sql connection string, see ConnectionStrings.com - Forgot that connection string? Get it here!
Edu-IT Posted October 13, 2012 Posted October 13, 2012 I'm on about this. http://www.edugeek.net/showthread.php?t=102667
nickbro Posted October 13, 2012 Posted October 13, 2012 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 Posted October 13, 2012 Posted October 13, 2012 So there's no need for all that setting the user up as IIS AppPool?
ragbuster Posted October 13, 2012 Posted October 13, 2012 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.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now